Flashcards
Database Terminology
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/thing.
- 3FieldsA field is one piece of data or information about one person or thing.
- 4Data TypesA data type can be Text, Numeric, Currency, Date/Time, Autonumber, Logical/Boolean.
- 5Field lengthA field length is how large set of data should be.
- 6Primary keyEvery single record in a database has something to uniquely identify it, this is Primary key
- 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 foreign key to ensure that there is no orphan records, it prevents you from deleting related records
Information
- Description
- Flashcards on Database Terminology, created by 11tellis on 11/11/2014.
- Created by
- 11tellis
- Views
- 4
- Rating