StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Database Logic and Management questions Module 2 - Article Example

Cite this document
Summary
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,…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER92.4% of users find it useful
Database Logic and Management questions Module 2
Read Text Preview

Extract of sample "Database Logic and Management questions Module 2"

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.

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database Logic and Management questions Module 2 Article”, n.d.)
Database Logic and Management questions Module 2 Article. Retrieved from https://studentshare.org/information-technology/1614576-database-logic-and-management-questions-module-2
(Database Logic and Management Questions Module 2 Article)
Database Logic and Management Questions Module 2 Article. https://studentshare.org/information-technology/1614576-database-logic-and-management-questions-module-2.
“Database Logic and Management Questions Module 2 Article”, n.d. https://studentshare.org/information-technology/1614576-database-logic-and-management-questions-module-2.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database Logic and Management questions Module 2

Data Generation Qualitative Methods and Inclusive Education

This helps the designer to just code the business logic and makes the development of years in few days.... allows the businessman to create their own websites in few minutes by answering few questions and selecting few things in fewer amounts.... On other hand, part of business software are also available on compact discs and can be mould with respect to the business requirements by few selections and answering few questions.... They go and analyze the structure by themselves ask number of questions but get the answers of less than fifty percent of them....
12 Pages (3000 words) Essay

Information Systems Consoltancy skills

They are (1) Audit and Assurance, (2) Crisis management, (3) Human Resources, (4) Performance Improvements, (5) Tax and (6) Transactions.... Consultation skills require that a Consultant offers a solution to its client's problems both by way of devising systems that they have to follow and a software solution to record and monitor the activities according to the system. Mobility of the workforce has become a norm… Such a system and its development process have been discussed and the conclusion arrived at is that for such a development involvement of the Chief Information Officer They act as the catalyst between the consultants or the clients and the developers of the solution on the other....
12 Pages (3000 words) Essay

Business Ideas of SCT and DB

First question is:  Provide a summary of the business reasons why SCT required the ASRS warehouse and from SCT's perspective what do you consider their… In the year 1996 a contract was made among a famous beverage manufacturer, known as a Taiwan, (SCT) and a small Australian electrical engineering company, Dag-Brücken ASRS Pty Ltd, (DB), this agreement was related to the supply of an automated The answer of the question: Here it is observed that the Australian warehouse storage and retrieval of product is still predominantly a labor-intensive or semi-automatic process employing a multiplicity of materials handling equipment such as conveyors, elevators and fork lift trucks....
10 Pages (2500 words) Essay

Spring Framework with MVC Web Applications

The core features of Spring framework are able to support declarative transaction management, remote access to the application logic through web services, and other main options for data persisting.... Spring addresses the main problems of J2EE regarding web application development, Enterprise Java beans, Database access (JDBC, ORM), transaction management and Remote access....
4 Pages (1000 words) Essay

Information Systems in Business - Wal-Mart

(ii) Data warehousing for Wal- mart will enhance decision making in the company with regards to inventory management, price control and sales monitoring.... The data warehouse will provide data on a real time basis that will effectively aide in quick decision making on supply chain management and customer relationship management (Paul, 2001).... Items in this model can connect to any item in the database creating a network.... Most databases that are used on the Mini and Micro computers are normally based on either hierarchical or network database model....
5 Pages (1250 words) Coursework

How Does a Cookie Work

This assignment "How Does a Cookie Work" deals with the IT issues.... As the author puts it, most of the online sites use cookies to track the online behavior of a surfer.... Cookies are primarily text files which are very small and which are stored in the computer of the user when visiting a website....
16 Pages (4000 words) Assignment

Response to Request for a Proposal in Developing a Contemplative Media Vision Website

The author states that contemplative media vision was in need of a new website for communication.... To attain this goal, the project team began by carrying out a literature review and went on by following the four phases of the system development cycle, planning, analysis, design, and implementation....
9 Pages (2250 words) Case Study

Database Systems Administration - Aaliya Institute of Management and Technology

The fields that will feature in this module are; program_id, program_name, department_id 3.... The underlying purpose of this discussion "Database Systems Administration - Aaliya Institute of management and Technology" is to provide the reader with a more informed understanding of some of the key deliverables that will be in focus going automation processes.... hellip; Aaliya Institute of management and Technology (AIMT) is an institution that is entrusted with the responsibility of conducting courses and finally awarding Bachelor and Master's degree programs in varied disciplines....
12 Pages (3000 words) Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us