SAD KIS217 Faculty of Management and Entrepreneurial Sciences Individual Assignment

Question

A hospital is organised into a number of 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 a number of 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)

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 full admission. If a child under twelve is accompanied by an adult however, then that person is to be charged quarter full admission. For persons over eighteen full admissions 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 week-end.

(25 marks)

Answer

Request Answer of this Assignment