Flashcards
Database terminology
Cards in this deck (8)
- 1TablesA table stores all of the records for a particular category
- 2RecordA 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 thing.
- 4Data typesa particular kind of data item, as defined by the values it can take, the programming language used, or the operations that can be performed on it.
- 5Field lengthFields usually have default lengths. e.g. password lengths
- 6Primary keyA unique identifier
- 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 information
Information
- Description
- Flashcards on Database terminology, created by 11akeith on 11/11/2014.
- Created by
- 11akeith
- Views
- 7
- Rating