How does E-R model help in Database design?
How does E-R model help in Database design? Answer: The E-R (Entity-Relationship) model is a widely used approach to designing databases. It helps in database design by providing a graphical representation of the database schema, which allows designers to visualize the relationships between entities and attributes in a database. The E-R model helps in database design in the following ways: Identifying entities and relationships : The E-R model allows designers to identify the entities in a database and the relationships between them. Entities are objects or concepts that exist in the real world, and relationships are the associations between entities. Defining attributes : The E-R model allows designers to define attributes for each entity. Attributes are characteristics of an entity that help to describe it. Normalizing data : The E-R model helps to normalize data by identifying duplicate data and removing it from the database. Normalization ensures that data is organized effici...