Question 1: Draw ER diagram for the situation given below:

Consider a hospital where the doctors treat patients in a single ward. Usually each patient will be assigned a single doctor, but in rare cases they will have two. Healthcare assistants also attend to the patients; a number of these are associated with each ward. Initially the system will be concerned solely with drug treatment. Each patient is required to take a variety of drugs a certain number of times per day and for varying lengths of time. The system must record details concerning patient treatment and staff payment. Some staff are paid part time and doctors and care assistants work varying amounts of overtime at varying rates (subject to grade). The system will also need to track what treatments are required for which patients and when and it should be capable of calculating the cost of treatment per week for each patient (though it is currently unclear to what use this information will be put). Now perform following tasks:

1. Transform the Diagram created by you in to respective relations.
2. Create functional dependency set by considering the attributes used in ER Diagram.
3. Analyse the relation and functional dependency set generated by you and suggest which normal form they support.
4. Say the relations developed by you are not in 2NF then how will you do bring them in 2NF. Suggest any technique to achieve 2NF.
5. How will you check that the relation status after normalisation is Loss less and Dependency preserving.