Database Design Multiple Choice

Let us apply what we have learned in class. We have the following relational schema: Please normalize the above relational schema, so that the new design is a correct database schema that will replace the above design and will conform to 3NF. After that, please answer the following question. According to the new design that achieves 3NF, which of the following statement is FALSE? (a) One of the relations in the new schema is: PATIENT (PatientID. PatientName) (b) One of the relations in the new schema is: Medicine (MedName, ShelfLife, Dosage) (c) One of the relations in the new schema is: Prescription (MedName, PatientID, PresecriptionPatem NoOfRefills, Dosage) (d) The new design that achieves 3NF without losing any original information has a total of 3 tables. (e) All of (a) through (d) are TRUE