Flashcards
Database Theory
Cards in this deck (8)
- 1TableA table stores all of the records for a particular category.
- 2RecordsA 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 Typesthe type of data you enter in a database, e.g text, currency Boolean (two choices) etc.
- 5Field Lengththe amount of characters permitted for a particular field with in the data base (e.g 7 characters in a postcode field.)
- 6Primary KeyA unique number or code to distinguish different people or objects to keep professionalism and to reduce errors.
- 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 IntegrityPrevents you from trying to delete records where the foreign key and primary key are related.
Information
- Description
- Flashcards on Database Theory, created by 11cknight on 11/11/2014.
- Created by
- 11cknight
- Views
- 10
- Rating