Karteikarten
Database terminology
Karten in diesem Stapel (7)
- 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 types How data is stored in a databaseexamples:
text
numbers
currency
date/time
auto number
logical, Boolean, yes/no - 5primary keyall records in a database has something uniquely identify it
- 6foreign 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.
- 7referential integrityit makes sure that the relationship between two tables
Informationen
- Beschreibung
- Karteikarten am Database terminology, erstellt von 11alambert am 11/11/2014.
- Erstellt von
- 11alambert
- Aufrufe
- 8
- Bewertung