occurs when deletion of data about a real-world entity forces deletion of data about
another real-world entity
Give this one a try later!
Deletion Anomaly
An attribute is functionally dependent on a component of a composite primary key
Give this one a try later!
Partial Functional dependencies
, 19. What of the following is not the typical database administration and maintenance
activities?
A) Dealing with technical issues
B) Providing security for the information in the database
C) Visualizing the database requirements
D) Implementing backup and recovery procedures
Give this one a try later!
c
Every relation without partial functional dependencies is in 2NF.
Give this one a try later!
true
23. Which of the following (regarding the relation ENROLLMENT) represents the
deletion anomaly?
A) Deleting a student ID may delete a student name
B) Deleting a class ID may delete the class name
C) Deleting a class may delete all information about a student
D) Deleting a student may delete all information about a class
Give this one a try later!
d
another real-world entity
Give this one a try later!
Deletion Anomaly
An attribute is functionally dependent on a component of a composite primary key
Give this one a try later!
Partial Functional dependencies
, 19. What of the following is not the typical database administration and maintenance
activities?
A) Dealing with technical issues
B) Providing security for the information in the database
C) Visualizing the database requirements
D) Implementing backup and recovery procedures
Give this one a try later!
c
Every relation without partial functional dependencies is in 2NF.
Give this one a try later!
true
23. Which of the following (regarding the relation ENROLLMENT) represents the
deletion anomaly?
A) Deleting a student ID may delete a student name
B) Deleting a class ID may delete the class name
C) Deleting a class may delete all information about a student
D) Deleting a student may delete all information about a class
Give this one a try later!
d
