Flashcards
Database flashcards
Cards in this deck (8)
- 1TableA table stores all of the records for a particular category
- 2RecordsThe record is all of the data or information about one person or one thing
- 3Fielda field is one piece of data or information about a person or thing.
- 4Data TypesA data type is the type of data you will use in a database e.g numbers, text, currency, date/time
- 5Field lengthA field length is a limited amount of characters for a certain field.
- 6Primary keyA primary key is a unique set of characters for certain people or objects to help identify what or who they are.
- 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 integrityEvery foreign key value has a matching value in the corresponding primary key.
Referential integrity uses these to ensure that there are no orphan records i.e. it prevents you from deleting related records.
Information
- Description
- Flashcards on Database flashcards, created by 11jeharris on 11/11/2014.
- Created by
- 11jeharris
- Views
- 7
- Rating