Database Design

**Part ONE:** Draw an ORM diagram using the Visio Modeler tool to draw the diagram. (see deliverable 1 for more information). **25%** of the marks. **Part TWO: Essay **“*Designing a database involves building a formal model of the application area or universe of discourse (UoD). To do this properly requires a good understanding of the UoD and a means of specifying this understanding in a clear, unambiguous way??. *From “Object-Role Modelling: An Overview?? Terry Halpin, available on WOLF and online: [[login to view URL]][1] Comment on the above statement by comparing the high-level conceptual models taught in this module. (The Enhanced Entity Relationship model and Object Role Modelling.) (see Deliverable 2 for more information). ## Deliverables 1). Draw an ORM diagram for the section of the Universe of Discourse described in component one (Winterbourne Nursing Home), which deals with the different types of patients, their GP, Next of Kin and any medical information (i.e., Baseline and Assessment data). The Staff details are not required. Use the Visio Modeler tool to draw the diagram. (see attached files for more the Winterbourne Nursing Home scenario). 2). “*Designing a database involves building a formal model of the application area or universe of discourse (UoD). To do this properly requires a good understanding of the UoD and a means of specifying this understanding in a clear, unambiguous way??. *From “Object-Role Modelling: An Overview?? Terry Halpin, available on WOLF and online: [[login to view URL]][1] Comment on the above statement by comparing the high-level conceptual models taught in this module. (The Enhanced Entity Relationship model and Object Role Modelling.) You may wish to consider some of the points mentioned in “*A Comparative Analysis of Entity-Relationship Diagrams??* by SongI., Evans M, and Park E. (1995), Journal of Computer and Software Engineering*,* 3(4): 427-459, as a framework for the comparisons. (Available from <[login to view URL]>) Examples of the issues you may wish to consider are: - Does the model allow n-ary relationships or not? - How does the model represent cardinality and participation constraints? - The *place* the constraints are specified on the model. - How are overlapping and disjoint subclass entities depicted? - How is complete and partial specialization depicted? Also you may wish to comment on the readability of each model. (“*Making Data Models Readable, David Hay Information Systems Management,* 15(1), Winter 1998, pp 21-33, *reprinted at <[login to view URL]>).* You may also wish to add other elements; for example what is the availability of CASE tool support for the models, how do the models deal with recursive relationships, how do the models deal with weak entities etc. Any examples should be based on the Winterbourne Nursing Home if appropriate. 3). All requirements in deliverable 2 must be fulfilled. ## Platform Part One should be completed using Visio Modeler tool. Part Two should be in essay format, created in Microsoft Word.