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 - > 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

No Because it is not in 2NF.

The Table is not in the 2 NF

Here the primary key are case_no and ID

the non key attribute are ward_no,name

here the ward_no partially depends on the ward_no.So 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.