Chapter 4a Flashcards
____ the expectations of the user is the first step in database design.
Discussing
The field who’s value uniquely identifies each record on a table is known as the.
Primary
The most common type of data.
Text
You can combine and maintain large amounts of data in one _____ database.
Access
Through _____ a database is scrambled and compacted.
Encryption
To prevent errors or corruptions you must provide users with _____ which include hot to navigate through records and how to add/edit data.
User Documentation
To make your database easier to use, enter a ______ for each field.
Description
Lays the foundation for every database and is limited to a single distinct subject.
Table
Apply the _____ data type when no other field can be the primary key.
Auto number
Creating new fields, changing data type, or moving the location of the database fall under database ______.
Maintenance
A collection of data contained in multiple tables, each similar to each other.
Relational database
A structured collection of data that is stored in a computer system.
Database
Database maintain a great amount of vital information and must be protected from ______ access.
Unauthorized
A valuable resource to any organization, business, or company.
Data
In a database, a ______ exists between common fields on different tables.
Relationship
