Translate the E/R diagram that you draw in the previous question into a set of relations, clearly marking all references and keys. Also explain your translation with a paragraph. thats the previous question :Draw an Entity Relationship diagram for modeling the following system. Use relational modelling techniques in your design. You are free to make reasonable assumptions for your model unless they conflict with the definition below. Also explain your design with a paragraph. [Caution: Create your solution using paper and pen. Then put the image of your solution here. Drawing/writing with computer tools will not be accepted. Also include your name and signature in the solution paper] Problem definition: “There is a need to keep track of data for a hospital. The hospital building consists of several departments. Each department is identified with its name. For each department, the following data should also be stored: the number of floors, opening hour, and closing hour. Each department has a number of rooms. Each room is identified by its room number, but there might be rooms with the same name in different departments. At each department, many doctors and nurses can work. A doctor is identified by his/her personal ID. For each doctor, the following data should also be stored: name, area of expertise, the date he/she started working in that hospital. A doctor may work at multiple departments. A doctor can take care of many patients. Nurse identified by his/her personal ID. For each nurse, the following data should also be stored: name, the date he/she started working in that hospital. A nurse works exactly one department. A nurse can take care of many patients. A patient is identified by his/her personal SSN. The age, gender, and name of the patients should also be stored. In addition, a medical record should also be stored for each visit of a patient. Each patient must create and appointment before coming to the hospital. An appointment should include the patient, date, department, and selected doctor.”
Translate the E/R diagram that you draw in the previous question into a set of relations, clearly marking all references and keys. Also explain your translation with a paragraph.
thats the previous question :Draw an Entity Relationship diagram for modeling the following system. Use relational modelling techniques in your design. You are free to make reasonable assumptions for your model unless they conflict with the definition below. Also explain your design with a paragraph. [Caution: Create your solution using paper and pen. Then put the image of your solution here. Drawing/writing with computer tools will not be accepted. Also include your name and signature in the solution paper]
Problem definition: “There is a need to keep track of data for a hospital. The hospital building consists of several departments. Each department is identified with its name. For each department, the following data should also be stored: the number of floors, opening hour, and closing hour. Each department has a number of rooms. Each room is identified by its room number, but there might be rooms with the same name in different departments. At each department, many doctors and nurses can work.
A doctor is identified by his/her personal ID. For each doctor, the following data should also be stored: name, area of expertise, the date he/she started working in that hospital. A doctor may work at multiple departments. A doctor can take care of many patients.
Nurse identified by his/her personal ID. For each nurse, the following data should also be stored: name, the date he/she started working in that hospital. A nurse works exactly one department. A nurse can take care of many patients.
A patient is identified by his/her personal SSN. The age, gender, and name of the patients should also be stored. In addition, a medical record should also be stored for each visit of a patient. Each patient must create and appointment before coming to the hospital. An appointment should include the patient, date, department, and selected doctor.”
Step by step
Solved in 3 steps with 3 images
