Draw a determinancy diagram for the attributes ward Name, ward Type, patient No, patient Name, patient Blood Group. Each ward is of only one ward Type, and a patient has only one patient Name and one...

Draw a determinancy diagram for the attributes ward Name, ward Type, patient No, patient Name, patient Blood Group. Each ward is of only one ward Type, and a patient has only one patient Name and one patient Blood Group. Only current assignments of patients to wards are of interest. Derive a set of fully-normalised tables. How is the relationship between the entity types Ward and Patient represented in your tables? How are out-patients distinguished from in-patients?