Flashcards
Tables
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 a thing.
- 4Data TypesThe type of data that you will use (currency, text, number)
- 5Field LengthChoose the maximum amount of characters per cell.
- 6Primary KeySomething unique to easily identify it (Number of the item in an Argos catalogue)
- 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 integrityThis makes sure that you don't delete a record which is related to another one.
Information
- Description
- Flashcards on Tables, created by 11jbennison on 11/11/2014.
- Created by
- 11jbennison
- Views
- 5
- Rating