Scribd
Upload
6 views2 pages

Understanding Entity-Relationship Models

The Entity–Relationship (ER) model provides a structured framework for designing databases through diagrams known as Entity Relationship Diagrams (ER Diagrams). Key components include entity sets, represented by rectangles, and relationship sets, represented by diamonds, along with various attributes depicted through different shapes. Weak entities, which depend on other entities for identification, are illustrated with double rectangles in the diagram.

Uploaded by

Nipun Somani
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views2 pages

Understanding Entity-Relationship Models

The Entity–Relationship (ER) model provides a structured framework for designing databases through diagrams known as Entity Relationship Diagrams (ER Diagrams). Key components include entity sets, represented by rectangles, and relationship sets, represented by diamonds, along with various attributes depicted through different shapes. Weak entities, which depend on other entities for identification, are illustrated with double rectangles in the diagram.

Uploaded by

Nipun Somani
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

An Entity–relationship model (ER model) describes the structure of a database with the help

of a diagram, which is known as Entity Relationship Diagram (ER Diagram). An ER model


is a design or blueprint of a database that can later be implemented as a database. The main
components of E-R model are: entity set and relationship set.
Rectangle: Represents Entity sets.////Ellipses: Attributes/////Diamonds: Relationship Set
Lines: They link attributes to Entity Sets and Entity sets to Relationship Set
Double Ellipses: Multivalued Attributes////Dashed Ellipses: Derived Attributes
Double Rectangles: Weak Entity Sets////Double Lines: Total participation of an entity in a relationship set

An entity is an object or component of data. An entity is represented as rectangle in an ER


diagram./////For example: In the following ER diagram we have two entities Student and College and these
two entities have many to one relationship as many students study in a single college. We will
read more about relationships later, for now focus on entities.
An entity that cannot be uniquely identified by its own attributes and relies on the relationship
with other entity is called weak entity. The weak entity is represented by a double rectangle.
For example – a bank account cannot be uniquely identified without knowing the bank to which the account
belongs, so bank account is a weak entity.

You might also like