Exam 5: Database Processing

________is a process for ensuring that the tables in a database design are efficient and well- structured.

What is the difference between a personal DBMS and an enterprise DBMS? Give an example of each.

Some employees are frustrated with database applications or are unwilling to share their data, so they prefer to store their data in a ________instead of a database application.

A(n) ___________ data model captures the entities and their relationships in a database application.

When transforming a data model into a database design, designers represent relationships by:

DBMS is just a model of how users view the business world.

Students need to_____________ learn how to data models, because the will be asked which model best captures their world in the future.

A __________ identifies a unique row in a table.

Two popular DBMS products from Microsoft are __________and Access.

__________software assists in creating, maintaining, and manipulating databases.

Removing duplicated data from tables is called __________.

A ________is software that is used to create, process, and administer a database.

A DBMS is software that helps manage the operating system.

After the data model is created, designers should __________.

A database is a self- describing collection of integrated records.

Database integrity problems produce inconsistent answers, but this is easily corrected.

A group of similar records is called a field.

The __________problem is unique to a multi- user database environment.

Normal forms have duplicated data removed.

The most important point to keep in mind when debating which data model is the best one is how well it reflects how the view _____________their world.