Flashcards
Database flashcards
Flashcards do conjunto (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.
- 3FieldA 'field' is one piece of data or information about a person or thing.
- 4Data typesA data type is the type of data that you will use in a database. eg. numbers, text, currency, date/time, logical, Boolean, Yes/No
- 5Field LengthA field length is a limited amount of characters for a certain field. Minimum or maximum amounts of characters.
- 6Primary KeyA primary key is a unique set of characters that are set for certain people or objects, to help you identify what or who they are.
- 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 IntegrityEvery foreign key value has a matching value in the corresponding primary key.
Referential integrity uses these to ensure that there are no orphan records i.e. it prevents you from deleting related records. It can also alert you when you try and delete a certain record if it is linked to another record.
Informações
- Descrição
- FlashCards sobre Database flashcards, criado por 11choare em 11-11-2014.
- Criado por
- 11choare · nov 2014
- Atualizado
- 19 fev 2016
- Visualizações
- 4
- Avaliação