1 / 6

ER Model Entity Relationship

ER model stands for Entity-Relationship Model. ER modelling is a high stage conceptual data model promote to simplify database design. A conceptual data model is a set of concepts that define the mechanism of a database and the related retrieval and update transactions of the database. It is independent of any specific database management system (DBMS) and hardware platform.

ducathub
Download Presentation

ER Model Entity Relationship

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. WELCOME TO DUCAT INDIA ER Model: Entity Relationship Diagram (ERD) 70-70-90-50-90 info@ducatindia.com

  2. What is the ER Model? • ER model stands for Entity-Relationship Model. ER modelling is a high stage conceptual data model promote to simplify database design. A conceptual data model is a set of concepts that define the mechanism of a database and the related retrieval and update transactions of the database. It is independent of any specific database management system (DBMS) and hardware platform. • The ER model is also represented as a logical representation of records for a company. It was developed to simplify database design using allowing specification of a company schema, which defines the overall logical architecture of a database. It is a top-down method for database design.

  3. The overall logical architecture of a database can be represented graphically by an Entity-Relationship Diagram as follows:

  4. History of ER Models • ER diagram is a visual device that is helpful to describe the ER model. It was suggested by Peter Chen in 1971 to construct a uniform meeting which may be utilized for a relational database and network. ER Model is a powerful and standard technique of communication among various designers, programmers, and end-users who generally tend to view records and its use in different methods. It is a non-technical method, which is loose from ambiguities and provides a standard and a logical process of visualizing the record. Features of ER Model • This model is widely used to create the initial layout of the database. • This model supports a collection of fundamental ideas that can be implemented in a database framework. • It represents records as a set of entities, attributes, and relationships. • It supports the graphical or conceptual file of the database design.

  5. What is an Entity-Relationship Diagram? An ERD or Entity-Relationship Diagram is the graphical description of objects (entities) and the relationship between those entities in the database. In other words, the ER diagram defines the logical architecture of the database. It contains many specific symbols, and its definitions create this structure unique. In the figure, an ER diagram display the relationship between the entity sets EMPLOYEE and POSITION. The relationship set is known as DUTY_ALLOCATION, and its attributes are Date and Shift.

  6. THANK YOU Read More On (https://tutorials.ducatindia.com/dbms/er-model-entity-relationship-diagram-erd/) 70-70-90-50-90 info@ducatindia.com

More Related