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?

(Multiple Choice)

4.7/5

(43)

Question 21

Give a definition of referential integrity constraint.

(Essay)

4.9/5

(36)

Question 22

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?

(Multiple Choice)

4.8/5

(29)

Question 23

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

(Multiple Choice)

4.9/5

(31)

Question 24

What is a relational database a collection of?

(Essay)

4.8/5

(43)

Question 25

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.

(True/False)

4.9/5

(34)

Question 26

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.

(True/False)

4.8/5

(35)

Question 27

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.

(Multiple Choice)

4.9/5

(31)

Question 28

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

(Multiple Choice)

4.8/5

(34)

Question 29

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

(Multiple Choice)

4.7/5

(24)

Question 30

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?

(Multiple Choice)

4.9/5

(35)

Question 31

Each weak entity has one owner entity.

(True/False)

4.9/5

(37)

Question 32

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.

(True/False)

4.9/5

(27)

Question 33

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

(True/False)

4.7/5

(42)

Question 34

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.

(True/False)

4.7/5

(47)

Question 35

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.

(Multiple Choice)

4.8/5

(30)

Question 36

Give a definition of entity integrity constraint.

(Essay)

4.9/5

(39)

Question 37

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.

(True/False)

4.8/5

(42)

Question 38

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.

(True/False)

4.9/5

(29)

Question 39

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?

(Multiple Choice)

4.8/5

(38)

Question 40

Showing 21 - 40 of 100

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.

Introduction

Database Requirements and ER 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