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}\) -What is the type of relationship between the invoice table and the invoice line table?

A) One-to-one B) One-to-many C) Many-to-one D) Many-to-many A) One-to-one B) One-to-many C) Many-to-one D) Many-to-many

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 data elements serves as both a primary and a foreign key in the five tables above?

A) InvNo B) CustCode C) EmpCode D) A and B, but not C E) A, B, and C E A) InvNo B) CustCode C) EmpCode D) A and B, but not C E) A, B, and C E

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

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 CustCode InvNo EmpCode InvDate Invoice Line Table Qty InvNo ProdNo Inventory Table ProdNo Desc Price Employee Table EmpName EmpCode CommRate Customer Table Name City CustCode -What is the type of relationship between the invoice table and the invoice line table?

(Multiple Choice)

4.9/5

(39)

Question 21

Tables in a relational database are documented by a data flow diagram.

(True/False)

4.8/5

(42)

Question 22

Briefly describe the approaches used in developing the relational database for an accounting system.

(Essay)

4.8/5

(23)

Question 23

The implementation of a database begins by defining which of the following?

(Multiple Choice)

4.8/5

(34)

Question 24

Which of the following statements regarding normal forms is incorrect?

(Multiple Choice)

4.9/5

(40)

Question 25

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 would be the key for the new file created in Question 10?

(Multiple Choice)

4.9/5

(42)

Question 26

What does an entity in the REA framework consist of?

(Multiple Choice)

5.0/5

(31)

Question 27

In the REA framework, an event is a business activity.

(True/False)

4.8/5

(41)

Question 28

An entity-relationship diagram is prepared to document entities, relationships, and perhaps attributes.

(True/False)

4.7/5

(35)

Question 29

A transitive dependency exists when a nonkey data element depends on, or is determined by, another nonkey data element.

(True/False)

4.7/5

(38)

Question 30

Which of the following data elements are not included in a sales invoice?

(Multiple Choice)

4.9/5

(42)

Question 31

Consider the following elements needed to produce a sales order (see figure below): Date Customer zip code Cost per unit Sales order number Employee name Quantity ordered Customer name Employee region Total price Customer address Product number Total sales order Customer city Product description Determine the tables necessary to put this information in third normal form. SHOW ALL RESULTING TABLES FROM FIRST, SECOND, and THIRD normal forms. Be sure to identify primary keys, concatenated keys and foreign keys. Primary keys and concatenated keys should be underlined, and foreign keys should be indicated with an asterisk (*). SALES ORDER Sales order number: S10- 99876 Sales order date: October 30 , 20XX TO: ABC Corporation 2987 Bay Oaks Dr. Clear Lake City, TX 77057 John Smith, Houston region Thank you for your order! Unit Product No Description Price Quantity Total Card-playing P198765 dogs \ 15.00 25 \ 375.00 P349842 Velvet Elvis \ 14.00 20 \ 280.00 P368742 Looney Tunes \ 20.00 45 \ 900.00 P498111 Celine Dion \ 16.00 10 \ 160.00 Total sales order \1 ,715.00

(Essay)

4.9/5

(43)

Question 32

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 CustCode InvNo EmpCode InvDate Invoice Line Table Qty InvNo ProdNo Inventory Table ProdNo Desc Price Employee Table EmpName EmpCode CommRate Customer Table Name City CustCode -Which of the following data elements serves as both a primary and a foreign key in the five tables above?

(Multiple Choice)

5.0/5

(43)

Question 33

The end product of developing a database for an accounting system is a set of "normalized" tables that will store the data.

(True/False)

5.0/5

(25)

Question 34

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 are agents in the sale event?

(Multiple Choice)

4.9/5

(40)

Question 35

The participation of which of the following individuals is not necessary in the development of a database system?

(Multiple Choice)

4.8/5

(39)

Question 36

The REA approach focuses on identifying the business events, or activities, in the organization.

(True/False)

4.8/5

(35)

Question 37

A study of the business processes would uncover the relationships among events, resources, and agents.

(True/False)

4.8/5

(33)

Question 38

A table in a relational database can have multiple values for one cell.

(True/False)

4.8/5

(37)

Question 39

What does an ellipse represent in an entity-relationship diagram?

(Multiple Choice)

4.8/5

(34)

Question 40

Tables in a relational database are documented by a data flow diagram.

Briefly describe the approaches used in developing the relational database for an accounting system.

The implementation of a database begins by defining which of the following?

Which of the following statements regarding normal forms is incorrect?

What does an entity in the REA framework consist of?

In the REA framework, an event is a business activity.

An entity-relationship diagram is prepared to document entities, relationships, and perhaps attributes.

A transitive dependency exists when a nonkey data element depends on, or is determined by, another nonkey data element.

Which of the following data elements are not included in a sales invoice?

The end product of developing a database for an accounting system is a set of "normalized" tables that will store the data.

The participation of which of the following individuals is not necessary in the development of a database system?

The REA approach focuses on identifying the business events, or activities, in the organization.

A study of the business processes would uncover the relationships among events, resources, and agents.

A table in a relational database can have multiple values for one cell.

What does an ellipse represent in an entity-relationship diagram?

Significance of Accounting Information Systems and the Accountants Role

Accounting Systems Documentation

Essential Elements and Basic Activities of Accounting Systems

Data Flows, Activities, and Structure of Accounting Systems

Reporting Process, Coding Methods, and Audit Trails

Internal Control and Risk Assessment

Control Activities

The Financial Process

The Revenue Process

The Purchasing Process

The Inventory Process

Database Structure of Accounting Systems

Electronic Business

Ais Selection and Implementation

Filters