Flashcards
Database Terminology
Flashcards do conjunto (8)
- 1TableA table stores all the information/records for a particular category.
- 2RecordsA record is all of the data or information about one person or thing.
- 3FieldsA field is one piece of data or information about one person or thing.
- 4Data TypesData comes in different forms. These can include: numerical, alphanumeric, currency, date/time, autonumber & logical/Boolean.
- 5Field LengthDefault lengths are set up in order to fulfil it's purpose for the specific data input. For example, 7 characters for a post code.
- 6Primary KeyA primary key is a way to uniquely identify data. This is sometimes called a 'Key Field'.
- 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 integrityIt prevents you from deleting related records.
Informações
- Descrição
- FlashCards sobre Database Terminology, criado por 11cdownes em 11-11-2014.
- Criado por
- 11cdownes
- Visualizações
- 5
- Avaliação