1) Which of the following statements is NOT correct regarding normalization? a) Redundancy removal b) Dependency preservation c) Anomaly removal d) Proper structuring 2) A table stores (StudentID, CourseID, Instructor, InstructorPhone). Deleting last tuple removes related info. Which anomaly? a) Insertion anomaly b) Update anomaly c) Deletion anomaly d) Functional anomaly 3) Which of the following relations is in 1NF but NOT in 2NF? a) No partial dependency b) Has partial dependency c) No transitive dependency d) No FDs 4) A relation R(A, B, C, D) has FDs: A → B and (A, C) → D. Which statement is correct? a) Not in 2NF due to partial dependency b) Relation is in 2NF c) Relation is not in 1NF d) Relation is in 3NF 5) Given R(A, B, C) with FDs: F → E and E → L. Which statement is correct? a) Relation is in 2NF but not in 3NF b) Relation is in 3NF c) Relation is in BCNF d) Relation is not in 1NF 6) Given R(A, B, C) with FDs: A → B and B → A, Which is TRUE? a) Relation is not in 3NF b) Relation is in 3NF but not BCNF c) Relation is in BCNF d) Relation violates 1NF 7) A relation is in 5NF if: a) No multivalued dependencies b) All FDs have key on LHS c) No transitive dependencies d) Every join dependency is trivial

DBMS_Normalization_RECAP

af
Trykke
Integrere

Rangliste

Visuel stil

Indstillinger

Skift skabelon

Gendan automatisk gemt: ?