Pleazzzzzzzzzz.

Objective: Modeling and implementing a hospital database. Purposes: 1- Learn how to model ER diagram for a database. 2. Learn how to implement database using SQL Language. Grading Criteria You should submit 1. Your ER diagram as image (PNG) using Visual Paradigm. 2- A text file that contains the whole code for the database. Project Description A hospital system that aims to track patients, doctors, room's information and more. Doctors work in the hospital, each doctor has a unique number, salary, address, gender, name, contact number and a date of birth. Hospital contains many rooms each room has a unique id and room type. There are two types of rooms Surgery room and a waiting room. The database keeps track of patients, each patient has a unique number, name, gender, address and contact info (a close person's mobile number). Patient is assigned into a room on each hospitalization to the hospital, a hospitalization contains patient id, room id, date of admission and date discharged A treatment is given to each patient by a doctor, each treatment contains the patient, the doctor and the medicine that doctor gave to the patient. Each medicine has a unique code, price, name and quantity (the quantity of this specific medicine that the hospital still has)