+
Related Flashcards
Related Topics
Cards In This Set
| Front | Back |
|
Organizes data as a collection of tables
|
DBMS
|
|
A collection of related tables
|
Relational database
|
|
The specific content of a field
|
Field value
|
|
Connects the records in separate tables
|
Common field
|
|
A single characteristic or attribute of a person,place, object,event, or idea
|
Field
|
|
A primary key from one table that is used to form a relationship with a second table
|
Foreign key
|
|
A collection of fields that describe a person, place, object , event or idea
|
Table
|
|
A field or collectin of fields whose values uniquely identify each record in a table
|
Primary key
|
|
A question you ask about data stored in a database
|
Query
|
|
A formatted printout (or screen display) of the contents of one or more tables
|
Report
|
|
To rearrange the data and objects in a database file, to decrease its file size
|
Compact
|
|
The process of making a copy of the database file to protect your data against loss or damage
|
Back up
|
|
When you store data in more than one place
|
Data redundancy
|
|
Determine what field values you can enter for a field
|
Data type
|
|
Access forces yu to enter a value for the primary key in every record
|
Entity integrity
|
