Flashcards
Database terminology
Flashcards do conjunto (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
Informações
- Descrição
- FlashCards sobre Database terminology, criado por 11alambert em 11-11-2014.
- Criado por
- 11alambert
- Visualizações
- 8
- Avaliação