Flashcards
Database Technology
Flashcards do conjunto (8)
- 1TablesA Table stores all of the records, information and data for a particular category or topic
- 2RecordsA record is all of the data or information about one person or thing
- 3FieldsA 'Field' is one piece of data or information about a person or thing
- 4Data typesThere are many different forms of data, which include alphanumeric or text, number, currency, date/time, auto number, logical and Boolean.
- 5Field lengthThis is a default field length, which is set up differently in different databases to keep the data base fast, efficient and organised.
- 6Primary KeyA Primary key is a way to uniquely identify data and this is sometimes called a 'key field'.
- 7Foreign keyA foreign key is used to link the tables together and create a relationship. It is a field in one table that is linked to the primary key in another table.
- 8Referential IntegrityIt prevents you from deleting related records.
Informações
- Descrição
- FlashCards sobre Database Technology, criado por 11swright em 11-11-2014.
- Criado por
- 11swright
- Visualizações
- 5
- Avaliação