Improving Database Design Through Relationship Modeling

Entity-Relationship Model
Name:
Institution:
Course:
Date:
There are quite a number of aspects that can be highlighted when considering the entity relationship modelling in reference to developing databases design (Zaïane, 1995). This helps with making the database more elaborate and easier to use, with a lot more information and connection between the data. One of the aspects to consider is the fact that, the model tends to improve the relationships between the data in question (Shiflet, 2002). This is relative to the fact that, one is able to establish relationships that go beyond the binary connections. Most of the data will have a binary association, however, when using the model, it is easier to create more than two relationships with two entities. This therefore creates an entire dimension that can be considered, when evaluating the relationship between different entities and thus better understanding of the data and the research aspects on the same (Thakur, 2016).
Binary connection


ER Relationships




From the ER diagram it is easy to see that there exists more relations between a customer and their account at the bank. This way, researchers are able to establish the various ways the customer interacts with their account and thus the bank. At the same time, it is much easier to see the bigger picture when it comes to the products offered by the bank relative to the needs of the customer.
A researcher is able to identify ternary and other higher degree relationships. This further helps a researcher to extract more information from a real world situation and is able to represent it in a rather proper conceptual design (Moore, 2016). Using the diagrams, the researcher is able to better understand the va...