Question 1

Maximum cardinality can be:

Accepted Answer

A) One or many 
B) Zero or many 
C) Optional or mandatory 
D) Optional or many 
A) One or many 
B) Zero or many 
C) Optional or mandatory 
D) Optional or many

Question 2

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) A product can be associated with many promotions and it has to be associated with at least one promotion 
B) A product can be associated with many promotions but it does not have to be associated with any promotions 
C) Each product is associated with exactly one promotion 
D) A product is not associated with any promotions 
A) A product can be associated with many promotions and it has to be associated with at least one promotion 
B) A product can be associated with many promotions but it does not have to be associated with any promotions 
C) Each product is associated with exactly one promotion 
D) A product is not associated with any promotions

Question 3

How many entities are depicted by the following requirements?
School XYZ keeps track of its 100 students,10 teachers,and 5 classrooms.

Accepted Answer

A) 3 
B) 4 
C) 115 
D) 116 
A) 3 
B) 4 
C) 115 
D) 116

Question 4

Minimum cardinality can be:

Accepted Answer

A) One or many 
B) Zero or many 
C) Optional or mandatory 
D) Optional or many 
A) One or many 
B) Zero or many 
C) Optional or mandatory 
D) Optional or many

Question 5

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 products that belong to any brand 
B) We must keep track of products that do not belong to any brand 
C) We can keep track of products that do not belong to any brand 
D) We cannot keep track of products that do not belong to any brand 
A) We cannot keep track of products that belong to any brand 
B) We must keep track of products that do not belong to any brand 
C) We can keep track of products that do not belong to any brand 
D) We cannot keep track of products that do not belong to any brand

Question 6

A weak entity that has a 1:M identifying relationship with its owner must have a partial key.

Accepted Answer

A) True 
 B)False

Question 7

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,which word should replace qqq?

Accepted Answer

A) AirplaneTypeID 
B) NoOfEngines 
C) AirportID 
D) LengthOfRunway 
A) AirplaneTypeID 
B) NoOfEngines 
C) AirportID 
D) LengthOfRunway

Question 8

How many entities are involved in a unary relationship?

Accepted Answer

A) 1 
B) 2 
C) More than 2 
D) Between 1 and 2 
A) 1 
B) 2 
C) More than 2 
D) Between 1 and 2

Question 9

What is the purpose of ER modeling?

Accepted Answer

Entity-relationship (ER)modeling,a widel

Question 10

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,each driver has a unique DriverLicenseNo value.

Accepted Answer

A) True 
 B)False

Question 11

What type of ternary relationship CANNOT be depicted as two binary relationships?

Accepted Answer

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

Question 12

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,every region must be served by multiple trucks

Accepted Answer

A) True 
 B)False

Question 13

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,each truck is owned by a driver.

Accepted Answer

A) True 
 B)False

Question 14

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,each region has a unique RegionName value.

Accepted Answer

A) True 
 B)False

Question 15

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 products that are not associated with multiple promotions 
B) We must keep track of products that are not associated with any promotions 
C) We can keep track of products that are not associated with any promotions 
D) We cannot keep track of products that are not associated with any promotions 
A) We cannot keep track of products that are not associated with multiple promotions 
B) We must keep track of products that are not associated with any promotions 
C) We can keep track of products that are not associated with any promotions 
D) We cannot keep track of products that are not associated with any promotions

Question 16

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,which word should replace BBB?

Accepted Answer

A) AirplaneTypeID 
B) AIRPLANETYPE 
C) AirportID 
D) AIRPORT 
A) AirplaneTypeID 
B) AIRPLANETYPE 
C) AirportID 
D) AIRPORT

Question 17

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 be owned by multiple drivers.

Accepted Answer

A) True 
 B)False

Question 18

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 brands that do not have multiple products 
B) We must keep track of brands that do not have any products 
C) We can keep track of brands that do not have any products 
D) We cannot keep track of brands that do not have any products 
A) We cannot keep track of brands that do not have multiple products 
B) We must keep track of brands that do not have any products 
C) We can keep track of brands that do not have any products 
D) We cannot keep track of brands that do not have any products

Question 19

A weak entity that has a 1:1 identifying relationship with its owner,must have a partial key.

Accepted Answer

A) True 
 B)False

Question 20

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,which word should replace ppp?

Accepted Answer

A) AirplaneTypeID 
B) NoOfEngines 
C) AirportID 
D) LengthOfRunway 
A) AirplaneTypeID 
B) NoOfEngines 
C) AirportID 
D) LengthOfRunway

Maximum cardinality can be:

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?

How many entities are depicted by the following requirements? School XYZ keeps track of its 100 students,10 teachers,and 5 classrooms.

Minimum cardinality can be:

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?

A weak entity that has a 1:M identifying relationship with its owner must have a partial key.

How many entities are involved in a unary relationship?

What is the purpose of ER modeling?

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,each driver has a unique DriverLicenseNo value.

What type of ternary relationship CANNOT be depicted as two binary relationships?

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,every region must be served by multiple trucks

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,each truck is owned by a driver.

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,each region has a unique RegionName value.

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?

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 be owned by multiple drivers.

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?

A weak entity that has a 1:1 identifying relationship with its owner,must have a partial key.

Introduction

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Database Implementation and Use

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Overview of Dbms Functionalities and Database Administration

Filters

Exam 2: Database Requirements and ER Modeling

Maximum cardinality can be:

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?

How many entities are depicted by the following requirements? School XYZ keeps track of its 100 students,10 teachers,and 5 classrooms.

Minimum cardinality can be:

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?

A weak entity that has a 1:M identifying relationship with its owner must have a partial key.

How many entities are involved in a unary relationship?

What is the purpose of ER modeling?

What type of ternary relationship CANNOT be depicted as two binary relationships?

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,every region must be served by multiple trucks

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,each truck is owned by a driver.

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,each region has a unique RegionName value.

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?

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 be owned by multiple drivers.

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?

A weak entity that has a 1:1 identifying relationship with its owner,must have a partial key.

Introduction

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Database Implementation and Use

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Overview of Dbms Functionalities and Database Administration

Filters