Flashcards
Database Terms
Flashcards do conjunto (8)
- 1TableDatabases store one type of data or information in tables, in a particular category.
- 2RecordA 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 type of data which would suit a certain field: text, number, currency, auto-number, date/time, logical/Boolean/yes or no/true or false
- 5Field lengthA 'limited' amount of characters for a certain field.
- 6Primary key (Field key)A single record in a database has something unique to identify it
- 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 every foreign key, which has a matching value corresponding to a primary key, to ensure that there are no orphan records i.e. it prevents you from deleting related records.
Informações
- Descrição
- FlashCards sobre Database Terms, criado por 11pmbaji em 11-11-2014.
- Criado por
- 11pmbaji · nov 2014
- Atualizado
- 19 fev 2016
- Visualizações
- 5
- Avaliação