Flashcards
Database Terms
Flashcards do conjunto (12)
- 1TableA table stores all of the records for a particular category.
- 2RecordsA record is all of the data or information about one person or thing.
- 3FieldA field is one piece of data or information about a person or thing
- 4Data typesA data type is how data is stored within a data base
- 5Field LengthField Length is the maximum length of data in characters
- 6Primary KeyAll records in a database should have something unique to be identified by
- 7Foreign KeyA foreign key is used to link tables together and create a relationship. It is a field in one table that is linked to the primary key in another table.
- 8Referential IntegrityReferential Integrity makes sure that the relationship between two tables is synchronised
- 9Relational databaseA database that uses a series of tables to store information. Contains related information and are connected with each other.
- 10ProductivityA measure of efficiency of an organisation or employee.
- 11EntityA real world thing about which information needs to be stored and maintained
- 12Entity relationship diagramA diagram that illustrates the between entities in a database
Informações
- Descrição
- FlashCards sobre Database Terms, criado por 11cmonk em 11-11-2014.
- Criado por
- 11cmonk
- Visualizações
- 6
- Avaliação