Clinic

SSA200SAssignment 3due 04 May 2012 end of day. e-mail or submit the subsidisation on black wag. A menial clinic has asked you to design a in breedationbase practise that they give the gate use. They tamp over prepares, and a doctor can treat up to 20 patients They have a pharmacist who dispenses medicine to on the whole patients Each blow looks after a maximum of 10 patients in a ward The clinic shortly has 10 wards, each with a capacity to withhold 60 patients Question 1 i.Design a form that can be utilize to capture data into the practise employ your discretion as to what is to be captured. 15 ii.Design a omen that can be utilise to generate monthly data using your discretion as to what would be of interest to drivel on. 15 Subtotal 30 marks Question 2 i.Write an entity kind diagram for the clinic, video uncover all pertinent entities, the relationships and the cardinalities. 15 ii.Create your have sample unnormalised display board for the clinic scenario with at least 10 records and use normalization video display all the normal forms to shrink the given table into its 3NF equivalent. 20 iii.

using an example to illustrate your answer, peg down what is meant by referential integrity. 5 Subtotal 40 marks Question 3 i.What kind of computer architecture would you advise the clinic to use? run low back the architecture and excuse your answer. Your justification must be betwixt 5 and 10 lines. 9 ii.The clinic would also like to be on facebook, myspace and twitter. For each of these technologies, cite an advantage and a wrong that you would controvert with the clinic manger. 12 iii.Draw and discuss the internet topology that you would suggest for the clinic to use. 9If you exigency to get a abundant essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper