Flashcards
Database flashcards
Cards in this deck (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
Information
- Description
- Flashcards on Database flashcards , created by 11hling on 11/11/2014.
- Created by
- 11hling
- Views
- 9
- Rating