A relational model is beneficial to any organization that wishes to organize their date in a logistic manner. The relational model is comprised by three essential components: data structures, Integrity rule which ensures data protection, and data manipulation. Acme global will be in complete cohesiveness once this has been implemented. Some of the advantages that the relational model includes:
• Conceptual simplicity: A simple model that simplifies data requirement of the client.
• Design implementation. This model advocated structural and data independence. If changes are made to the data it will not affect the accessibility of data.
• Ad hoc capability of query implementation: This model provides a simple method to implement and manipulate data.
Purpose of the entity – relationship model
The entity – relationship model is a conceptual level model that facilitates database design. From the vantage point of acme global the ER model will provide great assistance in visual representations. They will be able to understand the required data of their clients. The ER model will also increase all productivity with the integration of relational database model. Overall your client’s solution and file design will be implemented in a safe and simple model.
Essential components of an ER Model
• Entity: Object that exists and that can be distinguished from other objects.
• Attributes: The properties related to a particular entity are known as attributes.
• Relationship: The term defines how two or more entities are related to each other. There are variations of relationships exist in ER model. o One to one relationship: Only one ins