MISM 3136 /CPSC 3131 Database Design Lab Assignment \#2 1. Task \#1 - Development of Complete ERD We learned about how to extract tables and how to make the relationship. In this lab, we will practice the entire process of developing an ERD. Below is the description of the business process of a hospital. Provide a complete ERD after reading the case. The ERD should include tables, attributes, relationships, and cardinality. To show the relationships and cardinalities, use crow's foot notation. When drawing the diagram use the PowerPoint file named Lab Assigment \#2-ERD.ppt and submit the file to CougarVIEW. ERD symbols are provided in the PowerPoint file. Use them by copying and pasting into your diagram. Description of business process In hospital, there are many departments like Orthopedic, Pathology, Emergency, Dental, Gynecology, Anesthetics, I.C.U., Blood Bank, Operation Theater, Laboratory, M.R.I., Neurology, Cardiology, Cancer Department, Corpse, etc. There is an OPD (out patient department) where patients come and get a card (that is, entry card of the patient) for check up from the concerned doctor. After making entry in the card, they go to the concerned doctor's room and the doctor checks up their ailments. According to the ailments, the doctor either prescribes medicine or admits the patient in the concerned department. The patient may choose either private or general room according to his/her need. But before getting admission in the hospital, the patient has to fulfill certain formalities of the hospital like room charges, etc. After the treatment is completed, the doctor discharges the patient. Before discharging from the hospital, the patient again has to complete certain pasting into your diagram. Description of business process In hospital, there are many departments like Orthopedic, Pathology, Emergency, Dental, Gynecology, Anesthetics, I.C.U., Blood Bank, Operation Theater, Laboratory, M.R.I., Neurology, Cardiology, Cancer Department, Corpse, etc. There is an OPD (out patient department) where patients come and get a card (that is, entry card of the patient) for check up from the concerned doctor. After making entry in the card, they go to the concerned doctor's room and the doctor checks up their ailments. According to the ailments, the doctor either prescribes medicine or admits the patient in the concerned department. The patient may choose either private or general room according to his/her need. But before getting admission in the hospital, the patient has to fulfill certain formalities of the hospital like room charges, etc. After the treatment is completed, the doctor discharges the patient. Before discharging from the hospital, the patient again has to complete certain formalities of the hospital like balance charges, test charges, operation charges (if any), blood charges, doctors' charges, etc. Next, we talk about the doctors of the hospital. There are two types of the doctors in the hospital, namely, regular doctors and call on doctors. Regular doctors are those doctors who come to the hospital daily. Calls on doctors are those doctors who are called by the hospital if the concerned doctor is not available. Source: http://ggn.dronacharya.info/CSEDept/Downloads/QuestionBank/Even/IV\%20sem/ DBMS_case_studies_CSE_IVSem.pdf Provide your answer in the given ppt file. \begin{tabular}{|c|} \hline \multicolumn{1}{|c|}{ Table Name } \\ \hline Primary Key \\ \hline Attribute 1 \\ Attribute 2 \\ \hline \end{tabular} [0