Question 1

Referential integrity determines whether or not null values are allowed in a field.

Accepted Answer

A) True 
 B)False

Question 2

When implementing the relationships of an entity-relationship diagram into relational tables, the first things you should consider are the _________ cardinalities to minimize _________.

Accepted Answer

A)  minimum, redundancy 
B)  minimum, load 
C)  maximum, redundancy 
D)  maximum, load 
E)  maximum, null values 
A)  minimum, redundancy 
B)  minimum, load 
C)  maximum, redundancy 
D)  maximum, load 
E)  maximum, null values

Question 3

When creating a table in Microsoft Access, which of the following fields should ALWAYS be specified as a "Number" field (and should thus NEVER be specified as either a "Date", "Currency", or "Text" field)?

Accepted Answer

A)  Quantity sold 
B)  Customer number 
C)  Social security number 
D)  Invoice number 
E)  Total sales dollar amount 
A)  Quantity sold 
B)  Customer number 
C)  Social security number 
D)  Invoice number 
E)  Total sales dollar amount

Question 4

What is the purpose of a primary key attribute in a relational database table?

Accepted Answer

To uniquely and univ

Question 5

Which of the following pieces of data would most likely be stored (rather than derived via a query) in a relational database based on the REA model and implemented in Microsoft Access?

Accepted Answer

A)  The number of different inventory items purchased from a vendor during a month. 
B)  An individual customer's accounts receivable balance on a specific date. 
C)  The quantity on hand of a particular inventory item on a specific date. 
D)  Actual unit selling price of an inventory item on a specific sale. 
E)  The balance of the company's checking account on a specific date. 
A)  The number of different inventory items purchased from a vendor during a month. 
B)  An individual customer's accounts receivable balance on a specific date. 
C)  The quantity on hand of a particular inventory item on a specific date. 
D)  Actual unit selling price of an inventory item on a specific sale. 
E)  The balance of the company's checking account on a specific date.

Question 6

For which of these relationships does an efficient relational implementation of relationship AB require posting a foreign key? (in other words, for which relationship(s) would you always post a foreign key instead of making a separate table)

Accepted Answer

A)  JK only 
B)  JK and PQ only 
C)  PQ only 
D)  YZ only 
E)  JK, PQ, and YZ 
A)  JK only 
B)  JK and PQ only 
C)  PQ only 
D)  YZ only 
E)  JK, PQ, and YZ

Question 7

The view in which the field data types and field properties for a database table can be seen in Microsoft Access is called the datasheet view.

Accepted Answer

A) True 
 B)False

Question 8

The purpose of foreign keys is to

Accepted Answer

A)  Uniquely and universally identify instances of the entity into which they are posted. 
B)  Link relations so the database can be used to store business data and to generate useful information. 
C)  Create null values in the database. 
D)  Determine minimum cardinalities of relationships between entities. 
E)  Determine maximum cardinalities of relationships between entities. 
A)  Uniquely and universally identify instances of the entity into which they are posted. 
B)  Link relations so the database can be used to store business data and to generate useful information. 
C)  Create null values in the database. 
D)  Determine minimum cardinalities of relationships between entities. 
E)  Determine maximum cardinalities of relationships between entities.

Question 9

The REA conceptual model can be implemented only with relational database software.

Accepted Answer

A) True 
 B)False

Question 10

In the following pet table 
   the shots received column is a repeating group because the column contains multiple values.

Accepted Answer

A) True 
 B)False

Question 11

Imagine you are implementing the relationships of an entity-relationship diagram into relational table format. The rules for minimum cardinalities tell you to post the key of entity A into the table for entity B, and the rules for maximum cardinalities tell you to post the key of entity B into the table for entity A. What do you do?

Accepted Answer

A)  Consider load, and if posting A into B would result in a low load, post A into B 
B)  Consider load, and if posting B into A would result in a low load, post B into A 
C)  Consider load, and if posting B into A would result in a high load, post B into A 
D)  Consider load, and if posting A into B would result in a high load, post A into B 
E)  Consider load, and if posting A into B would result in a medium load, post A into B 
A)  Consider load, and if posting A into B would result in a low load, post A into B 
B)  Consider load, and if posting B into A would result in a low load, post B into A 
C)  Consider load, and if posting B into A would result in a high load, post B into A 
D)  Consider load, and if posting A into B would result in a high load, post A into B 
E)  Consider load, and if posting A into B would result in a medium load, post A into B

Question 12

Salespeople for the Coverall Insurance Company meet with customers and try to sell them one or more of the company's five insurance policies. If they are successful in their sales efforts they obtain a signed insurance policy from the customer and the initial check for the first premium. These are sent to the company's headquarters for processing. The contract is kept on file, and the check is given to the cashier for processing into one of the company's cash accounts. Policy payment reminders are mailed to the customer (monthly or quarterly, depending on the terms of the policy). The customer sends subsequent policy payments to the cashier for processing.
Below is a partial REA business process level conceptual model for Coverall. Convert this conceptual model into a logical model consisting of a set of minimal relational database tables. Underline primary keys and write FK next to foreign keys.

Accepted Answer

The answer of Salespeople for the Coverall Insurance Company meet...

Question 13

When converting a REA model into relational tables, each entity object becomes a relation.

Accepted Answer

A) True 
 B)False

Question 14

Which of the implementation choices depicted below represents the most appropriate Microsoft Access implementation of the Sale-Inventory relationship portrayed in this conceptual model?

Accepted Answer

A)  Implementation Choice 1 
B)  Implementation Choice 2 
C)  Implementation Choice 3 
D)  Implementation Choice 4 
E)  Implementation Choices 1 and 2 are equally correct Access implementations of the relationship. 
A)  Implementation Choice 1 
B)  Implementation Choice 2 
C)  Implementation Choice 3 
D)  Implementation Choice 4 
E)  Implementation Choices 1 and 2 are equally correct Access implementations of the relationship.

Question 15

The rule for converting conceptual model relationships with maximum participation cardinalities of "many to many" into relational database tables is

Accepted Answer

A)  Create a separate table identified by the key attribute of the entity that has the most instances. 
B)  Create a relation that can have no attributes of its own. 
C)  Post the key attribute of either entity into the relation of the other entity. 
D)  Post the key attribute of the table with mandatory participation into the table with optional participation. 
E)  Create a separate table identified by a concatenated primary key comprised of the key attributes from both entity tables. 
A)  Create a separate table identified by the key attribute of the entity that has the most instances. 
B)  Create a relation that can have no attributes of its own. 
C)  Post the key attribute of either entity into the relation of the other entity. 
D)  Post the key attribute of the table with mandatory participation into the table with optional participation. 
E)  Create a separate table identified by a concatenated primary key comprised of the key attributes from both entity tables.

Question 16

What potential problem exists in this table structure?

Accepted Answer

A)  The "fact rule" is violated if more than one account is at the same bank. 
B)  The "fact rule" is violated if more than one account has the same account balance. 
C)  The "fact rule" is violated if more than one bank has the same address. 
D)  All of the above are potential problems. 
E)  None of the above are potential problems. 
A)  The "fact rule" is violated if more than one account is at the same bank. 
B)  The "fact rule" is violated if more than one account has the same account balance. 
C)  The "fact rule" is violated if more than one bank has the same address. 
D)  All of the above are potential problems. 
E)  None of the above are potential problems.

Question 17

Given the following set of relational database tables, what must have been the conceptual model's participation cardinalities between the entities Sale and Inventory?

Accepted Answer

A)  (1,N) Sale -- (1,1) Inventory 
B)  (1,N) Sale -- (0,N) Inventory 
C)  (0,N) Sale -- (1,N) Inventory 
D)  (1,1) Sale -- (0,N) Inventory 
E)  (0,1) Sale -- (0,1) Inventory 
A)  (1,N) Sale -- (1,1) Inventory 
B)  (1,N) Sale -- (0,N) Inventory 
C)  (0,N) Sale -- (1,N) Inventory 
D)  (1,1) Sale -- (0,N) Inventory 
E)  (0,1) Sale -- (0,1) Inventory

Question 18

In Microsoft Access, how should one delete a relationship in the relationship layout?

Accepted Answer

Single click on the

Question 19

Say you have been brought in to check the work of a person who developed a database for Marty's Manufacturing. The conceptual model for Marty's Manufacturing includes the following relationship:
   The relational database tables, which are implemented in Microsoft Access, include a table for Production Order and a table for Production Run. The primary key of Production Order (PO) is posted into the Production Run table as a foreign key. You are required in your inspection to ensure that each minimum and maximum cardinality in the conceptual model is appropriately reflected in the table design. What should you look for in the table design to determine whether the 1 minimum on Production Run is appropriately reflected in the database tables?

Accepted Answer

The Production Run table shoul

Question 20

With respect to relational database design in Microsoft Access, explain the difference between enforcing referential integrity and creating a field property of required data entry. Use the following example to support your explanations. 
The conceptual model from which the relational tables were derived is as follows:
   The relational tables include a Cash Account table and a Bank table as follows:

Accepted Answer

Enforcement of referential integrity is

Referential integrity determines whether or not null values are allowed in a field.

When implementing the relationships of an entity-relationship diagram into relational tables, the first things you should consider are the _ cardinalities to minimize _.

When creating a table in Microsoft Access, which of the following fields should ALWAYS be specified as a "Number" field (and should thus NEVER be specified as either a "Date", "Currency", or "Text" field)?

What is the purpose of a primary key attribute in a relational database table?

Which of the following pieces of data would most likely be stored (rather than derived via a query) in a relational database based on the REA model and implemented in Microsoft Access?

For which of these relationships does an efficient relational implementation of relationship AB require posting a foreign key? (in other words, for which relationship(s) would you always post a foreign key instead of making a separate table)

The view in which the field data types and field properties for a database table can be seen in Microsoft Access is called the datasheet view.

The purpose of foreign keys is to

The REA conceptual model can be implemented only with relational database software.

In the following pet table the shots received column is a repeating group because the column contains multiple values.

When converting a REA model into relational tables, each entity object becomes a relation.

Which of the implementation choices depicted below represents the most appropriate Microsoft Access implementation of the Sale-Inventory relationship portrayed in this conceptual model?

The rule for converting conceptual model relationships with maximum participation cardinalities of "many to many" into relational database tables is

What potential problem exists in this table structure?

Given the following set of relational database tables, what must have been the conceptual model's participation cardinalities between the entities Sale and Inventory?

In Microsoft Access, how should one delete a relationship in the relationship layout?

An Introduction to Integrated Enterprise Information Systems

Representation and Patterns

The REA Enterprise Ontology

The REA Enterprise Ontology: Business Process Modeling

Task Level Modeling

Information Retrieval From Relational Databases

The Sales/Collection Business Process

The Acquisitio/Payment Business Process

View Integration and Implementation Compromises

The Conversion Business Process

The Human Resource Business Process

The Financing Business Process

Enterprise System Risks and Controls

ERP Systems and E-Commerce

Filters

Exam 6: Relational Database Design

Referential integrity determines whether or not null values are allowed in a field.

When implementing the relationships of an entity-relationship diagram into relational tables, the first things you should consider are the _________ cardinalities to minimize _________.

When creating a table in Microsoft Access, which of the following fields should ALWAYS be specified as a "Number" field (and should thus NEVER be specified as either a "Date", "Currency", or "Text" field)?

What is the purpose of a primary key attribute in a relational database table?

Which of the following pieces of data would most likely be stored (rather than derived via a query) in a relational database based on the REA model and implemented in Microsoft Access?

For which of these relationships does an efficient relational implementation of relationship AB require posting a foreign key? (in other words, for which relationship(s) would you always post a foreign key instead of making a separate table)

The view in which the field data types and field properties for a database table can be seen in Microsoft Access is called the datasheet view.

The purpose of foreign keys is to

The REA conceptual model can be implemented only with relational database software.

In the following pet table the shots received column is a repeating group because the column contains multiple values.

When converting a REA model into relational tables, each entity object becomes a relation.

Which of the implementation choices depicted below represents the most appropriate Microsoft Access implementation of the Sale-Inventory relationship portrayed in this conceptual model?

The rule for converting conceptual model relationships with maximum participation cardinalities of "many to many" into relational database tables is

What potential problem exists in this table structure?

Given the following set of relational database tables, what must have been the conceptual model's participation cardinalities between the entities Sale and Inventory?

In Microsoft Access, how should one delete a relationship in the relationship layout?

An Introduction to Integrated Enterprise Information Systems

Representation and Patterns

The REA Enterprise Ontology

The REA Enterprise Ontology: Business Process Modeling

Task Level Modeling

Information Retrieval From Relational Databases

The Sales/Collection Business Process

The Acquisitio/Payment Business Process

View Integration and Implementation Compromises

The Conversion Business Process

The Human Resource Business Process

The Financing Business Process

Enterprise System Risks and Controls

ERP Systems and E-Commerce

Filters

When implementing the relationships of an entity-relationship diagram into relational tables, the first things you should consider are the _ cardinalities to minimize _.