Question 1

Use the database tables below to answer the following questions.  
-Which field in the SALES ORDERS table is a foreign key?

Accepted Answer

A) SO No 
B) SO Date 
C) Shipping 
D) Customer ID 
A) SO No 
B) SO Date 
C) Shipping 
D) Customer ID

Question 2

All the following statements about intersection tables are true EXCEPT

Accepted Answer

A) Only one field in an intersect table is needed to uniquely identify a record 
B) The primary key for the intersection table includes the foreign keys of the tables 
C) Intersection tables remove many-to-many relationships 
D) An intersection table's primary key is a composite key 
A) Only one field in an intersect table is needed to uniquely identify a record 
B) The primary key for the intersection table includes the foreign keys of the tables 
C) Intersection tables remove many-to-many relationships 
D) An intersection table's primary key is a composite key

Question 3

When designing accounting database tables, how can we ensure the database will support the data needed by the enterprise? How can this information be collected?

Accepted Answer

By using business transactions to identi

Question 4

Describe the possible types of database issues or anomalies.

Accepted Answer

Deletion problem: This occurs when delet

Question 5

What is the purpose of a foreign key? Provide an example.

Accepted Answer

A foreign key is a primary key in one ta

Question 6

Use the database tables below to answer the following questions.  
-Which table's primary key has a composite primary key?

Accepted Answer

A) Projects 
B) TimeSheet 
C) TS Line 
D) Employees 
A) Projects 
B) TimeSheet 
C) TS Line 
D) Employees

Question 7

Describe the types of relationships possible between tables in a relational database. Indicate whether each relationship is desirable in a relational database.

Accepted Answer

One-to-one: In this relationship, for ea

Question 8

Why are calculated amounts NOT stored in a database?

Accepted Answer

Calculated amounts would be redundant da

Question 9

Database anomalies are limited to databases using a network structure.

Accepted Answer

A) True 
 B)False

Question 10

Use the database tables below to answer the following questions.  
-Which table's primary key has a composite primary key?

Accepted Answer

A) CUSTOMERS 
B) SALES ORDERS 
C) ITEMS 
D) SO LINE 
A) CUSTOMERS 
B) SALES ORDERS 
C) ITEMS 
D) SO LINE

Question 11

In which database realm is associated with the deploy phase of the SDLC?

Accepted Answer

A) Database application realm 
B) Database user realm 
C) Database designer realm 
D) Database builder realm 
A) Database application realm 
B) Database user realm 
C) Database designer realm 
D) Database builder realm

Question 12

In which phase of the SDLC is the database documented using entity relationship diagrams?

Accepted Answer

A) Install phase 
B) Analysis phase 
C) Design phase 
D) Build/Buy phase 
A) Install phase 
B) Analysis phase 
C) Design phase 
D) Build/Buy phase

Question 13

Use the database tables below to answer the following questions.  
-Which of the relationships below is a many-to-many relationship?

Accepted Answer

A) Projects, TS Line 
B) TimeSheets, Projects 
C) Employee, Timesheets 
D) TimeSheets, TS Line 
A) Projects, TS Line 
B) TimeSheets, Projects 
C) Employee, Timesheets 
D) TimeSheets, TS Line

Question 14

Use the database tables below to answer the following questions.  
-By using an intersection table, which field can be removed from the SALES ORDERS table?

Accepted Answer

A) SO No 
B) SO Date 
C) Item No 
D) Shipping 
A) SO No 
B) SO Date 
C) Item No 
D) Shipping

Question 15

Use the database tables below to answer the following questions.  
-Which table is an intersection table?

Accepted Answer

A) Projects 
B) TS Line 
C) Timesheets 
D) Employees 
A) Projects 
B) TS Line 
C) Timesheets 
D) Employees

Question 16

Use the database tables below to answer the following questions.  
-The ________ table is an intersection table.

Accepted Answer

A) CUSTOMERS 
B) SALES ORDERS 
C) ITEMS 
D) SO LINE 
A) CUSTOMERS 
B) SALES ORDERS 
C) ITEMS 
D) SO LINE

Question 17

How are database tables connected? Please provide an example.

Accepted Answer

First, identify a relationship between t

Question 18

Use the database tables below to answer the following questions.  
-Which of the relationships below is a many-to-many relationship?

Accepted Answer

A) CUSTOMERS, SALES ORDERS 
B) SALES ORDERS, ITEMS 
C) ITEMS, SO LINE 
D) SO LINE, CUSTOMERS 
A) CUSTOMERS, SALES ORDERS 
B) SALES ORDERS, ITEMS 
C) ITEMS, SO LINE 
D) SO LINE, CUSTOMERS

Question 19

Use the database tables below to answer the following questions.  
-Which field in the TimeSheet table is a foreign key?

Accepted Answer

A) Time Sheet ID 
B) Total Hours 
C) Week Ending 
D) Employee ID 
A) Time Sheet ID 
B) Total Hours 
C) Week Ending 
D) Employee ID

Question 20

Use the database tables below to answer the following questions.  
-By using an intersection table, which field can be removed from the TimeSheet table?

Accepted Answer

A) Total Hours 
B) Week Ending 
C) Project ID 
D) EmployeeID 
A) Total Hours 
B) Week Ending 
C) Project ID 
D) EmployeeID

Use the database tables below to answer the following questions. -Which field in the SALES ORDERS table is a foreign key?

All the following statements about intersection tables are true EXCEPT

When designing accounting database tables, how can we ensure the database will support the data needed by the enterprise? How can this information be collected?

Describe the possible types of database issues or anomalies.

What is the purpose of a foreign key? Provide an example.

Use the database tables below to answer the following questions. -Which table's primary key has a composite primary key?

Describe the types of relationships possible between tables in a relational database. Indicate whether each relationship is desirable in a relational database.

Why are calculated amounts NOT stored in a database?

Database anomalies are limited to databases using a network structure.

Use the database tables below to answer the following questions. -Which table's primary key has a composite primary key?

In which database realm is associated with the deploy phase of the SDLC?

In which phase of the SDLC is the database documented using entity relationship diagrams?

Use the database tables below to answer the following questions. -Which of the relationships below is a many-to-many relationship?

Use the database tables below to answer the following questions. -By using an intersection table, which field can be removed from the SALES ORDERS table?

Use the database tables below to answer the following questions. -Which table is an intersection table?

Use the database tables below to answer the following questions. -The ________ table is an intersection table.

How are database tables connected? Please provide an example.

Use the database tables below to answer the following questions. -Which of the relationships below is a many-to-many relationship?

Use the database tables below to answer the following questions. -Which field in the TimeSheet table is a foreign key?

Use the database tables below to answer the following questions. -By using an intersection table, which field can be removed from the TimeSheet table?

Accounting Systems Insights

Accounting Interface: Database Forms, Queries, and Reports

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Database Design: ERD, REA, and SQL

Filters

Exam 2: Accounting Databases

Use the database tables below to answer the following questions. -Which field in the SALES ORDERS table is a foreign key?

All the following statements about intersection tables are true EXCEPT

When designing accounting database tables, how can we ensure the database will support the data needed by the enterprise? How can this information be collected?

Describe the possible types of database issues or anomalies.

What is the purpose of a foreign key? Provide an example.

Use the database tables below to answer the following questions. -Which table's primary key has a composite primary key?

Describe the types of relationships possible between tables in a relational database. Indicate whether each relationship is desirable in a relational database.

Why are calculated amounts NOT stored in a database?

Database anomalies are limited to databases using a network structure.

Use the database tables below to answer the following questions. -Which table's primary key has a composite primary key?

In which database realm is associated with the deploy phase of the SDLC?

In which phase of the SDLC is the database documented using entity relationship diagrams?

Use the database tables below to answer the following questions. -Which of the relationships below is a many-to-many relationship?

Use the database tables below to answer the following questions. -By using an intersection table, which field can be removed from the SALES ORDERS table?

Use the database tables below to answer the following questions. -Which table is an intersection table?

Use the database tables below to answer the following questions. -The ________ table is an intersection table.

How are database tables connected? Please provide an example.

Use the database tables below to answer the following questions. -Which of the relationships below is a many-to-many relationship?

Use the database tables below to answer the following questions. -Which field in the TimeSheet table is a foreign key?

Use the database tables below to answer the following questions. -By using an intersection table, which field can be removed from the TimeSheet table?

Accounting Systems Insights

Accounting Interface: Database Forms, Queries, and Reports

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Database Design: ERD, REA, and SQL

Filters