Flashcards
Database - Terminology
Cards in this deck (8)
- 1TablesA 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.
- 3FieldsA field is one piece of data or information about a person or thing.
- 4Data TypesA data type is specific type of data regarding certain information i.e. currency, data and time, alphanumeric and text etc
- 5Field LengthField length is the number of characters each text field will allow
- 6Primary KeyA Primary key is something that will uniquely identify each record in your database
- 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 the value of each foreign key to prevent you from deleting related records
Information
- Description
- Flashcards on Database - Terminology, created by 11hkitchenham on 11/11/2014.
- Created by
- 11hkitchenham
- Views
- 10
- Rating