Entity Relationship Modeling
- As explained throughout this course, entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. Using this knowledge, explain the key reasons why entity relationship modeling is important, and determine at least (1) way in which it impacts the overall development of the database.
- Analyze the key ways that entity relationship modeling helps database developers overcome potential design challenges and conflicting goals.
- For the database that you described in the Week 1 and Week 2 discussions, determine the major / minor challenges that might exist when you are creating an entity relationship diagram (ERD) for the business function / operation.
Entity relation modeling is important as it provide a perfect communication tool that is in most cases used to combine the business requirement and give a perfect direction to the system design to the software development in respect to business requirement. It also helps in saving time during the data gathering process as the database is being designed. It also helps in prototyping, capturing all the database semantics…