TEST BANK For Database Systems: Design,
Implementation, & Management 14th Edition by
Coronel & Morris
FLIGHT
Which of the following functional dependencies does not exist in the table FLIGHT?
FlightID -->NoOfPassengers
FlightID, Date -->NoOfPassengers
FlightID --> Origin
FlightID --> Destination - ANSWER: FlightID -->NoOfPassengers
A domain definition consists of the following components EXPECT:
A. Integrity Constraints
B. Format
C. Data Type
D. Logical Definition - ANSWER: Integrity Constraints
True or False
Every relation without partial functional dependencies is in 2NF - ANSWER: True
True or False
A relation is in first normal form if it has no more than one multivalued attribute -
ANSWER: False
True or False
If A, B, C, and D are columns of the table whose composite primary key is A, B while
C and D are nonkey columns, then C --> D is a transitive functional dependency. -
ANSWER: True
If a 1:M relationship is mandatory on the 1 side and optional on the M side, which of
the following is true?
A. The resulting foreign key can have null (empty) values
B. The resulting foreign key cannot have null (empty) values
C. The resulting foreign key must have null (empty) values
D. No foreign key is created as a result of mapping such a relationship - ANSWER:
The resulting foreign key cannot have null (empty) values
, ENROLLMENT
Which of the following (regarding the relation ENROLLMENT) represents the
modification anomaly?
A. If a student decides to use a longer version of his or her name, we cannot
accommodate that modification
B. If a class name changes, it may have to be changed in more than one record
C. If a student ID changes, we may have to change the class ID as well
D. If a class ID changes, we may have to change the student ID as well - ANSWER: If a
class name changes, it may have to be changed in more than one record
Tuple is a synonym for:
A. Column
B. Field
C. Row
D. Table - ANSWER: Row
An entity with two multivalued attributes will be mapped as how many relations?
A. 1
B. 2
C. 3
D. 4 - ANSWER: 3
When a regular entity type contains a multivalued attribute, one must:
A. create two new relations, one containing the multivalued attribute.
B. create two new relations, both containing the multivalued attribute.
C. create a single relation with multiple lines for each instance of the multivalued
attribute.
D. none of the above. - ANSWER: Create two new relations, one containing the
multivalued attribute.
Which of the following is NOT true? In a relational table:
A. All column names are different
B. Two rows can have the same values
C. All values in a column are from the same domain
D. Two columns can have the same values - ANSWER: Two rows can have the same
values
True or False
Foreign key column must have the same name as the primary key column it refers
to. - ANSWER: False
True or False
Every relation without transitive functional dependencies is in 3NF. - ANSWER: False
A relation without transitive functional dependencies is in 3NF only when it is also in
1NF and 2NF.
Implementation, & Management 14th Edition by
Coronel & Morris
FLIGHT
Which of the following functional dependencies does not exist in the table FLIGHT?
FlightID -->NoOfPassengers
FlightID, Date -->NoOfPassengers
FlightID --> Origin
FlightID --> Destination - ANSWER: FlightID -->NoOfPassengers
A domain definition consists of the following components EXPECT:
A. Integrity Constraints
B. Format
C. Data Type
D. Logical Definition - ANSWER: Integrity Constraints
True or False
Every relation without partial functional dependencies is in 2NF - ANSWER: True
True or False
A relation is in first normal form if it has no more than one multivalued attribute -
ANSWER: False
True or False
If A, B, C, and D are columns of the table whose composite primary key is A, B while
C and D are nonkey columns, then C --> D is a transitive functional dependency. -
ANSWER: True
If a 1:M relationship is mandatory on the 1 side and optional on the M side, which of
the following is true?
A. The resulting foreign key can have null (empty) values
B. The resulting foreign key cannot have null (empty) values
C. The resulting foreign key must have null (empty) values
D. No foreign key is created as a result of mapping such a relationship - ANSWER:
The resulting foreign key cannot have null (empty) values
, ENROLLMENT
Which of the following (regarding the relation ENROLLMENT) represents the
modification anomaly?
A. If a student decides to use a longer version of his or her name, we cannot
accommodate that modification
B. If a class name changes, it may have to be changed in more than one record
C. If a student ID changes, we may have to change the class ID as well
D. If a class ID changes, we may have to change the student ID as well - ANSWER: If a
class name changes, it may have to be changed in more than one record
Tuple is a synonym for:
A. Column
B. Field
C. Row
D. Table - ANSWER: Row
An entity with two multivalued attributes will be mapped as how many relations?
A. 1
B. 2
C. 3
D. 4 - ANSWER: 3
When a regular entity type contains a multivalued attribute, one must:
A. create two new relations, one containing the multivalued attribute.
B. create two new relations, both containing the multivalued attribute.
C. create a single relation with multiple lines for each instance of the multivalued
attribute.
D. none of the above. - ANSWER: Create two new relations, one containing the
multivalued attribute.
Which of the following is NOT true? In a relational table:
A. All column names are different
B. Two rows can have the same values
C. All values in a column are from the same domain
D. Two columns can have the same values - ANSWER: Two rows can have the same
values
True or False
Foreign key column must have the same name as the primary key column it refers
to. - ANSWER: False
True or False
Every relation without transitive functional dependencies is in 3NF. - ANSWER: False
A relation without transitive functional dependencies is in 3NF only when it is also in
1NF and 2NF.
