Flashcards
Database - Terminology
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.
- 3FieldsA 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, alphanumeric and text etc
- 5Field LengthField length is the number of characters each text field will allow
- 6Primary KeyA Primary key is something that will uniquely identify each record in your database
- 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 the value of each foreign key to prevent you from deleting related records
Informações
- Descrição
- FlashCards sobre Database - Terminology, criado por 11hkitchenham em 11-11-2014.
- Criado por
- 11hkitchenham
- Visualizações
- 10
- Avaliação