Database Design Multiple Choice: Let us apply class material, we have a relation

Question

Database Design Multiple Choice:

Let us apply class material, we have a relation (table) schema as below: T (Doctor ID. Patient ID, Visit Date. Visit Start Time. Diagnosis, Treatment_Code, Charge) This table is for a clinic in which many doctors are practicing. Each tuple in table T documents data about a particular patient's visit with a particular doctor. In their system, each treatment code has a fixed charge, regardless of the patient, the doctor, and when the visit happened. Which of the following statement is true, concerning the above table schema? (a) T is not in 1NF (b) T is not in 2NF (c) T is not in 3NF (d) T has four sets of candidate keys (e) None of (a) through (d) is the correct answer.

Explanation / Answer

E.) None of the above is correct.

The reason behind thisbus that the given table is in 1st, 2nd as well 3rd normal form.It is in 1st normal form as there are no repeating values.It is also in the 2nd and 3rd normal form as it is in 1st normal form and there are no transitive functions and multivalued functional dependencies.There are 4 candidate keys in the given table desciption

Please rate the answer if it helped.....Thankyou

Hope it helps......

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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