Question 1

CENTRAL SCHOOL LIBRARY
Observe the ER diagram for the CENTRAL SCHOOL LIBRARY
 
-How many optional columns will the relational schema mapped from the Central School Library ER diagram have?

Accepted Answer

A) 0 
B) 1 
C) 2 
D) 3

Question 2

Give a definition of referential integrity constraint.

Accepted Answer

The answer of Give a definition of referential integrity constraint....

Question 3

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.

-What is the minimal number of records that can be entered in the database whose relational schema is mapped from the Eaglerun Trucking Dispatcher ER diagram?

Accepted Answer

A) 1 
B) 4 
C) 5 
D) 12

Question 4

If a 1:M relationship is mandatory on both sides,which of the following is true?

Accepted Answer

A) The resulting foreign key can have null (empty)values 
B) The resulting foreign key cannot have null (empty)values 
C) The resulting foreign key must have null (empty)values 
D) No foreign key is created as a result of mapping such a relationship

Question 5

What is a relational database a collection of?

Accepted Answer

The answer of What is a relational database a collection...

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.
-During mapping of the ZYX Company ERD into a relational schema,attribute CellPhoneNumber from the ZYX Company ER diagram will be mapped as a column of the relation EMPLOYEE.

Accepted Answer

A) True 
 B)False

Question 7

GENERIC ERD
Observe the GENERIC ER Diagram below:
 
This ER diagram will be used for the following questions citing Generic ER Diagram.
-If in the GENERIC ERD the Symbol 1 is >| and the Symbol2 is 0<,then the number of columns in the relational schema resulting from mapping the GENERIC ERD is 5.

Accepted Answer

A) True 
 B)False

Question 8

If an M:N relationship is mandatory on one side and optional on the other side,and if both relations resulting from the entities involved in the relationship each have 3 records,then the resulting bridge relation cannot have less than ________ records.

Accepted Answer

A) 0 
B) 1 
C) 3 
D) 9

Question 9

If a 1:M relationship is mandatory on the 1 side and optional on the M side,which of the following is true?

Accepted Answer

A) The resulting foreign key can have null (empty)values 
B) The resulting foreign key cannot have null (empty)values 
C) The resulting foreign key must have null (empty)values 
D) No foreign key is created as a result of mapping such a relationship

Question 10

If a 1:M relationship is optional on the 1 side and mandatory on the M side,which of the following is true?

Accepted Answer

A) The resulting foreign key can have null (empty)values 
B) The resulting foreign key cannot have null (empty)values 
C) The resulting foreign key must have null (empty)values 
D) No foreign key is created as a result of mapping such a relationship

Question 11

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.

-How many columns will the relation REGION have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?

Accepted Answer

A) 2 
B) 3 
C) 4 
D) 5

Question 12

Each weak entity has one owner entity.

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.
-During mapping of the ZYX Company ERD into a relational schema,attribute CustID from the ZYX Company ER diagram will be mapped as a column of the relation CUSTOMER.

Accepted Answer

A) True 
 B)False

Question 14

A relational schema is a visual depiction of the relational database model.

Accepted Answer

A) True 
 B)False

Question 15

The relation resulting from mapping a weak entity (with a 1:M identifying relationship)has a composite primary key that is composed of the partial identifier and a foreign key corresponding to the primary key of the owner entity.

Accepted Answer

A) True 
 B)False

Question 16

If a 1:M relationship is mandatory on the M side and optional on the 1 side,and if the table resulting from the 1 side has 3 records,then the table resulting from the M side cannot have less than ________ records.

Accepted Answer

A) 0 
B) 1 
C) 2 
D) 3

Question 17

Give a definition of entity integrity constraint.

Accepted Answer

The answer of Give a definition of entity integrity constraint....

Question 18

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.
-As a result of mapping the ZYX Company ERD,the resulting relational schema will have zero bridge tables.

Accepted Answer

A) True 
 B)False

Question 19

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.
-As a result of mapping the ZYX Company ERD into a relational schema,primary key of the relation CUSTOMER will be referred to by a foreign key in the relation CUSTOMER.

Accepted Answer

A) True 
 B)False

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.

-How many columns will the relation DRIVER have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?

Accepted Answer

A) 0 or 1 
B) 1 or 2 
C) 2 or 3 
D) 3 or 4

Exam 3: Relational Database Modeling

CENTRAL SCHOOL LIBRARY Observe the ER diagram for the CENTRAL SCHOOL LIBRARY -How many optional columns will the relational schema mapped from the Central School Library ER diagram have?

Give a definition of referential integrity constraint.

If a 1:M relationship is mandatory on both sides,which of the following is true?

What is a relational database a collection of?

GENERIC ERD Observe the GENERIC ER Diagram below: This ER diagram will be used for the following questions citing Generic ER Diagram. -If in the GENERIC ERD the Symbol 1 is >| and the Symbol2 is 0<,then the number of columns in the relational schema resulting from mapping the GENERIC ERD is 5.

If an M:N relationship is mandatory on one side and optional on the other side,and if both relations resulting from the entities involved in the relationship each have 3 records,then the resulting bridge relation cannot have less than ________ records.

If a 1:M relationship is mandatory on the 1 side and optional on the M side,which of the following is true?

If a 1:M relationship is optional on the 1 side and mandatory on the M side,which of the following is true?

Each weak entity has one owner entity.

A relational schema is a visual depiction of the relational database model.

The relation resulting from mapping a weak entity (with a 1:M identifying relationship)has a composite primary key that is composed of the partial identifier and a foreign key corresponding to the primary key of the owner entity.

If a 1:M relationship is mandatory on the M side and optional on the 1 side,and if the table resulting from the 1 side has 3 records,then the table resulting from the M side cannot have less than ________ records.

Give a definition of entity integrity constraint.

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. -As a result of mapping the ZYX Company ERD,the resulting relational schema will have zero bridge tables.