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 thing.
- 3FieldsA 'field' is one piece of data or information about a person or thing.
- 4Data TypesData comes in many forms: Numerical, Alphanumeric, Currency, Date/Time, Autonumber and Logical/Boolean.
- 5Field LengthFields usually have default lengths, E.g. passwords usually have to be 6 characters.
- 6Primary KeyIt is important that every single record in a database has something to uniquely identify it and this is called the 'Primary Key' or sometimes the 'Key Field'.
- 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 prevents you from deleting related records.
Information
- Description
- Flashcards on Database Terminology, created by 11ccollins on 11/11/2014.
- Created by
- 11ccollins
- Views
- 6
- Rating