Flashcards
Database flashcards
Flashcards do conjunto (8)
- 1TableStores all the information for a particular category
- 2RecordsAll the data about one person or one thing
- 3FieldsOne piece of data about a person or thing
- 4Data typesThere are lots of different types of data, for example text, number, currency, date/time, auto number and boolean
- 5Field lengthDetermines how many characters/numbers are able to be inserted
- 6Primary keyAll records in the database has something unique so that they can be identified
- 7Foreign keyUsed to link tables together, it is a field in one table that is linked to the primary key in another table
- 8Referential integrityUses foreign key and its matching primary key to ensure that no related records will be deleted, it can also alert you if you try to delete a record that is related to another one
Informações
- Descrição
- FlashCards sobre Database flashcards , criado por 11hling em 11-11-2014.
- Criado por
- 11hling
- Visualizações
- 9
- Avaliação