Karteikarten
Database - Terminology
Karten in diesem Stapel (8)
- 1TablesA table stores all of the records for a particular category
- 2RecordsA record is all of the data or information about one person or one thing.
- 3FieldsA field is one piece of data or information about a person or thing.
- 4Data TypesA data type is specific type of data regarding certain information i.e. currency, data and time, alphanumeric and text etc
- 5Field LengthField length is the number of characters each text field will allow
- 6Primary KeyA Primary key is something that will uniquely identify each record in your database
- 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 uses the value of each foreign key to prevent you from deleting related records
Informationen
- Beschreibung
- Karteikarten am Database - Terminology, erstellt von 11hkitchenham am 11/11/2014.
- Erstellt von
- 11hkitchenham
- Aufrufe
- 10
- Bewertung