• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 9 pages
Exam (elaborations)

Database Systems

Document preview thumbnail
Preview 2 out of 9 pages

Exam study book Database Systems of Thomas Connolly, Carolyn Begg - ISBN: 9780321601100, Edition: 5, Year of publication: - (Database Systems)

Content preview

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.

Connected book
 image
Thomas Connolly, Carolyn Begg Database Systems
Publisher: Unknown ISBN: 9780321601100 Edition: 5

Document information

Uploaded on
September 3, 2024
Number of pages
9
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
CA$27.19

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Sold
4
Followers
0
Items
1270
Last sold
1 week ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions