Database Design Multiple Choice Let us apply class material: we are given inform

Question

Database Design Multiple Choice

Let us apply class material: we are given information about a table: P(P-ID, P-case-no, P-ward-no, P-name, P-emg-contact) We also know that P-case-no rightarrow P-ward-no Just by the given structural information alone, is the table P in 3NF? (a) Yes, because it is in 1NF and 2NF (b) Yes, because there are no transitive dependencies (c) Yes, because there are no multi-valued dependencies (d) No, because it is not in 2NF (e) None of (a) through (d) is the correct answer.

Explanation / Answer

Answer is (d) No, because it is not in 2NF

Candidate Key : P-ID, P-case-no

To be in 2NF, every non-prime attribute (p-ward-no) should be dependent on whole of Candidate Key (P-ID, P-case-no) but p-ward-no is dependent only on part of candidate key. Hence it is not in 2NF.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.