A hospital is organised into several wards. Each ward has a ward number and name, along with the number of beds in that ward. Nurses have their staff number and name, and each is assigned to a single
KIS217 System Analysis and Design Assignment Questions | WUA
KIS217 Question
A hospital is organised into several wards. Each ward has a ward number and name, along with the number of beds in that ward. Nurses have their staff number and name, and each is assigned to a single ward. Each patient in the hospital has a patient identification number, name, address and date of birth recorded. Each patient is under the care of a single consultant and is assigned to a single ward. Each consultant is responsible for several patients. Consultants have their staff number, name and specialist knowledge recorded.
1. Identify the four (4) entities for the Hospital patient System and suggest a suitable primary key for each of these entities. (4 marks)
2. Draw the ERD for the system (21 marks)
KIS217 Question
Read the following narration carefully and construct a clearly labelled decision tree.
A child under three years of age is not to be charged an admission fee. A person under eighteen is to be charged half the full admission. If a child under twelve is accompanied by an adult, however, then that person is to be charged quarter quarter-full admission. For persons over eighteen, full admission is to be charged except for students who are to be charged half admission and senior citizens (women over 60; men over 65) who are to be charged quarter full admission. A discount of 10% is to apply to all persons subject to full admission who are members of a party of ten or more. Finally, there are no student concessions on the weekend. (25 marks