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
Determining where to store the database is part of the ______.
Physical Design
Represents exactly one instance of the object or event which the table holds details about.
Record
Describes the information contained in the column and should be something that will be easily recognizable.
Field
Request _______ from users to ensure the database is and remains effective.
Feedback
A field’s ______ determines the type of the information that can be stored in that field.
Data type
