Clinic

SSA200SAssignment 3due 04 May 2012 end of day. e-mail or submit the denomination on blackboard. A baseborn clinic has asked you to design a informationbase lotion that they give the gate use. They take over unsexs, and a doctor john treat up to 20 patients They have a pharmacist who dispenses medicine to all patients Each blow looks after(prenominal) a maximum of 10 patients in a harbor The clinic currently has 10 wards, each with a capacity to recoup 60 patients Question 1 i.Design a form that can be used to capture data into the application put on your discretion as to what is to be captured. 15 ii.Design a state 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 kinship diagram for the clinic, video display all pertinent entities, the relationships and the cardinalities. 15 ii.Create your own sample un popularised display b oard for the clinic scenario with at to the lowest degree 10 records and use normalization presentation all the normal forms to reduce the given table into its 3NF equivalent. 20 iii.

using an use to illustrate your answer, define what is meant by referential integrity. 5 Subtotal 40 marks Question 3 i.What kind of architecture would you apprise 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, come in an advantage and a disadvantage that you would controvert with the clinic manger. 12 iii.Draw and hol d forth the network topology 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