Question 1

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)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

Accepted Answer

According to the ER diagram, a promotion can be associated with many products (shown by the many-to-many relationship between Promotion and Product entities), and it has to be associated with at least one product (shown by the minimum cardinality constraint of 1 on the Product entity in the Promotion-Product relationship). Therefore, choice A is the correct answer.

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

Accepted Answer

According to the ER diagram, a brand can be associated with many products and the minimum cardinality of the relationship between Brand and Product is 1, which means that each brand must have at least one product. Therefore, option B is the correct choice. Option A is incorrect as it states that a brand can have many products but it does not have to have any products, which contradicts the minimum cardinality constraint. Option C is incorrect as it says that each brand is associated with exactly one product, which is not true based on the ER diagram. Option D is also incorrect as it contradicts the fact that a brand can be associated with one or many products.

Question 3

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)Each promotion has a unique promotion name
B)Each brand has a unique brand name
C)Each product has a unique product ID
D)All of the above

Accepted Answer

In an ER diagram, a product typically has a unique identifier, such as a product ID, to distinguish it from other products.

Question 4

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?
A)AirplaneTypeID
B)NoOfEngines
C)AirportID
D)LengthOfRunway

Accepted Answer

The answer of SUNSHINE AIRLINE COMPANY
The ER Diagram for the...

Question 5

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,Symbol1 should be:
A)||
B)>|
C)>○
D)|○

Accepted Answer

The answer of SUNSHINE AIRLINE COMPANY
The ER Diagram for the...

Question 6

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 xxx?
A)AirplaneTypeID
B)NoOfEngines
C)AirportID
D)LengthOfRunway

Accepted Answer

AirplaneTypeID is the correct choice because it directly relates to the specific attributes or characteristics of airplanes, which is relevant in the context of an airline company's ER diagram. This identifier would be used to distinguish between different types of airplanes in the company's fleet, which is a common requirement in such diagrams for managing and organizing airplane data.

Question 7

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.
-Observe the ER diagram for the ZYX Company:
Which of the following is true according to the ZYX Company ER diagram?
A)An employee can serve many customers and he or she has to serve at least one customer
B)An employee can serve one customer or he or she does not have to serve any customers
C)Each employee serves exactly one customer
D)Employees do not serve customers

Accepted Answer

According to the ER diagram, the "serve" relationship between Employee and Customer is optional and the cardinality is one-to-many. This means that an employee can serve one or many customers, or no customers at all.

Question 8

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)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

Accepted Answer

The correct answer is B because in an ER diagram, when a product can be associated with many promotions but does not have to be associated with any, it indicates an optional relationship with a cardinality of zero to many. This means a product might not be part of any promotion or could be part of one or more promotions, depending on the specific instances in the database.

Question 9

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)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

Accepted Answer

According to the ER diagram, there is a one-to-many relationship between the "Product" entity and the "Promotion" entity. This means that a product can be associated with multiple promotions, but it is not necessary for a product to be associated with any promotions. Therefore, we can keep track of products that are not associated with any promotions.

Question 10

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,Symbol2 should be:
A)||
B)|<
C)○<
D)○|

Accepted Answer

The answer of SUNSHINE AIRLINE COMPANY
The ER Diagram for the...

Question 11

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?
A)AirplaneTypeID and NoOfSeats
B)NoOfEngines and NoOfSeats
C)AirportID and AirplaneTypeID
D)LengthOfRunway and NoOfSeats

Accepted Answer

The answer of SUNSHINE AIRLINE COMPANY
The ER Diagram for the...

Question 12

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

Accepted Answer

According to the ZYX Company ER diagram, each customer is signed up by exactly one employee, as shown by the one-to-many relationship between Employee and Customer entities, where Employee is the one and Customer is the many. Therefore, option C is the correct choice. Options A and B are incorrect because they suggest that a customer can be signed up by multiple employees or no employees at all, which is not supported by the ER diagram. Option D is also incorrect because the ER diagram clearly shows the relationship between Employee and Customer entities.

Question 13

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)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

Accepted Answer

According to the ER diagram, each product can be associated with only one brand as there is a one-to-many relationship between the Brand table and the Product table, with the Product table containing the foreign key to the Brand table. Therefore, option C is the correct choice.

Question 14

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

Accepted Answer

The answer of ABC RETAILER
Observe the ER diagram for the...

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

Accepted Answer

According to the ER diagram, there is a many-to-many relationship between employees and customers, which means an employee can sign up many customers and a customer can be signed up by many employees. The participation constraint is optional on the customer side, which means an employee does not have to sign up any customers. So, option B is true.

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 ppp?
A)AirplaneTypeID
B)NoOfEngines
C)AirportID
D)LengthOfRunway

Accepted Answer

The answer of SUNSHINE AIRLINE COMPANY
The ER Diagram for the...

Question 17

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)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

Accepted Answer

The answer of ABC RETAILER
Observe the ER diagram for the...

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

Accepted Answer

The answer of ABC RETAILER
Observe the ER diagram for the...

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.
-Which of the following is true according to the ZYX Company ER diagram?
A)A customer can be served by many employees and he or she has to be served by at least one employee
B)A customer can be served by one employee or he or she does not have to be served by any employees
C)Each customer is served by exactly one employee
D)Customers are not served by employees

Accepted Answer

According to the ER diagram, the relationship between customer and employee is represented by a solid line with a crow's foot on the customer side, indicating a many-to-one relationship. This means each customer can be served by at most one employee, and each employee can serve multiple customers. Therefore, option C "Each customer is served by exactly one employee" is true, while options A, B, and D are not supported by the diagram.

Question 20

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 NOT true according to the ZYX Company ER diagram?
A)Each customer has a unique CustID
B)Each employee has a unique EmpID
C)Each customer has a unique employee serving him or her
D)Each employee is serving a unique customer

Accepted Answer

According to the ER diagram, each customer is associated with one or more employees, but not necessarily a unique employee. Therefore, option C is not true. Options A and B are true based on the ER diagram. Option D is also true because an employee can serve multiple customers, but each customer is associated with only one employee.

Quiz 2: Database Requirements and ER Modeling

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?

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?

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?

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. -Observe the ER diagram for the ZYX Company: Which of the following is true according to the ZYX Company ER diagram?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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