Deck 2: Database Requirements and ER Modeling

Question 1

The following attribute can contain more than one value for each entity instance.

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

Answer 1

C

Question 2

Which of the following is a legitimate exact minimum and maximum cardinality?

A)(20,10)
B)(5,0)
C)(5,10)
D)(5,4)

Answer 2

C

Question 3

How many entities are involved in a unary relationship?

A)1
B)2
C)More than 2
D)Between 1 and 2

Answer 3

A

Question 4

Minimum cardinality can be:

A)One or many
B)Zero or many
C)Optional or mandatory
D)Optional or many

Question 5

Which of the following is NOT a possible cardinality constraint?

A)Optional one
B)Optional zero
C)Optional many
D)Mandatory one

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.

In the ER Diagram for the SUNSHINE AIRLINE COMPANY,which word should replace BBB?

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

Question 7

A regular entity must have at least one of the following attributes:

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

Question 8

How many entities are depicted by the following requirements?
School XYZ keeps track of its 100 students,10 teachers,and 5 classrooms.

A)3
B)4
C)115
D)116

Question 9

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

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

Question 10

How many entities are involved in a binary relationship?

A)1
B)2
C)More than 2
D)Between 1 and 2

Question 11

Maximum cardinality can be:

A)One or many
B)Zero or many
C)Optional or mandatory
D)Optional or many

Question 12

A multivalued composite attribute can be used to depict which of the following weak entity concepts?

A)Partially unique attribute
B)Identifying relationship
C)A regular (non-identifying)one-to-many relationship between a weak entity and a regular entity
D)A regular (non-identifying)many-to-many relationship between a weak entity and a regular entity

Question 13

Attribute B of EntityX is a:

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

Question 14

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

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

Question 15

What type of ternary relationship CANNOT be depicted as two binary relationships?

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

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.

In the ER Diagram for the SUNSHINE AIRLINE COMPANY,which word should replace AAA?

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

Question 17

The following attribute represents a collection of attributes:

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

Question 18

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

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

Question 19

Which of the following is a possible type of relationship (maximum cardinality-wise)?

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

Question 20

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

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

Question 21

ABC RETAILER
Observe the ER diagram for the ABC Retailer:

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

Question 22

ABC RETAILER
Observe the ER diagram for the ABC Retailer:

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

Question 23

ABC RETAILER
Observe the ER diagram for the ABC Retailer:

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

Question 24

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.

In the ER Diagram for the SUNSHINE AIRLINE COMPANY,which word should replace qqq?

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

Question 25

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.

In the ER Diagram for the SUNSHINE AIRLINE COMPANY,Symbol1 should be:

A)||
B)>|
C)>○
D)|○

Question 26

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.

In the ER Diagram for the SUNSHINE AIRLINE COMPANY,which word should replace xxx?

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

Question 27

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:

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

Question 28

ABC RETAILER
Observe the ER diagram for the ABC Retailer:

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

Question 29

ABC RETAILER
Observe the ER diagram for the ABC Retailer:

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

Question 30

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.

In the ER Diagram for the SUNSHINE AIRLINE COMPANY,Symbol2 should be:

A)||
B)|<
C)○<
D)○|

Question 31

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.

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

Question 32

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:

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

Question 33

ABC RETAILER
Observe the ER diagram for the ABC Retailer:

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

Question 34

ABC RETAILER
Observe the ER diagram for the ABC Retailer:

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

Question 35

ZYX COMPANY
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 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 36

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.

In the ER Diagram for the SUNSHINE AIRLINE COMPANY,which word should replace ppp?

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

Question 37

ABC RETAILER
Observe the ER diagram for the ABC Retailer:

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

Question 38

ABC RETAILER
Observe the ER diagram for the ABC Retailer:

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

Question 39

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:

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

Question 40

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:

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

Question 41

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

Question 42

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:

Which of the following is true according to the ZYX Company ER diagram?

A)A customer cannot refer another customer
B)A customer can refer either only one customer or no customers at all
C)A customer can refer many customers
D)A customer must refer many customers

Question 43

Within one entity,each attribute name must be different.

Question 44

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:

Which of the following is true according to the ZYX Company ER diagram?

A)We cannot keep track of employees that do not sign up any customers
B)We cannot keep track of employees that do not serve any customers
C)We cannot keep track of employees that serve multiple customers
D)We cannot keep track of employees that sign up multiple customers

Question 45

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:

Which of the following is NOT true according to the ZYX Company ER diagram?

A)We can keep track of employees that have multiple cell phone numbers
B)We can keep track of employees that have multiple office phone numbers
C)We can keep track of employees that have one cell phone number
D)We can keep track of employees that have one office phone number

Question 46

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

Question 47

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:

Which of the following is true according to the ZYX Company ER diagram?

A)We will store CustomerBDate value for each customer
B)We will store OfficePhoneNumber value for each employee
C)We will store CustomerAge value for each customer
D)All of the above

Question 48

A unique attribute is an attribute whose value is different for each entity instance.

Question 49

Maximum cardinality can be optional.

Question 50

Entity instances are depicted in ER diagrams.

Question 51

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:

Which of the following is true according to the ZYX Company ER diagram?

A)A customer cannot be referred by another customer
B)A customer can be referred by at most one customer
C)A customer can be referred by many customers
D)A customer must be referred by another customer

Question 52

Minimum cardinality can be many.

Question 53

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?

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

Question 54

CENTRAL SCHOOL LIBRARY
Observe the ER diagram for the CENTRAL SCHOOL LIBRARY

Which of the following is true according to the Central School Library ER diagram?

A)Each library book must have at least one copy
B)Each library book must have multiple copies
C)Each library book must have at least 10 copies
D)Each library book must have more than 2 copies

Question 55

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?

A)A book can have no authors
B)A book can have one author
C)A book can have two authors
D)A book can have more than two authors

Question 56

ER modeling is a widely used logical database modeling method.

Question 57

Within an ER diagram,each entity must be related to at least one other entity via a relationship.

Question 58

Relationship instances occur when an instance of one entity is related to an instance of another entity via a relationship.

Question 59

ZYX COMPANY
Observe the ER diagram for the ZYX COMPANY:

Which of the following is true according to the ZYX Company ER diagram?

A)We can keep track of customers that are not served by any employees
B)We can keep track of customers that are not signed up by any employees
C)We can keep track of customers that are served by multiple employees
D)We can keep track of customers that are not referred by any customers

Question 60

CENTRAL SCHOOL LIBRARY
Observe the ER diagram for the CENTRAL SCHOOL LIBRARY

Which of the following is true according to the Central School Library ER diagram?

A)We cannot keep track of authors that did not write any of the library books
B)We cannot keep track of authors that wrote only one of the library books
C)We cannot keep track of authors that wrote multiple library books
D)We cannot keep track of authors that wrote more than 10 library books

Question 61

EAGLERUN TRUCKING DISPATCHER
Observe the ER diagram for the Eaglerun Trucking Dispatcher:

According to the Eaglerun Trucking Dispatcher ER diagram,each driver has a unique DriverID value.

Question 62

A unary relationship can have one or many maximum cardinalities on either side.

Question 63

Two entities can be related via multiple different binary relationships.

Question 64

Exact maximum cardinality is calculated by adding the exact minimum cardinalities.

Question 65

A ternary relationship can always be depicted as three binary relationships.

Question 66

An attribute can be a part of several composite attributes.

Question 67

EAGLERUN TRUCKING DISPATCHER
Observe the ER diagram for the Eaglerun Trucking Dispatcher:

According to the Eaglerun Trucking Dispatcher ER diagram,each truck has a unique TruckModel value.

Question 68

A weak entity that has a 1:1 identifying relationship with its owner,must have a partial key.

Question 69

An optional attribute occurs only in an entity that is involved in a relationship with optional participation.

Question 70

EAGLERUN TRUCKING DISPATCHER
Observe the ER diagram for the Eaglerun Trucking Dispatcher:

According to the Eaglerun Trucking Dispatcher ER diagram,each truck has a unique TruckID value.

Question 71

Adding a unique attribute to a weak entity converts the weak entity to a regular entity.

Question 72

EAGLERUN TRUCKING DISPATCHER
Observe the ER diagram for the Eaglerun Trucking Dispatcher:

According to the Eaglerun Trucking Dispatcher ER diagram,each driver has a unique DriverName value.

Question 73

A unary relationship cannot have mandatory participation on both sides.

Question 74

Each instance of a weak entity must participate in one instance of the identifying relationship.

Question 75

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.

Question 76

EAGLERUN TRUCKING DISPATCHER
Observe the ER diagram for the Eaglerun Trucking Dispatcher:

According to the Eaglerun Trucking Dispatcher ER diagram,each driver has a unique DriverLicenseNo value.

Question 77

Every ER notation uses the same rule for placement of cardinality constraints in the relationships of the ER diagram.

Question 78

A relationship of degree 3 (also known as a ternary relationship)depicts 3 or more entities involved in one relationship.

Question 79

A weak entity that has a 1:M identifying relationship with its owner must have a partial key.

Question 80

Components of a unique composite attribute are not unique.