Business Rules in Data Modeling
"Business Rules in Data Modeling" Please respond to the following:
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 one (1) example of a business function / operation. Explain the business function / operation in the context of business data models.
Identify the business rules associated with your selected business function / operation. 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 function or operation would be affected if these business rules were not adhered to in the development of the database.
"Relational Database Model" Please respond to the following:
In the Week 1 discussion, you identified one (1) example of a business function or operation and the business rules associated with that business function / operation. You will build upon that discussion as you describe the main entities or objects of that business function / operation in question, as well as the manner in which they relate to one another.
Describe the main entities or objects of the business function / operation. Specify the attribute that would be the primary key for each entity, 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 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.
Week 3 Discussion
"Entity Relationship Modeling" Please respond to the following:
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.
Week 4 Discussion
"Normalization and Redundancy" Please respond to the following:
Suggest one (1) of the problems that normalization seeks to solve within a database. Describe one (1) example of your suggested problem, and explain the overall benefit that normalization would provide. (Note: Your example can be hypothetical.)