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 operation that they give the gate use. They take over compensates, and a doctor push aside treat up to 20 patients They have a pharmacist who dispenses medicine to all patients Each blow looks after hold a maximum of 10 patients in a ward The clinic currently has 10 wards, each with a capacity to recover 60 patients Question 1 i.Design a form that can be used to capture selective information into the application betroth 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 history on. 15 Subtotal 30 marks Question 2 i.Write an entity race diagram for the clinic, video display all pertinent entities, the relationships and the cardinalities. 15 ii.Create your own sample un practicei sed display board 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 physical exertion 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 excuse 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, differentiate an advantage and a disadvantage that you would controvert with the clinic manger. 12 iii.Draw and dissertate the net! work 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