I

Instructions: The following functional dependencies are to be drawn using Draw.io. Identify all functional dependencies, primary keys, and hidden dependencies -arrows are important. Make sure all work is clear and easy to read. Professional quality is expected. Use the methods shown in class for drawing both the dependency diagrams and the logical database schema. full functional dependency arrows are drawn above the diagram (what you start with) hidden dependency arrows are drawn below the diagram Copy and paste each complete diagram into a Word doc. Then save the doc as a .pdf file for submission. 1. Patient Medication a) Based on the following, label all dependencies (given/hidden). MedName PatientiD Date Refills Allowed PatientName Dosage Shelflife b) Improve the above to 2NF. c) Create the logical database schema. Identify all primary/foreign keys. |