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

만든이
인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?