Exam 14: Database Design

A computer record is used to store all the information about one transaction, but several such records must be used to store the information about one employee, one inventory part, and so forth, on a master file.

Controls that do not allow users to update the same database record at the same time are examples of:

In the context of databases, the term data redundancy refers to:

Which of these would be an example of an "agent" in the REA framework?

An example of a database cardinality is "one-to-few."

An example of a "one-to-many" relationship is "students to classes."

The Oxford Corporation has the following eleven master files: * Accounts payable $\quad$$\quad$$\quad$ * Raw materials inventory * Accounts receivable $\quad$ $\quad$ *Sales summary * Bill of materials $\quad$$\quad$$\quad$$\quad$ * Vendor history * Finished goods inventory $\quad$ * Work in process inventory * Open production orders $\quad$$\quad$ * Operations list (labor operations and * Open purchase orders $\quad$$\quad$ machine requirements for production) -Master files used to plan and report on the resources required for the coming period are:

In recent years many businesses have formed a common information source within their business organization called a database.One of the advantages of building databases is the simultaneous updating of files with common data elements.Another major advantage of the database concept is that:

An example of a transitive dependency in a database is:

This type of database structure enables users to create relationships after the database has been created and implemented:

Suppose a relationship indicates that a sale is related to one and only one customer.This indicates that:

Within a database context, the relationship between "assigned parking space" and "car" would most likely be:

In an E-R model created using the REA framework, a customer would often be linked to inventory with a relationship that is:

A database is in first normal form if the data it contains is free of errors and outliers.

"Protecting privacy" is an important goal in data modeling.

All of the following are items within the data hierarchy except:

All of these are reasons why databases are important to AISs except:

An example of a transitive relationship in a medical application is the one between "medical procedure code" and "cost of treatment."

The purpose of the E-R model is to help database designers:

The idea behind concurrency control is to deny several users access to the same database record at the same time.