Why is so important to utilize er models when designing dbms

Assignment Help Other Subject
Reference no: EM132975920

Question 1: Explain why the entity relationship (ER) model is useful. How has it helped to produce a more structured relational database design environment?

Peer Response:

Based on the background readings, Entity Relationship (ER) Diagrams is a graphical representation, a tool used to describe the data requirements and assumptions in the system from a top-down perspective (Wang, 2017). It is a high-level logical and structural model that defines the relationship among different entities of a Database Management System (DBMS).

So, why is it so important to utilize ER models when designing a DBMS? As you may know, many mistakes occurred during a database design. Creating a great data modeling can be challenging and overwhelming when you have too many data to deal with. Database designers can easily fall behind their design timeline when they cannot identify clearly all the data elements necessary to design efficiently the database.

Therefore, ER Diagrams (ERD) provide a clear representation of all the different entities and relations to design the DBMS. ERD helps the database administrator (DBA) to identify all the entities and attributes necessary to build their database by defining the appropriate and logical correlation between those entities for an efficient DBMS.

ERD should be the first major step of a database design as it provide the DBA a graphic representation of data needed to build the database, before it gets converted into a set of tables at relational database.

Reference no: EM132975920

Questions Cloud

What do think about the chaos study definition : Do you think there are better definitions of success besides meeting scope, time, and cost goals? What do think about the CHAOS study definition
Why does knowing difference help avoid common mistakes : As a business professional, why does the following difference matter to you? Why does knowing the difference help you avoid some common mistakes?
Importance of the marketing mix : Do you agree that all of your marketing activities must be aligned to support your marketing objectives? But the importance of the marketing mix extends beyond
Discuss the impact of forces to organic herbal tea : Identify external environment forces that could influence the marketing strategies and briefly discuss the impact of these forces to organic herbal tea you are
Why is so important to utilize er models when designing dbms : Why is so important to utilize ER models when designing a DBMS? Based on the background readings, Entity Relationship (ER) Diagrams is graphical representation.
Why the entity relationship model is useful : Why the entity relationship (ER) model is useful. How has it helped to produce a more structured relational database design environment?
Considerations relating to planning a property inspection : What are some of the key considerations relating to planning a property inspection?
Define blockchain : How enterprise blockchain enriches the definition of blockchain. You are required to cite assigned readings in your paper. You may also cite external sources
What is the set-off requirements : What is the Set-off requirements, notice and effects

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd