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 coat that they give the gate use. They take over convolutes, and a doctor raft treat up to 20 patients They have a pharmacist who dispenses medicine to all patients Each blow looks subsequently a maximum of 10 patients in a ward The clinic currently has 10 wards, each with a capacity to carry 60 patients Question 1 i.Design a form that can be used to capture info into the application take your discretion as to what is to be captured. 15 ii.Design a advertise that can be used to generate monthly data using your discretion as to what would be of interest to tommyrot on. 15 Subtotal 30 marks Question 2 i.Write an entity alliance diagram for the clinic, video display all pertinent entities, the relationships and the cardinalities. 15 ii.Create your own sample un regulationised display board for t he clinic scenario with at least 10 records and use normalization presentation all the normal forms to reduce the given table into its 3NF equivalent. 20 iii.

using an vitrine to illustrate your answer, define what is meant by referential integrity. 5 Subtotal 40 marks Question 3 i.What kind of architecture would you fire the clinic to use? move back the architecture and justify your answer. Your plea 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, let out an advantage and a disadvantage that you would controvert with the clinic manger. 12 iii.Draw and hold forth the network topology tha t you would suggest for the clinic to use. 9! If 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