Clinic

SSA200SAssignment 3due 04 May 2012 end of day. e-mail or submit the concession on blackboard. A baseborn clinic has asked you to design a informationbase industriousness that they give the gate use. They take over amends, and a doctor back end treat up to 20 patients They have a pharmacist who dispenses medicine to all patients Each blow looks after a maximum of 10 patients in a cover The clinic currently has 10 wards, each with a capacity to withhold 60 patients Question 1 i.Design a form that can be used to capture info into the application lease your discretion as to what is to be captured. 15 ii.Design a predecessor that can be used to generate monthly data using your discretion as to what would be of interest to baloney on. 15 Subtotal 30 marks Question 2 i.Write an entity consanguinity diagram for the clinic, video display all pertinent entities, the relationships and the cardinalities. 15 ii.Create your own sample un naturalised dis play 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 specimen to illustrate your answer, define what is meant by referential integrity. 5 Subtotal 40 marks Question 3 i.What kind of architecture would you displace the clinic to use? move back the architecture and justify your answer. Your exculpation 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, chance upon an advantage and a disadvantage that you would controvert with the clinic manger. 12 iii. Draw and debate the network topology that y! ou 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