Improving database design through the analysis of relationships (Example)

Document Preview:

Database Relationship Analysis Students Name Institutional Affiliation Instructor Date of Submission Principal goals of the work presented by the authors The authors are discussing the ER model and its application in the business environment. They have identified the various relationships in a database that includes functional partial and general and recursive. They have discussed the process that involves converting a conceptual framework into a relational model. Their main objective was to improve the database design through the understanding of various relationships in an ER model. They aim to make the designer understand and identify the various relationships within an ER model. This will erase the burden of the designer extracting information from the real world and representing it in ER model. Design implications identified in this paper Real-world decisions are considered dissimilar if of information provided by the authors is professional and will be of great value to ER model designers. They are able to relate to real-world situations making them more relevant in the current market. Many businesses are coming up and have a bulk of data to store. They are finding it difficult to store information manually e.g. a simple organization with over 300 employees and needs to store their records. Manual storage is proving to be hectic and inefficient. This paper provides a solution to the problem hence proving to be more relevant. References Boufares F. & Bennaceur H. (2004). Consistency problems in ER-schemas for database systems. Information Sciences  163(4) 263-274. dx.doi.org D. Storey V. & Barron T. (1999). Improving database design through the analysis of relationships. ACM Transactions On Database Systems  24(4) 453-486. http://dx.doi.org/10.1145/331983.331984 [...]

Order Description:

Much of the work on conceptual modeling of databases involves the use of an entity-relationship model in which binary relationships appear as associations between two entities. Relationships involving more than two entities are considered rare and, therefore, have not received adequate attention. Uniform treatment of relationships should ease the burden on designers by allowing them to extract more information from a real-world situation and express it properly in a conceptual design. Extensive research has been done in this realm and numerous design techniques have been developed over the years. Dey, Storey and Barron (1999) present their work and contributions to ER Modeling techniques to refine and improve the design of databases. For our first forum discussion, your task is to respond the following questions on the work proposed by the authors: 1. Outline the principal goals of the work presented by the authors. 2. What are the design implications identified in this study? 3. Discuss the characteristics of Functional, Partial Functional and General Relationships. 4. Discuss the characteristics of symmetric and asymmetric recursive relationships. 5. Outline the process of converting a conceptual model to a relational model. 6. How do you evaluate the overall quality of the paper? Your answers will be graded on the depth of understanding demonstrated in your discussion. Little credit will be given for simply repeating what the authors have said. I am interested in your critical analysis of the article. Cite all references used. This includes any information that you get from the Web. Do not forget to enclose any direct quotations in quotation marks. Follow the APA Citation and Reference Style. Click on the APA Style Reference Manual link on main course web page for examples. Please submit your responses in word or pdf as an attachment. Please refer to the attached document. Thanks.