Karteikarten
Database flashcards
Karten in diesem Stapel (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.
Informationen
- Beschreibung
- Karteikarten am Database flashcards, erstellt von 11jeharris am 11/11/2014.
- Erstellt von
- 11jeharris
- Aufrufe
- 7
- Bewertung