Flashcards
Database terminology
Cards in this deck (7)
- 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 thing
- 4Data types How data is stored in a databaseexamples:
text
numbers
currency
date/time
auto number
logical, Boolean, yes/no - 5primary keyall records in a database has something uniquely identify it
- 6foreign 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.
- 7referential integrityit makes sure that the relationship between two tables
Information
- Description
- Flashcards on Database terminology, created by 11alambert on 11/11/2014.
- Created by
- 11alambert
- Views
- 8
- Rating