Use the database tables below to answer the following questions.
29) Which field in the SALES ORDERS table is a foreign key?
A) SO No
B) SO Date
C) Shipping
D) Customer ID
30) Which table’s primary key has a composite primary key?
A) CUSTOMERS
B) SALES ORDERS
C) ITEMS
D) SO LINE
31) Which of the relationships below is a many-to-many relationship?
A) CUSTOMERS, SALES ORDERS
B) SALES ORDERS, ITEMS
C) ITEMS, SO LINE
D) SO LINE, CUSTOMERS
32) The ________ table is an intersection table.
A) CUSTOMERS
B) SALES ORDERS
C) ITEMS
D) SO LINE
33) By using an intersection table, which field can be removed from the SALES ORDERS table?
A) SO No
B) SO Date
C) Item No
D) Shipping
Use the database tables below to answer the following questions.
34) Which field in the TimeSheet table is a foreign key?
A) Time Sheet ID
B) Total Hours
C) Week Ending
D) Employee ID
35) Which table’s primary key has a composite primary key?
A) Projects
B) TimeSheet
C) TS Line
D) Employees
36) Which of the relationships below is a many-to-many relationship?
A) Projects, TS Line
B) TimeSheets, Projects
C) Employee, Timesheets
D) TimeSheets, TS Line
37) Which table is an intersection table?
A) Projects
B) TS Line
C) Timesheets
D) Employees
38) By using an intersection table, which field can be removed from the TimeSheet table?
A) Total Hours
B) Week Ending
C) Project ID
D) EmployeeID
39) All the following statements about intersection tables are true EXCEPT
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
40) In which phase of the SDLC is the database documented using entity relationship diagrams?
A) Install phase
B) Analysis phase
C) Design phase
D) Build/Buy phase
41) In which database realm is associated with the deploy phase of the SDLC?
A) Database application realm
B) Database user realm
C) Database designer realm
D) Database builder realm
42) 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?
43) What is the purpose of a foreign key? Provide an example.
44) Describe the types of relationships possible between tables in a relational database. Indicate
whether each relationship is desirable in a relational database.
45) Why are calculated amounts NOT stored in a database?
46) How are database tables connected? Please provide an example.
47) Describe the possible types of database issues or anomalies.
Objective 4
1) Database anomalies are limited to databases using a network structure.
2) Intersection tables do not remove duplicate records from tables that have a many-to-many
relationships.
3) To maintain primary key integrity, a relational database designer will not allow a primary key
to have a null (empty) value.
4) Referential integrity ensures data is consistent throughout the database.
5) Database anomalies can be removed by the process of ________.
To answer the following questions, refer to the database below.
6) The following statements regarding the Vendor Orders table above are true EXCEPT
A) The database requires entering the same vendor contact information multiple times
B) The database does not break the referential integrity rule
C) The database requires a PO number and and item number to add a vendor record
D) Deleting a vendor will also delete inventory information
7) To add a vendor to the Vendor Orders table, the following information is required EXCEPT
A) PO Number
B) Vendor ID
C) Item Number
D) Vendor name
8) The Vendor Orders table contains the following database anomalies EXCEPT
A) Normalization problem
B) Update problem
C) Deletion problem
D) Insertion problem
9) Separating the database into related tables instead of using just one large table helps to
eliminate
A) Deletion, update, and normalization problems
B) Update, insertion, and creation problems
C) Insertion, update, and authorization problems
D) Deletion, update, and insertion problems
10) Normalization is an optimization process that minimizes which of the following?
A) Database integrity
B) Unauthorized access
C) Database access
D) Redundancy
11) When a database has been normalized, which of the following is true?
A) The database has an increased chance of inconsistencies.
B) The database requires the user to enter data twice.
C) The database tables do not have a many-to-many relationship.
D) The database has an increased chance of redundancies.
12) Which database integrity rule ensures each record may be retrieved from the database using a
unique identifier?
A) Entity integrity
B) Referential integrity
C) Domain integrity
D) Primary key integrity
13) When requiring a user to select from a list to enter data, such as the state in an address, the
database is conforming to which database integrity rule?
A) Entity integrity
B) Referential integrity
C) Domain integrity
D) Primary key integrity
14) You are an accountant at a small company and you are reviewing the vendor database table.
Identify the database anomalies shown and explain how they impact this database.
15) What suggestions would you give the database designer? How should the database be created
to eliminate the database anomalies? (Be specific.)
16) An audit of customer records in the accounting database reveals data in the state field was
entered inconsistently. Some customers’ states were entered using the two letter abbreviation
(MO, CA, or IA) and others were spelled out (Missouri, California, or Iowa). Which database
integrity rule is NOT being followed? What type of controls can be implemented to prevent this
in the future?
17) What are the three types of database anomalies? Define each type.
18) What is primary key integrity? What happens when a database does NOT have or enforce
primary key integrity?
19) What is referential integrity? What happens when a database does NOT have or enforce
referential integrity?
1) The bookkeeper at the retail store Cycle Bikes enters adjusting entries using an onscreen
journal. This indicates that Cycle Bikes has a manual accounting system.
2) In a database accounting system, the following is true EXCEPT
A) Transactions are entered using onscreen database forms
B) Adjustments are made using an onscreen journal
C) Closing entries are made manually with debits and credits
D) Account information is stored in database tables