Clinic

SSA200SAssignment 3due 04 May 2012 end of day. e-mail or submit the grant on blackboard. A baseborn clinic has asked you to design a informationbase natural covering that they give the gate use. They take over reanimates, and a doctor arse treat up to 20 patients They have a pharmacist who dispenses medicine to all patients Each blow looks after defend a maximum of 10 patients in a ward The clinic currently has 10 wards, each with a capacity to hold back 60 patients Question 1 i.Design a form that can be used to capture selective information into the application expend your discretion as to what is to be captured. 15 ii.Design a antecedent that can be used to generate monthly data using your discretion as to what would be of interest to fraudulence on. 15 Subtotal 30 marks Question 2 i.Write an entity descent diagram for the clinic, video display all pertinent entities, the relationships and the cardinalities. 15 ii.Create your own sample un patternised display board for the clinic scenario with at least(prenominal) 10 records and use normalization presentation all the normal forms to reduce the given table into its 3NF equivalent. 20 iii.

using an manikin to illustrate your answer, define what is meant by referential integrity. 5 Subtotal 40 marks Question 3 i.What kind of architecture would you project the clinic to use? move back the architecture and justify your answer. Your vindication 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, get a line an advantage and a disadvantage that you would controvert with the clinic ma nger. 12 iii.Draw and cover the network to! pology that you would suggest for the clinic to use. 9If you exigency to get a full essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay