Flashcards
Sem título
Flashcards do conjunto (8)
- 1TablesDefinition: A table stores all of the records for a particular category
- 2RecordsDEFINITION: A record is all of the data or information about one person or one thing.
- 3FieldsDEFINITION: a '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 etc
- 5field lengthfield length is the number of characters each text will allow
- 6primary keyA primary key is something that will uniquely identify each record in your database
- 7foreign keyDEFINITION: A 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
Informações
- Descrição
- FlashCards sobre Sem título, criado por 11jdymond em 11-11-2014.
- Criado por
- 11jdymond
- Visualizações
- 0
- Avaliação