Karteikarten
Database Terminology
Karten in diesem Stapel (8)
- 1TableA table stores all of the records for a particular category.
- 2RecordsA record is all of the data or information about one person/thing.
- 3FieldsA field is one piece of data or information about one person or thing.
- 4Data TypesA data type can be Text, Numeric, Currency, Date/Time, Autonumber, Logical/Boolean.
- 5Field lengthA field length is how large set of data should be.
- 6Primary keyEvery single record in a database has something to uniquely identify it, this is Primary key
- 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 foreign key to ensure that there is no orphan records, it prevents you from deleting related records
Informationen
- Beschreibung
- Karteikarten am Database Terminology, erstellt von 11tellis am 11/11/2014.
- Erstellt von
- 11tellis
- Aufrufe
- 4
- Bewertung