Question 1

Use the following scenario for the next questions.Suppose that you are developing a relational database for an accounting system using the REA framework approach. The organization makes over-the-counter sales where the customer walks in, an employee (sales rep) sells products to the customer and turns over the products to the customer, and the customer walks out. All sales are on credit, and employees are paid commissions on their sales.
-In the REA framework, which of the following entities are involved in the business process described in the scenario?

Accepted Answer

A)   Inventory, employee, customer, sale
B)   Inventory, product number, invoice number, customer
C)   Employee, product number, customer, sale
D)   Invoice number, product number, customer, sale B

Question 2

What is an insertion anomaly?

Accepted Answer

An insertion anomaly occurs when we attempt to store a value for one data element but cannot because the value of another data element is unknown.

Question 3

Which of the following best describes a transitive dependency?

Accepted Answer

A)   A transitive dependency exists when a nonkey data element depends on a primary key data element.
B)   A transitive dependency exists when a nonkey data element depends on another nonkey data element.
C)   A transitive dependency exists when a primary key data element depends on another primary key element.
D)   A transitive dependency exists when a primary key data element depends on a nonkey element. B

Question 4

The following data apply to the next two questions:Consider the following open purchase order file in which each record contains the following fields:delivery instructionspurchase order datepart numberpurchase order numberquantity orderedunit pricevendor number
 Consider the following open purchase order file in which each record contains the following fields:
 delivery instructions
 purchase order date
 part number
 purchase order number
 quantity ordered
 unit price
 vendor number
-What data elements should be moved to a separate file to put the open purchase order file in the first normal form?

Accepted Answer

A)   Part number, unit price, quantity ordered
B)   Part number, vendor number, purchase order number, quantity ordered
C)   Purchase order number, quantity ordered, part number
D)   Purchase order number, unit price, quantity ordered

Question 5

A table is in the first normal form if it has no transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 6

Converting a table into the second normal form applies to a table that has a composite key.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statements is true about symbols used in the entity-relationship diagram?

Accepted Answer

A)   A line links an attribute to an attribute.
B)   An ellipse represents an attribute.
C)   A diamond represents an attribute.
D)   A square represents an entity.

Question 8

What would be a likely primary key for the customer table?

Accepted Answer

A)   Customer name
B)   Customer code
C)   Invoice number
D)   Invoice date

Question 9

Consider the following elements needed to produce a purchase order (see figure below):
$\begin{array} { l l } 
\text { Purchase order number } & \text { Product number } \
\text { Purchase order date } & \text { Product description } \
\text { Vendor code } & \text { Quantity purchased } \
\text { Vendor name } & \text { Unit cost } \
\text { Vendor address } & \text { Total ordered } \
& \text { Total due }
\end{array}$
 PURCHASE ORDER
Purchase order number: P0156
Purchase order date:Oct 6, 2012
TO: ABC Corporation (C1704) 2500 Bay Area Blvd.
Houston, TX 77058
$\text { Thankyou for your order! }$

$\begin{array}{|l|l|l|l|l|}\hline &&\text { Unit }\\text { Product No}&\text { Description }&\text {Price }&\text {Quantity }&\text {Total }\
\hline \text { F135 } & \text { Excel Book } & \$ 25.00 & 4 & \$ 100.00 \
\hline \text { G1456 } & \text { Using Access } & \$ 35.00 & 10 & \$ 350.00 \\hline &\text { Visio for }\\text { B3429 } & \text { Dummies } & \$ 45.00 & 5 & \$ 225.00 \
\hline & & & & \
\hline & & & & \
\hline & & & & \
\hline & & & & \
\hline \text { Total }&\quad\quad &\quad\quad & \quad\quad&\$675.00\
\hline
\end{array}$ Using the SYSTEM OUTPUT approach, determine the tables needed and put them in third normal form. Be sure to identify primary, foreign, and/or composite (concatenated) keys as necessary. Primary keys and composite keys should be underlined, while foreign keys should be identified with an asterisk. LIST ALL TABLES FOR FIRST, SECOND and THIRD normal forms.

Accepted Answer

The answer of Consider the following elements needed to produce...

Question 10

Which of the following statements concerning entity-relationship modeling is true?

Accepted Answer

A)   It has a strong theoretical base but seldom is used in practice.
B)   It is a method for arranging data elements after the decision has been made to implement a relational database management system.
C)   It involves identifying and documenting the system outputs and the contents of the outputs that are required by users.
D)   The entity-relationship diagram depicting the model is read from top to bottom and cannot be read from bottom to top.

Question 11

The end product of developing a relational database is a set of "rationalized" tables.

Accepted Answer

A) True 
 B)False

Question 12

A database table cannot have duplicate rows because that would be counterproductive to the goal of reducing data redundancy.

Accepted Answer

A) True 
 B)False

Question 13

Use the following tables to answer the next questions. Neither the order in which the data elements are presented in these tables nor the capitalization of the names of the data elements has any significance.Invoice TableInvoice Line TableInventory TableEmployee TableCustomer Table 
Invoice Table
$\begin{array}{|l|l|l|l|}
\hline \text { CustCode } & \text { InvNo } & \text { EmpCode } & \text { InvDate } \
\hline
\end{array}$
Invoice Line Table
$\begin{array}{|l|l|l|}
\hline \text { Qty } & \text { InvNo } & \text { ProdNo } \
\hline
\end{array}$
Inventory Table
$\begin{array}{|l|l|l|}
\hline \text { ProdNo } & \text { Desc } & \text { Price } \
\hline
\end{array}$
Employee Table
$\begin{array}{|l|l|l|}
\hline \text { EmpName } & \text { EmpCode } & \text { CommRate } \
\hline
\end{array}$
Customer Table
$\begin{array}{|l|l|l|}
\hline \text { Name } & \text { City } & \text { CustCode } \
\hline
\end{array}$
-Which of the following would be the primary keys of the first three tables above?

Accepted Answer

A)   CustCode, InvNo, ProdNo
B)   InvNo, InvNo/ProdNo, ProdNo
C)   InvNo/CustCode, ProdNo/Qty, ProdNo
D)   InvDate/InvNo, ProdNo, Desc

Question 14

For an accounting system to be successful, only the system's developers and the organization's accountants must actively participate in developing the database for the accounting system.

Accepted Answer

A) True 
 B)False

Question 15

Converting a table into second normal form (2NF) only applies to a table that has a composite key.

Accepted Answer

A) True 
 B)False

Question 16

One distinct difference in the system output approach and the REA framework approach is that the REA framework approach focuses on identifying the desired system outputs.

Accepted Answer

A) True 
 B)False

Question 17

In the REA framework, entities, resources, and agents are collectively referred to as events.

Accepted Answer

A) True 
 B)False

Question 18

What does converting a table with multiple values into first normal form accomplish?

Accepted Answer

A)   Reduction of data redundancy
B)   Elimination of the risk of errors in the data
C)   Elimination of anomalies
D)   Elimination of data redundancy and elimination of anomalies

Question 19

A method for arranging data elements in a way that reduces anomalies is referred to as which of the following?

Accepted Answer

A)   Internalization
B)   Normalization
C)   Visualization
D)   Assimilation

Question 20

What are the steps required to develop a relational database for an accounting system using the system output approach?

Accepted Answer

The answer of What are the steps required to develop...

Exam 13: Developing a Relational Database for an Accounting Information System

What is an insertion anomaly?

Which of the following best describes a transitive dependency?

A table is in the first normal form if it has no transitive dependencies.

Converting a table into the second normal form applies to a table that has a composite key.

Which of the following statements is true about symbols used in the entity-relationship diagram?

What would be a likely primary key for the customer table?

Which of the following statements concerning entity-relationship modeling is true?

The end product of developing a relational database is a set of "rationalized" tables.

A database table cannot have duplicate rows because that would be counterproductive to the goal of reducing data redundancy.

For an accounting system to be successful, only the system's developers and the organization's accountants must actively participate in developing the database for the accounting system.

Converting a table into second normal form (2NF) only applies to a table that has a composite key.

One distinct difference in the system output approach and the REA framework approach is that the REA framework approach focuses on identifying the desired system outputs.

In the REA framework, entities, resources, and agents are collectively referred to as events.

What does converting a table with multiple values into first normal form accomplish?

A method for arranging data elements in a way that reduces anomalies is referred to as which of the following?

What are the steps required to develop a relational database for an accounting system using the system output approach?