Flashcards
Database Terms
Cards in this deck (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
Information
- Description
- Flashcards on Database Terms, created by 11cmonk on 11/11/2014.
- Created by
- 11cmonk
- Views
- 6
- Rating