Explore all topics
Start Free Trial
Need Help? Contact us
back arrowfull exam logo
search
ai logoChat with AI
Servicesarrow
Discoverarrow

Topics

Explore all topics
Discover more topics

Exam 3: Relational Database Modeling

arrow
Exam 1: Introduction57 Questionsadd course
Exam 2: Database Requirements and ER Modeling100 Questionsadd course
Exam 3: Relational Database Modeling100 Questionsadd course
Exam 4: Update Operations, update Anomalies, and Normalization100 Questionsadd course
Exam 5: SQL100 Questionsadd course
Exam 6: Database Implementation and Use55 Questionsadd course
Exam 7: Data Warehousing Concepts48 Questionsadd course
Exam 8: Data Warehouse and Data Mart Modeling100 Questionsadd course
Exam 9: Data Warehouse Implementation and Use50 Questionsadd course
Exam 10: Overview of Dbms Functionalities and Database Administration42 Questionsadd course
Select questions type
  • Essay
  • Multiple Choice
  • Short Answer
  • True False
  • Matching
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
Select questions type
  • Essay
  • Multiple Choice
  • Short Answer
  • True False
  • Matching
  • Select Tags

ZYX COMPANY Observe the ER diagram for the ZYX COMPANY: 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. -Attribute CustBDate from the ZYX Company ER diagram will be mapped as a column of the relation CUSTOMER. This ER diagram will be used for the following questions citing ZYX Company ER Diagram. -Attribute CustBDate from the ZYX Company ER diagram will be mapped as a column of the relation CUSTOMER.

Free
(True/False)
4.8/5
(39)
Question 1
Correct Answer:
Verified

True

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

Free
(Multiple Choice)
4.8/5
(34)
Question 2
Correct Answer:
Verified

A

An entity and its M:N unary relationship are mapped as one relation.

Free
(True/False)
4.7/5
(31)
Question 3
Correct Answer:
Verified

False

GENERIC ERD Observe the GENERIC ER Diagram below: 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. 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
(40)
Question 4

A row of a relation can have in its column two values from the column's domain.

(True/False)
4.8/5
(38)
Question 5

Which of the following is NOT true? In a relational table:

(Multiple Choice)
4.9/5
(31)
Question 6

ZYX COMPANY Observe the ER diagram for the ZYX COMPANY: 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 a total of four foreign keys. 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 a total of four foreign keys.

(True/False)
4.8/5
(35)
Question 7

A restriction specifying that no salary entered in the salary column can be higher than $300,000 is an example of a business rule.

(True/False)
4.8/5
(38)
Question 8

ZYX COMPANY Observe the ER diagram for the ZYX COMPANY: 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 a total of two relations. 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 a total of two relations.

(True/False)
4.8/5
(33)
Question 9

An optional attribute of an entity is not mapped as a column of a relation.

(True/False)
4.7/5
(31)
Question 10

A bridge relation is a result of mapping an M:N relationship.

(True/False)
4.9/5
(33)
Question 11

EAGLERUN TRUCKING DISPATCHER Observe the ER diagram for the Eaglerun Trucking Dispatcher: 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 foreign keys in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram serve as a component of a primary key? This ER diagram will be used for the following questions citing Eaglerun Trucking Dispatcher ER Diagram. -How many foreign keys in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram serve as a component of a primary key?

(Multiple Choice)
4.8/5
(40)
Question 12

Relation is a synonym for

(Multiple Choice)
4.9/5
(33)
Question 13

ABC RETAILER Observe the ER diagram for the ABC Retailer: 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. -How many columns will the relation BRAND have in the relational schema mapped from the ABC Retailer ER diagram? This ER diagram will be used for the following questions citing ABC Retailer ER Diagram. -How many columns will the relation BRAND have in the relational schema mapped from the ABC Retailer ER diagram?

(Multiple Choice)
4.9/5
(32)
Question 14

ZYX COMPANY Observe the ER diagram for the ZYX COMPANY: 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 OfficePhoneNumber from the ZYX Company ER diagram will be mapped as a column of the relation EMPLOYEE. 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 OfficePhoneNumber from the ZYX Company ER diagram will be mapped as a column of the relation EMPLOYEE.

(True/False)
4.9/5
(33)
Question 15

What is a foreign key?

(Essay)
4.8/5
(42)
Question 16

How is a composite attribute of an entity mapped into a relation?

(Essay)
5.0/5
(23)
Question 17

EAGLERUN TRUCKING DISPATCHER Observe the ER diagram for the Eaglerun Trucking Dispatcher: 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 tables in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram will have composite primary keys? This ER diagram will be used for the following questions citing Eaglerun Trucking Dispatcher ER Diagram. -How many tables in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram will have composite primary keys?

(Multiple Choice)
4.9/5
(31)
Question 18

What is the difference between mapping a 1:M and a 1:1 relationship?

(Essay)
4.9/5
(33)
Question 19

Which of the following is NOT true? Mapping an M:N relationship that has no attributes will result in:

(Multiple Choice)
4.9/5
(28)
Question 20
Showing 1 - 20 of 100
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)