Question

Explain how the limitations of ERD would influence your choice of a database design model.

Explain how the limitations of ERD would influence your choice of a database design model.

Homework Answers

Answer #1

The full form of ERD is Entity relationship diagram it is one of the most useful features used in designing a databse however there are certain limitations of ERD which influence our choice of database design model these limitations are:

ERD only shows us the relational structures between different entities.

ERD cannot be made for unstructured data like the data which is not structured properly like it is not divided into different rows or columns and the data is not labelled properly.

ERD cannot be integrated with an existing database due to difference in architecture.

ALL the above mentioned limitations of ERD influnce us or compels us to choose a database design model which have structured data and in which entity relationship is clearly visible..

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
In relation to data modeling and ERD design, explain comprehensively what is meant by the term...
In relation to data modeling and ERD design, explain comprehensively what is meant by the term cardinality (1 mark). In relation to this same issue, how do we represent in our ERD the minimum cardinality? (1 mark)   How do we represent the maximum cardinality? (1 mark). Consider the two relationships: “a student can enrol in either 1, 2, 3, or 4 courses each semester AND a course can have student enrolments from zero to 500”. How would we represent the...
Task: The understanding of database analysis and design are necessary to develop a database management system....
Task: The understanding of database analysis and design are necessary to develop a database management system. Choose a real-world example to illustrate the effectiveness of database systems in the business world? In order to do that, you are asked to design and implement a database system for any business of your choice. By developing this database system, you should be able to achieve better business processes and operations with goal to enhance how the average person views and interacts with...
Jefferson Dance Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD...
Jefferson Dance Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular...
how the business model would affect the design of a new AIS. how the business model...
how the business model would affect the design of a new AIS. how the business model would affect the design of a new AIS.
Suppose you are in charge of your company database. Explain the concrete steps you would take...
Suppose you are in charge of your company database. Explain the concrete steps you would take if there is a power-failure during the entry of daily transactions into your database. How can you assure the integrity of the database after this event?
Your firm wants to move from a relational database model to the REA data model. Explain...
Your firm wants to move from a relational database model to the REA data model. Explain to your senior management the risks and rewards of such of a move. Be sure to provide specific examples to support your response. As we know, the REA data model is an emerging technology change. Make five recommendations for creating useful entity-relationship (E-R) diagrams. Rank them in the level of importance, and then justify your ranking.
- Develop an entity-relationship model. (ERD) Assuming that you are working for the public housing agency...
- Develop an entity-relationship model. (ERD) Assuming that you are working for the public housing agency of the city, and you have been charged with keeping track of who is living in the agency's developments over time. To help you in this task, you have decided to use a relational database for your record keeping. Your task is to design a database that allows you to capture the facts described below: • The city has three public housing developments. You...
how the business model would affect the design of a new AIS.
how the business model would affect the design of a new AIS.
Draw the Crow’s Foot database notation entity-relationship diagrams (ERD) to represent the databases, based on the...
Draw the Crow’s Foot database notation entity-relationship diagrams (ERD) to represent the databases, based on the three narratives below. Use Lucid Chart or another ERD diagramming tool to create your diagram. You do not need to create the databases, but to design it using applicable business rules according to your judgment. Submit a PDF of the Entity Relationship Diagram for each database. Remember to identify in your diagrams: All the main entities and the main attributes for each entity The...
How does the Bohr model address the limitations of Rutherford's model? Support the answer with a...
How does the Bohr model address the limitations of Rutherford's model? Support the answer with a diagram
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT