Flashcards
Untitled
Cards in this deck (8)
- 1TablesDEFINITION: A table stores all of the records for a particular category
- 2RecordsDEFINITION: A record is all of the data or information about one person or one thing.
- 3FeildsDEFINITION: a 'field' is one piece of data or information about a person or thing.
- 4Data typesA data type is specific types of data regarding certain information i.e currency, time and text ect.
- 5Field LengthField length is the number of characters each field will allow.
- 6Primary keya primary key is something that will uniquely identify each record in your database.
- 7foreign keyDEFINITION: A 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 Untitled, created by 11mradley on 11/11/2014.
- Created by
- 11mradley
- Views
- 0
- Rating