ISM 218 Quiz 004
pdf
keyboard_arrow_up
School
University of North Carolina, Greensboro *
*We aren’t endorsed by this school
Course
218
Subject
English
Date
Apr 3, 2024
Type
Pages
2
Uploaded by ProfessorDiscovery15768
Database System
ISM 218
Quiz 004
1.
Which of the following is a
read
operation?
Answer
: Retrieving data from the relation
2.
Which of the following is a
modify
operation?
Answer
: Changing the existing data in the relation
3.
Every relation contains:
Answer
: Trivial functional dependency
4.
Every relation contains:
Answer
: Full key functional dependency
5.
If A --> B is an existing functional dependency, which of the following is an augmented
functional dependency?
Answer
: A, C --> B
6.
If A --> B and B --> A are existing functional dependencies, which of the following are
NOT equivalent functional dependencies?
Answer
: X --> A and A --> B
7.
ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
StudentID
StudentNameMajorID
MajorName
111
Joe
E
English
222
Bob
H
History
333
Lisa
H
History
This table will be used for the following questions citing table ENROLLMENT.
Which of the following (regarding the relation ENROLLMENT) represents the insertion
anomaly?
Answer
: Inability to insert a major without adding a student
8.
ENROLLMENT
Which of the following (regarding the relation ENROLLMENT) represents the deletion
anomaly?
Answer
: Deleting a student may delete all information about a major
9.
ENROLLMENT
Which of the following (regarding the relation ENROLLMENT) represents the
modification anomaly?
Answer
: If a major name changes, it may have to be changed in more than one
record
10.
ENROLLMENT
Which of the following actions in the table ENROLLMENT will be prevented by an
insertion anomaly?
Answer
: Entering a new major
M, Math
11.
ENROLLMENT
Which of the following is in danger of being affected by the deletion anomaly in the table
ENROLLMENT?
Answer
: Major
E, English
Not Answe
r: Major H, History
12.
ENROLLMENT
Which of the following actions in the table ENROLLMENT will be affected by a
modification anomaly?
Not Answer
: Changing the name of
Joe
to
Joseph
Not Answer
: Changing the name of
English
to
English101
Other Answers
-
None of the above
-
Changing the name of
Bob
to
Robert
13.
ENROLLMENT
Which of the following functional dependencies does NOT exist in the table
ENROLLMENT?
Answer
: StudentName --> StudentID
14.
ENROLLMENT
What type of functional dependency does NOT exist in the table ENROLLMENT?
Answer
: Partial
15.
ENROLLMENT
Table ENROLLMENT is:
Answer
: In 2NF but not in 3NF
16.
ENROLLMENT
Normalizing table ENROLLMENT to 3NF will result in:
Answer
: Two separate tables
17. An insertion anomaly occurs when a user who wants to insert data about one real world
entity is forced to enter a unique value about it.
Answer
: false
18. 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 B --> C is a partial functional dependency.
Answer
: true
19. Every relation is in 1NF.
Answer
: true
20. Every relation without partial functional dependencies is in 2NF.
Answer
: true
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help