A hospital would like to have an information system for patients' food preparation. Patient's personal details...

 

Transcribed Image Text:

A hospital would like to have an information system for patients' food preparation. Patient's personal details are to be recorded and used. Treatments and illness related to each patient are recorded. Prohibited food for those treatments and illness are also recorded. Moreover, each patient's personal preferences (vegetarian, Muslim, low fat, etc.) are also recorded. Using the Entity Relationship Model as taught in the course (Peter Chen Model), design 5NF relational database schemas for the above application and explain clearly why you think your design is in 5NF. A hospital would like to have an information system for patients' food preparation. Patient's personal details are to be recorded and used. Treatments and illness related to each patient are recorded. Prohibited food for those treatments and illness are also recorded. Moreover, each patient's personal preferences (vegetarian, Muslim, low fat, etc.) are also recorded. Using the Entity Relationship Model as taught in the course (Peter Chen Model), design 5NF relational database schemas for the above application and explain clearly why you think your design is in 5NF.

Answer rating: 100% (QA)

Er diagram er diagram is an entity relationship diagram which is used to represents the relations... View the full answer