Question 1

What is a degree of a relationship?

Accepted Answer

Degree of a relationship is the number that reflects how many entities are involved in the relationship.

Question 2

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

Accepted Answer

A) Each copy of the same book must have a different CopyID value 
B) Two copies can have the same CopyID value 
C) Each author has a different AuthorName value 
D) Each library book has a name 
A) Each copy of the same book must have a different CopyID value 
B) Two copies can have the same CopyID value 
C) Each author has a different AuthorName value 
D) Each library book has a name C

Question 3

An associative entity is used as an alternative way of depicting:

Accepted Answer

A) 1:M relationships 
B) 1:1 relationships 
C) M:N relationships 
D) Multivalued attributes 
A) 1:M relationships 
B) 1:1 relationships 
C) M:N relationships 
D) Multivalued attributes C

Question 4

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 belong to multiple brands but it must belong to at least one brand 
B) Each product belongs to multiple brands 
C) Each product belongs to exactly one brand 
D) Each product belongs to either one brand or no brand at all 
A) A product can belong to multiple brands but it must belong to at least one brand 
B) Each product belongs to multiple brands 
C) Each product belongs to exactly one brand 
D) Each product belongs to either one brand or no brand at all

Question 5

An attribute can be a part of several composite attributes.

Accepted Answer

A) True 
 B)False

Question 6

A relationship attribute of a M:N relationship cannot be assigned to either of the entities involved in that relationship.

Accepted Answer

A) True 
 B)False

Question 7

In an ER diagram,each entity is always connected to all of the other entities,either via a direct relationship or indirectly via other entities and relationships.

Accepted Answer

A) True 
 B)False

Question 8

An M:N relationship that can have multiple occurrences between the same instances of involved entities can be depicted as a:

Accepted Answer

A) Weak entity with one owner 
B) Multivalued composite attribute 
C) Unary M:N relationship 
D) Weak entity with two owners 
A) Weak entity with one owner 
B) Multivalued composite attribute 
C) Unary M:N relationship 
D) Weak entity with two owners

Question 9

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 DriverName value.

Accepted Answer

A) True 
 B)False

Question 10

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) An employee can sign up many customers and he or she has to sign up at least one customer 
B) An employee can sign up many customers but he or she does not have to sign up any customers 
C) Each employee signs up exactly one customer 
D) Each employee signs up many customers 
A) An employee can sign up many customers and he or she has to sign up at least one customer 
B) An employee can sign up many customers but he or she does not have to sign up any customers 
C) Each employee signs up exactly one customer 
D) Each employee signs up many customers

Question 11

The following attribute represents a collection of attributes:

Accepted Answer

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

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

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 driver has a unique DriverID value.

Accepted Answer

A) True 
 B)False

Question 14

The values of the following attribute are NOT permanently stored in a database.

Accepted Answer

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

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 true according to the ZYX Company ER diagram?

Accepted Answer

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

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 AAA?

Accepted Answer

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

Question 17

Relationship attributes may be necessary in a relationship of what type?

Accepted Answer

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

Question 18

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 two words should replace yyy and zzz?

Accepted Answer

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

Question 19

A relationship attribute of a 1:N relationship cannot be assigned to either of the entities involved in that relationship.

Accepted Answer

A) True 
 B)False

Question 20

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

What is a degree of a relationship?

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

An associative entity is used as an alternative way of depicting:

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?

An attribute can be a part of several composite attributes.

A relationship attribute of a M:N relationship cannot be assigned to either of the entities involved in that relationship.

In an ER diagram,each entity is always connected to all of the other entities,either via a direct relationship or indirectly via other entities and relationships.

An M:N relationship that can have multiple occurrences between the same instances of involved entities can be depicted as a:

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 DriverName value.

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?

The following attribute represents a collection of attributes:

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 RegionID value.

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 DriverID value.

The values of the following attribute are NOT permanently stored in a database.

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?

Relationship attributes may be necessary in a relationship of what type?

A relationship attribute of a 1:N relationship cannot be assigned to either of the entities involved in that relationship.

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?

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

What is a degree of a relationship?

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

An associative entity is used as an alternative way of depicting:

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?

An attribute can be a part of several composite attributes.

A relationship attribute of a M:N relationship cannot be assigned to either of the entities involved in that relationship.

In an ER diagram,each entity is always connected to all of the other entities,either via a direct relationship or indirectly via other entities and relationships.

An M:N relationship that can have multiple occurrences between the same instances of involved entities can be depicted as a:

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 DriverName value.

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?

The following attribute represents a collection of attributes:

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 RegionID value.

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 DriverID value.

The values of the following attribute are NOT permanently stored in a database.

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?

Relationship attributes may be necessary in a relationship of what type?

A relationship attribute of a 1:N relationship cannot be assigned to either of the entities involved in that relationship.

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?

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