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