Question 1

If the referential integrity delete rule between two relations is restrict, an attempt to delete a record on the "many side" of the one-to-many will be rejected if of one or more records in the relation on the "one side" of the relationship has the corresponding key value.

Accepted Answer

A) True 
 B)False

Question 2

A ternary relationship ____.

Accepted Answer

A)  cannot have intersection data associated with it 
B)  stores its intersection data in the three relations created to represent the three binary many-to-many relationships that form the ternary relationship 
C)  stores its intersection data in the three relations that represent the three entity types in the ternary relationship 
D)  stores its intersection data in one of the three relations that represent the three entity types in the ternary relationship 
E)  None of the above.

Question 3

If the referential integrity delete rule between two relations is restrict, the deletion of a record in the relation on the "one side" of the one-to-many relationship may result in the deletion of one or more records in the relation on the "many side" of the relationship.

Accepted Answer

A) True 
 B)False

Question 4

Referential integrity is an issue in record ____.

Accepted Answer

A)  insertion 
B)  deletion 
C)  update 
D)  All of the above 
E)  None of the above

Question 5

If the referential integrity delete rule between two relations is cascade, the deletion of a record in the relation on the "many side" of the one-to-many relationship may result in the deletion of one or more records in the relation on the "one side" of the relationship.

Accepted Answer

A) True 
 B)False

Question 6

If the referential integrity delete rule between two relations is cascade, the deletion of a record in the relation on the "one side" of the one-to-many relationship may result in the deletion of one or more records in the relation on the "many side" of the relationship.

Accepted Answer

A) True 
 B)False

Question 7

A ternary relationship may have intersection data associated with it.

Accepted Answer

A) True 
 B)False

Question 8

The following scenario applies to the next several questions:
Consider relations A and B. Relation A represents the entity on the "one side" of a one-to-many relationship; Relation B represents the entity on the "many side" of the one-to-many relationship.
-The delete rule between relations A and B is cascade. If an attempt is made to delete a record in relation A and its primary key value appears as a foreign key value in one or more records of relation B ____.

Accepted Answer

A)  the record in relation A will be the only record deleted and no other changes will occur 
B)  the record in relation A will be the only record deleted and the foreign key values in relation B that match the primary key value of the record in relation A will be updated to null 
C)  the record in relation A and all of the records in relation B with foreign key values that match the primary key value of the record in relation A will be deleted 
D)  only the records in relation B with foreign key values that match the primary key value of the record in relation A will be deleted 
E)  no records will be deleted

Question 9

If the referential integrity delete rule between two relations is set-to-null, the deletion of a record in the relation on the "one side" of the one-to-many relationship may result in the deletion of one or more records in the relation on the "many side" of the relationship.

Accepted Answer

A) True 
 B)False

Question 10

A ternary relationship involves relations for two different entity types plus an additional relation.

Accepted Answer

A) True 
 B)False

Question 11

A ternary relationship is the equivalent of ____ binary many-to-many relationship(s).

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four 
E)  None of the above.

Question 12

A ternary relationship is the functional equivalent of three different binary many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 13

Consider the following ANIMAL and ENCLOSURE relations from the Central Zoo relational database. The left-hand column of relative record numbers is there to facilitate answering some of the questions.
 $\begin{array}{ll}&\text { Enclosure }\
&\text { Number }\quad\text { Type }\quad\quad\quad\text { Size }\
\begin{array}{lr}
1\2\3\4\5
\end{array}&
\begin{array}{|r|l|r|}
\hline 0347 & \text { Glass Cage } & 400 \
\hline 0636 & \text { Fenced Yard } & 1500 \
\hline 0912 & \text { Natural Area } & 2000 \
\hline 1483 & \text { Fenced Yard } & 1650 \
\hline 1660 & \text { Steel Cage } & 700 \
\hline
\end{array}\end{array}$ Enclosure relation
 $\begin{array}{ll}
&\text { Animal } \quad\quad\quad\quad\quad\quad \text { Animal }\quad \quad \text { Enclosure }\
&\text { Number \quad Species\quad\quad Name\quad\quad\quad\quad Number }\
\begin{array}{ll}
1\2\3\4\5\6\7\8\9\10
\end{array}&\begin{array}{|c|l|l|r|}
\hline 13648 \quad& \text { Elephant } & \text { Jumbo } & 1483 \
\hline 15273 & \text { Giraffe } & \text { Stretch } & 0912 \
\hline 17543 & \text { Elephant } & \text { Shirley } & 0636 \
\hline 20165 & \text { Giraffe } & \text { Necky } & 0912 \
\hline 23743 & \text { Giraffe } & \text { High Top } & 0912 \
\hline 27579 & \text { Panda } & \text { Fluffy } & 0347 \
\hline 32565 & \text { Elephant } & \text { Large Louie } & 1483 \
\hline 33837 & \text { Elephant } & \text { Charley } & 0636 \
\hline 36340 & \text { Panda } & \text { Huggy } & 0347 \
\hline 40436 & \text { Giraffe } & \text { Sarah } & 0912 \
\hline
\end{array}
\end{array}$
 Animal relation 
a. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is restrict and an attempt is made to delete the record for enclosure number 0912 in the ENCLOSURE relation?
b. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is restrict and an attempt is made to delete the record for enclosure number 1660 in the ENCLOSURE relation?
c. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is restrict and an attempt is made to delete the record for animal number 40436 in the ANIMAL relation?
d. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is cascade and an attempt is made to delete the record for enclosure number 0912 in the ENCLOSURE relation?
e. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is cascade and an attempt is made to delete the record for enclosure number 1660 in the ENCLOSURE relation?
f. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is set-to-null and an attempt is made to delete the record for enclosure number 0912 in the ENCLOSURE relation?
g. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is set-to-null and an attempt is made to delete the record for enclosure number 1660 in the ENCLOSURE relation?

Accepted Answer

The answer of Consider the following ANIMAL and ENCLOSURE relations...

Question 14

Consider the following relational database for the Central Zoo. Central Zoo wants to maintain information about its animals, the enclosures in which they live, and its zookeepers and the services they perform for the animals. In addition, Central Zoo has a program by which people can be sponsor of animals. Central Zoo wants to track its sponsors, their dependents, and associated data.
Each animal has a unique animal number and each enclosure has a unique enclosure number. An animal can live in only one enclosure. An enclosure can have several animals in it or it can be currently empty. A zookeeper has a unique employee number. Some zookeepers supervise other zookeepers. Every animal has been cared for by at least one and generally many zookeepers; each zookeeper has cared for at least one and generally many animals. Each time a zookeeper performs a specific, significant service for an animal the service type, date, and time are recorded. A zookeeper may perform a particular service on a particular animal more than once on a given day.
A sponsor, who has a unique sponsor number and a unique social security number, sponsors at least one and possibly several animals. An animal may have several sponsors or none. For each animal that a particular sponsor sponsors, the zoo wants to track the annual sponsorship contribution and renewal date. In addition, Central Zoo wants to keep track of each sponsor's dependents. A sponsor may have several dependents or none. A dependent is associated with exactly one sponsor.
 $$\begin{array} { | l | l | l | l | l |} 
\hline \text { Enclosure } & & & & \text { Date } \
\text { Number } & \text { Type } & \text { Location } & \text { Size } & \text { Built }\
\hline
\end{array}$$ ENCLOSURE Relation

$$\begin{array} { | l | l | l | l | l | l | l | } 
\hline \text { Animal } & & \text { Animal } & & \text { Country } &&\text { Enclosure }\
\text { Number } & \text { Species } & \text { Name } & \text { Gender } & \text { Of Birth }&\text { Weight }&\text { Number }\
\hline
\end{array}$$ ANIMAL Relation

$$\begin{array} { | l | l | l | l | l | } 
\hline \text { Employee } & \text { Employee } & & \text { Year } & \text { Supervisor } \
\text { Number } & \text { Narne } & \text { Title } & \text { Hired } & \text { Number } \
\hline
\end{array}$$ ZOOKEEPER Relation
 $$\begin{array} { | l | l | l | l | l |} 
\hline\text { Animal } & \text { Employee } & \text { Service } & & \
\text { Number } & \text { Number } & \text { Type } & \text { Date } & \text { Time }\
\hline
\end{array}$$ CARES FOR Relation

$\begin{array}{|l|l|l|l|l|}
\hline \text { Sponsor } & \text { Social Security } & \text { Sponsor } & & \
\text { Number } & \text { Number } & \text { Name } & \text { Address } & \text { Telephone }\\hline 
\end{array}$ SPONSOR Relation

$$\begin{array} { | l | l | l | l | } 
\hline \text { Animal } & \text { Sponsor } & \text { Annual } & \text { Renewal } \
\text { Number } & \text { Number } & \text { Contribution } & \text { Date }\
\hline
\end{array}$$ CONTRIBUTION Relation

$$\begin{array} { | l | l | l | l | } 
\hline \text { Sponsor } & \text { Dependent } & & \text { Date of } \
\text { Number } & \text { Name } & \text { Relationship } & \text { Birth }\
\hline
\end{array}$$ DEPENDENT Relation

a. Identify the candidate keys of each relation.
b. Identify the primary key and any alternate keys of each relation.
c. How many foreign keys does each relation have?
d. Identify the foreign keys of each relation.
e. Indicate any instances in which a foreign key serves as part of the primary key of the relation in which it is a foreign key. Why does each of those relations require a multi-attribute primary key?
f. Identify the relations that support many-to-many relationships, the primary keys of those relations, and any intersection data.
g. Using the informal relational command language described in this chapter, write commands to:
i. Retrieve the record for animal number 58560.
ii. Retrieve the record for the tiger named Stripes.
iii. List all of the tigers born in India.
iv. List the name and animal number of every animal born in China that weighs less than 100 pounds .
v. List the name and number of every tiger.
vi. What is the country of birth of animal number 74371?
vii. What is the type and size of the enclosure used for animal number 74371?
viii. List the name and address of every sponsor of animal number 74371.

Accepted Answer

The answer of Consider the following relational database for the...

Question 15

Storing a ternary relationship in a relational database requires the creation of an additional relation.

Accepted Answer

A) True 
 B)False

Question 16

Representing a ternary relationship in a relational database ____.

Accepted Answer

A)  requires the creation of an additional relation 
B)  requires adding a new column, the domain of values of which is the same as the relation's primary key 
C)  requires adding a new column, the domain of values of which is the same as the primary key of another relation in the database 
D)  requires modifying the primary key of the relation 
E)  requires replacing the primary key of the relation with an alternate key

Question 17

Consider the following AIRPLANE and FLIGHT relations from the Grand Travel Airlines relational database. The left-hand column of relative record numbers is there to facilitate answering some of the questions:
 $\begin{array}{ll}
&\text { Airplane } \quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad \text { Passenger Year }\
&\text { Number\quad Manufacturer\quad Model\quad Capacity\quad Built }\
\begin{array}{lr}
1\2\3\4
\end{array}&\begin{array}{|r|l|l|r|r|}
\hline 04653\quad & \text { Boeing }\quad\quad & 767\quad\quad & 280\quad & 1988\quad \
\hline 10582 & \text { Airbus } & \text { A320 } & 256 & 1997 \
\hline 16420 & \text { Canadair } & \text { CRJ } & 54 & 2001 \
\hline 22663 & \text { Boeing } & 767 & 265 & 1999 \
\hline
\end{array}
\end{array}$
 Airplane relation
 \(\begin{array}{lr}
&\text { Flight } \quad\quad\quad\quad\quad\quad\quad \text { Departure }\quad  \text { Arrival }\quad  \text { Airplane } \
&\text { Number }\quad  \text { Date }\quad\quad\quad  \text { Time }\quad\quad\quad  \text { Time \quad\quad}  \text { Number }\
\begin{array}{lr}
1\2\3\4\5\6\7\8\9
\end{array}&
\begin{array}{|r|r|r|r|r|}
\hline 005 \quad& 11 / 15 / 2003 & 2: 14 \mathrm{PM} & 4: 20 \mathrm{PM} & 22663 \
\hline 018 & 01 / 24 / 2004 & 11: 00 \mathrm{AM} & 1: 32 \mathrm{PM} & 10582 \
\hline 032 & 11 / 15 / 2003 & 9: 03 \mathrm{AM} & 10: 30 \mathrm{AM} & 16420 \
\hline 032 & 11 / 16 / 2003 & 8: 57: \mathrm{AM} & 10: 23 \mathrm{AM} & 16420 \
\hline 032 & 11 / 17 / 2003 & 9: 00 \mathrm{AM} & 10: 33 \mathrm{AM} & 16420 \
\hline 120 & 01 / 24 / 2004 & 7: 52 \mathrm{PM} & 9: 34 \mathrm{PM} & 16420 \
\hline 120 & 01 / 28 / 2004 & 7: 51 \mathrm{PM} & 9: 57 \mathrm{PM} & 16420 \
\hline 154 & 11 / 15 / 2003 & 12: 58 \mathrm{PM} & 3: 30 \mathrm{PM} & 10582 \
\hline 197 & 02 / / 12 / 2004 & 5: 03 \mathrm{PM} & 7: 22 \mathrm{PM} & 22663 \
\hline
\end{array}\end{array}\) Flight relation 
a. What would happen if the delete rule between the AIRPLANE and FLIGHT relations is restrict and an attempt is made to delete the record for airplane number 16420 in the AIRPLANE relation?
b. What would happen if the delete rule between the AIRPLANE and FLIGHT relations is restrict and an attempt is made to delete the record for airplane number 04653 in the AIRPLANE relation?
c. What would happen if the delete rule between the AIRPLANE and FLIGHT relations is restrict and an attempt is made to delete the record for flight number 120 on 01/24/2004 in the FLIGHT relation?
d. What would happen if the delete rule between the AIRPLANE and FLIGHT relations is cascade and an attempt is made to delete the record for airplane number 16420 in the AIRPLANE relation?
e. What would happen if the delete rule between the AIRPLANE and FLIGHT relations is cascade and an attempt is made to delete the record for airplane number 04653 in the AIRPLANE relation?
f. Record 3 in the AIRPLANE relation would be deleted and the Airplane Number values of records 3, 4, 5, 6, and 7 in the FLIGHT relation would be updated to null.
g. Record 1 in the AIRPLANE relation would be deleted.

Accepted Answer

The answer of Consider the following AIRPLANE and FLIGHT relations...

Question 18

Representing a unary one-to-many relationship in a relational database requires the addition of one column to the relation that represents the single entity involved in the relationship.

Accepted Answer

A) True 
 B)False

Question 19

The following scenario applies to the next several questions:
Consider relations A and B. Relation A represents the entity on the "one side" of a one-to-many relationship; Relation B represents the entity on the "many side" of the one-to-many relationship.
-The delete rule between relations A and B is restrict. If an attempt is made to delete a record in relation A and its primary key value appears as a foreign key value in one or more records of relation B ____.

Accepted Answer

A)  the record in relation A will be the only record deleted and no other changes will occur 
B)  the record in relation A will be the only record deleted and the foreign key values in relation B that match the primary key value of the record in relation A will be updated to null 
C)  the record in relation A and all of the records in relation B with foreign key values that match the primary key value of the record in relation A will be deleted 
D)  only the records in relation B with foreign key values that match the primary key value of the record in relation A will be deleted 
E)  no records will be deleted

Exam 6: The Relational Database Model: Additional Concepts

If the referential integrity delete rule between two relations is restrict, an attempt to delete a record on the "many side" of the one-to-many will be rejected if of one or more records in the relation on the "one side" of the relationship has the corresponding key value.

A ternary relationship ____.

If the referential integrity delete rule between two relations is restrict, the deletion of a record in the relation on the "one side" of the one-to-many relationship may result in the deletion of one or more records in the relation on the "many side" of the relationship.

Referential integrity is an issue in record ____.

If the referential integrity delete rule between two relations is cascade, the deletion of a record in the relation on the "many side" of the one-to-many relationship may result in the deletion of one or more records in the relation on the "one side" of the relationship.

If the referential integrity delete rule between two relations is cascade, the deletion of a record in the relation on the "one side" of the one-to-many relationship may result in the deletion of one or more records in the relation on the "many side" of the relationship.

A ternary relationship may have intersection data associated with it.

If the referential integrity delete rule between two relations is set-to-null, the deletion of a record in the relation on the "one side" of the one-to-many relationship may result in the deletion of one or more records in the relation on the "many side" of the relationship.

A ternary relationship involves relations for two different entity types plus an additional relation.

A ternary relationship is the equivalent of ____ binary many-to-many relationship(s) .

A ternary relationship is the functional equivalent of three different binary many-to-many relationships.

Storing a ternary relationship in a relational database requires the creation of an additional relation.

Representing a ternary relationship in a relational database ____.

Representing a unary one-to-many relationship in a relational database requires the addition of one column to the relation that represents the single entity involved in the relationship.