Flashcards
Database terminology
Cards in this deck (8)
- 1TableStores all records for particular data
- 2RecordsAll of the data or information about one person or one thing
- 3FieldOne piece of data or information about a person or a thing
- 4Data TypesIs how data is stored within a database
- 5Field LengthThe necessary number of character spaces in a table/form
- 6Primary KeyAll records in a database should have something unique to be identified by
- 7Foreign KeyUsed 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 IntegrityIt makes sure that the relationship between two tables. eg. is synchronized for updating and deletion
Information
- Description
- Flashcards on Database terminology , created by 11hhaysom on 11/11/2014.
- Created by
- 11hhaysom
- Views
- 6
- Rating