Flashcards
Database Terms
Cards in this deck (8)
- 1TableDatabases store one type of data or information in tables, in a particular category.
- 2RecordA record is all of the data or information about one person or one thing.
- 3FieldA 'field' is one piece of data or information about a person or thing.
- 4Data typesA type of data which would suit a certain field: text, number, currency, auto-number, date/time, logical/Boolean/yes or no/true or false
- 5Field lengthA 'limited' amount of characters for a certain field.
- 6Primary key (Field key)A single record in a database has something unique to identify it
- 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 every foreign key, which has a matching value corresponding to a primary key, to ensure that there are no orphan records i.e. it prevents you from deleting related records.
Information
- Description
- Flashcards on Database Terms, created by 11pmbaji on 11/11/2014.
- Created by
- 11pmbaji · Nov 2014
- Updated
- Feb 19, 2016
- Views
- 5
- Rating