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.

Here are the two previous discussions from our course I've completed below:

Week 1:

Business Rules in Data Modeling

Per the text, when databases are developed, they are modeled around business rules, so they accurately support a

business function or operation.

Based on your experiences, identify what information you would want to store about a student at a university.

Identify the business rules associated with information you would want to store about a student at a university. Explain the manner in which such business rules would impact the design of a database.

Explain at least one (1) way in which the business rule would be affected if these business rules were not adhered to in the development of the database.

Week 2:

Relational Database Model

In the Week 1 discussion, you identified one (1) example of a business function or operation and the business rules associated with information you would want to store about a student at a university. You will build upon that discussion as you describe the main entities or objects of the university business function/operation, as well as the manner in which they relate to one another.

Describe the main entities or objects of the university business function/operation. Specify the attribute that would be the primary key for each entity,B and provide a rationale for why you selected such an attribute.

Determine whether the relationships between each of the chosen entities are one-to-one, one-to-many, or many-to-many relationships. Justify your response.

Explain the key manner in which the university business function/operation and the business rules associated with that business function/operation support the relationships mentioned above. Also, explain the fundamental ways in which the relationships could change, based on the interpretation of the given business rules.