Flashcards
Database Terminology
Cards in this deck (8)
- 1TableA table stores all the information/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 one person or thing.
- 4Data TypesData comes in different forms. These can include: numerical, alphanumeric, currency, date/time, autonumber & logical/Boolean.
- 5Field LengthDefault lengths are set up in order to fulfil it's purpose for the specific data input. For example, 7 characters for a post code.
- 6Primary KeyA primary key is a way to uniquely identify data. This is sometimes called a '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 integrityIt prevents you from deleting related records.
Information
- Description
- Flashcards on Database Terminology, created by 11cdownes on 11/11/2014.
- Created by
- 11cdownes
- Views
- 5
- Rating