Question 1

A unary relationship can have one or many maximum cardinalities on either side.

Accepted Answer

A) True 
 B)False

Question 2

An optional attribute occurs only in an entity that is involved in a relationship with optional participation.

Accepted Answer

A) True 
 B)False

Question 3

Entity instances are depicted in ER diagrams.

Accepted Answer

A) True 
 B)False

Question 4

Within an ER diagram,each entity must be related to at least one other entity via a relationship.

Accepted Answer

A) True 
 B)False

Question 5

Relationship instances occur when an instance of one entity is related to an instance of another entity via a relationship.

Accepted Answer

A) True 
 B)False

Question 6

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:
 
This ER diagram will be used for the following questions citing ZYX Company ER Diagram.
-Observe the ER diagram for the ZYX Company:
Which of the following is true according to the ZYX Company ER diagram?

Accepted Answer

A) An employee can serve many customers and he or she has to serve at least one customer 
B) An employee can serve one customer or he or she does not have to serve any customers 
C) Each employee serves exactly one customer 
D) Employees do not serve customers

Question 7

CENTRAL SCHOOL LIBRARY
Observe the ER diagram for the CENTRAL SCHOOL LIBRARY
 
-Which of the following is true according to the Central School Library ER diagram?

Accepted Answer

A) We cannot keep track of authors that did not write any of the library books 
B) We cannot keep track of authors that wrote only one of the library books 
C) We cannot keep track of authors that wrote multiple library books 
D) We cannot keep track of authors that wrote more than 10 library books

Question 8

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:
 
This ER diagram will be used for the following questions citing ZYX Company ER Diagram.
-Which of the following is true according to the ZYX Company ER diagram?

Accepted Answer

A) We will store CustomerBDate value for each customer 
B) We will store OfficePhoneNumber value for each employee 
C) We will store CustomerAge value for each customer 
D) All of the above

Question 9

Minimum cardinality can be many.

Accepted Answer

A) True 
 B)False

Question 10

Components of a unique composite attribute are not unique.

Accepted Answer

A) True 
 B)False

Question 11

SUNSHINE AIRLINE COMPANY
The ER Diagram for the SUNSHINE AIRLINE COMPANY is based on the following:
- For each airplane type,we keep track of a unique airplane type ID (AirplaneTypeID),number of engines (NoOfEngines),and number of seats (NoOfSeats).
- For each airport,we keep track of a unique airport ID (AirportID),and the length of the main runway (LengthOfRunway).
- Each airplane type is able to land at one airport at least,but may be able to land at many airports.Each airport accommodates landing of at least one airplane type,but may accommodate landing of more airplane types.
 
This ER diagram will be used for the following questions citing SUNSHINE AIRLINE ER Diagram.
-In the ER Diagram for the SUNSHINE AIRLINE COMPANY,Symbol1 should be:

Accepted Answer

A) || 
B) >| 
C) >○ 
D) |○

Question 12

ER modeling is a widely used logical database modeling method.

Accepted Answer

A) True 
 B)False

Question 13

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:
 
This ER diagram will be used for the following questions citing ZYX Company ER Diagram.
-Which of the following is true according to the ZYX Company ER diagram?

Accepted Answer

A) A customer can be served by many employees and he or she has to be served by at least one employee 
B) A customer can be served by one employee or he or she does not have to be served by any employees 
C) Each customer is served by exactly one employee 
D) Customers are not served by employees

Question 14

What is a relationship role?

Accepted Answer

The answer of What is a relationship role?...

Question 15

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:
 
This ER diagram will be used for the following questions citing ZYX Company ER Diagram.
-Which of the following is NOT true according to the ZYX Company ER diagram?

Accepted Answer

A) We can keep track of employees that have multiple cell phone numbers 
B) We can keep track of employees that have multiple office phone numbers 
C) We can keep track of employees that have one cell phone number 
D) We can keep track of employees that have one office phone number

Question 16

Create an example ER diagram that illustrates two entities with two separate relationships between them

Accepted Answer

The answer of Create an example ER diagram that illustrates...

Question 17

ABC RETAILER
Observe the ER diagram for the ABC Retailer:
 
This ER diagram will be used for the following questions citing ABC Retailer ER Diagram. 
-Which of the following is true according to the ABC Retailer ER diagram?

Accepted Answer

A) We cannot keep track of promotions that are not associated with multiple products 
B) We must keep track of promotions that are not associated with any products 
C) We can keep track of promotions that are not associated with any products 
D) We cannot keep track of promotions that are not associated with any products

Question 18

The following attribute can contain more than one value for each entity instance.

Accepted Answer

A) Unique attribute 
B) Composite attribute 
C) Multivalued attribute 
D) Derived attribute

Question 19

Which of the following is NOT a possible cardinality constraint?

Accepted Answer

A) Optional one 
B) Optional zero 
C) Optional many 
D) Mandatory one

Question 20

EAGLERUN TRUCKING DISPATCHER
Observe the ER diagram for the Eaglerun Trucking 
Dispatcher:
 
This ER diagram will be used for the following questions citing Eaglerun Trucking Dispatcher ER Diagram.

-According to the Eaglerun Trucking Dispatcher ER diagram,a truck can serve multiple regions.

Accepted Answer

A) True 
 B)False

Exam 2: Database Requirements and ER Modeling

A unary relationship can have one or many maximum cardinalities on either side.

An optional attribute occurs only in an entity that is involved in a relationship with optional participation.

Entity instances are depicted in ER diagrams.

Within an ER diagram,each entity must be related to at least one other entity via a relationship.

Relationship instances occur when an instance of one entity is related to an instance of another entity via a relationship.

ZYX COMPANY Observe the ER diagram for the ZYX COMPANY: This ER diagram will be used for the following questions citing ZYX Company ER Diagram. -Observe the ER diagram for the ZYX Company: Which of the following is true according to the ZYX Company ER diagram?

CENTRAL SCHOOL LIBRARY Observe the ER diagram for the CENTRAL SCHOOL LIBRARY -Which of the following is true according to the Central School Library ER diagram?

ZYX COMPANY Observe the ER diagram for the ZYX COMPANY: This ER diagram will be used for the following questions citing ZYX Company ER Diagram. -Which of the following is true according to the ZYX Company ER diagram?

Minimum cardinality can be many.

Components of a unique composite attribute are not unique.

ER modeling is a widely used logical database modeling method.

ZYX COMPANY Observe the ER diagram for the ZYX COMPANY: This ER diagram will be used for the following questions citing ZYX Company ER Diagram. -Which of the following is true according to the ZYX Company ER diagram?

What is a relationship role?

ZYX COMPANY Observe the ER diagram for the ZYX COMPANY: This ER diagram will be used for the following questions citing ZYX Company ER Diagram. -Which of the following is NOT true according to the ZYX Company ER diagram?

Create an example ER diagram that illustrates two entities with two separate relationships between them

ABC RETAILER Observe the ER diagram for the ABC Retailer: This ER diagram will be used for the following questions citing ABC Retailer ER Diagram. -Which of the following is true according to the ABC Retailer ER diagram?

The following attribute can contain more than one value for each entity instance.

Which of the following is NOT a possible cardinality constraint?

EAGLERUN TRUCKING DISPATCHER Observe the ER diagram for the Eaglerun Trucking Dispatcher: This ER diagram will be used for the following questions citing Eaglerun Trucking Dispatcher ER Diagram. -According to the Eaglerun Trucking Dispatcher ER diagram,a truck can serve multiple regions.