Database Logic and Management questions Module 2 - Article Example

DATABASE LOGIC AND MANAGEMENT QUESTIONS MODULE 2 Database Logic and Management questions Module 2 Affiliation What are the benefits or disadvantages of ER diagrams? Why bother with logical design and not just create tables and columns (physical design) directly?An E-R (Entity-Relationship) Model is a graphical representation of entities and their relationships. One of the basic purposes of an E-R diagram is to clarify the system requirements particularly in case of a system which involves implementation of a database (Hoffer, Prescott, & McFadden, 2007; Whitten, Bentley, & Dittman, 2000).

In this scenario, (Craven, 2001) discuss some of the major advantages and disadvantages of E-R modeling which are outlined below: AdvantagesOne of the major advantages of E-R Diagram is that it simplifies the conceptual structure of a system It offers a graphical representation of a system. It clearly shows how different entities are connected to each other.It can help improve communication as it is easy to understand.Its integration with the relational database model is straightforward.DisadvantagesIt takes into consideration only some of the well-known constraints.

It can be used to represent only limited relationships.It does not show data manipulation It can cause loss of information as all the information cannot be integrated into a diagram.Without a doubt, logical design is the most manual and time consuming portion of the system development process. However, we still need a logical design for the reason that building a physical design without logical design is similar to building a house without blueprints. In fact, the basic purpose of building a logical database design is to ensure that all the entities and their possible relationships required by the database are entirely and exactly identified and described.

In view of the fact that logical database design is built using easy to understand symbol and language, hence it can be easily examined and validated as accurate by the end-users. As discussed above, this logical database design works as a guide that is to be followed by the database developers to use as a "blueprint" for developing the physical database model. In this scenario, the information provided in the logical database model is utilized to describe the relational tables, entities, stored procedures, primary and foreign keys, and triggers (Liberty University, 2013).

How does understanding the logic of a database assist clinical resources? How does being involved with workflow development assist IT resources?In the past few years, the use of information systems in the healthcare industry has raised to a huge extent. In this scenario, organizing and administrating healthcare resources has turned out to be a challenge in opposition to time, for the reason that having control over the expansion of the disease is now as significant as treating it. Additionally, computerization and automation of clinical firms through information systems containing large databases offers a large number of benefits.

In addition, in many researches authors have emphasized on the need to be aware of the situational aspects that force individuals’ comfort with receiving and distributing healthcare information in an electronic arrangement. In this scenario, one suggestion is to investigate severer rule of medical information, for instance, to make sure that stakeholders evidently recognize who they are, for what reason they will collect and distribute the data, what kind of data they will take and even to pose any limitations and restrictions on the amount of time that the stakeholder will be authorized to access.

In order to have a proper control over information systems and database the staff must be trained and they should have proper knowledge of database and logic. Without understanding these concepts, they cannot control these processes. Moreover, they need to collaborate and cooperate with their IT department in order to understand these processes. (Fichman, Kohli, & Krishnan, 2011; Harrison, 2006).ReferencesCraven, T. (2001, July 05). LIS 558 - Entity-relationship model advantages and disadvantages.

Retrieved February 09, 2013, from http://publish.uwo.ca/~craven/558/558era.htmFichman, R. G., Kohli, R., & Krishnan, R. (2011). The Role of Information Systems in Healthcare: Current Research and Future Trends. Information Systems Research, Volume 22 Issue 3, pp. 419-428.Harrison, J. P. (2006). The Role of Clinical Information Systems in Health Care Quality Improvement. Health Care Manager, Volume 25 Issue 3, pp. 206-212.Hoffer, J. A., Prescott, M. B., & McFadden, F. R. (2007). Modern Database Management, Eighth Edition.

Pearson Education, Inc.Liberty University. (2013). Data Modeling. Retrieved February 08, 2013, from http://www.liberty.edu/media/1414/%5B6330%5DERDDataModeling.pdfWhitten, J. L., Bentley, L. D., & Dittman, K. C. (2000). Systems Analysis and Design Methods 5th Edition. New York: Irwin/McGraw-Hill.