Chapter 4a Review Flashcards
Define a relational database.
A collection of data contained in multiple tables, each similar to each other
What is the first step in database design.
Discussing
What is done before you identify the types of data to store in your database.
Discuss customer expectations
The ________ describes the information contained in a column and should be something that will be easily recognizable.
Field Name
Typing a ______ for each field helps a user input appropriate data into that field.
Description
What is the most common data type?
Text
How many primary keys can there be on a table?
1
What is the relationship, in regards to database?
The shared key between two tables/Common fields on multiple tables.
During the physical design, you must determine where the database will be ______.
Stored
One way to restrict access to a database is to apply a combination of ________ and ________.
Encryption and Password
To prevent data error or corruption within the database, you must provide users with _______ ________.
User Documentation
List two examples of database maintenance.
Create new fields/New data type
