Symbol of e r diagram presentation

418 views 12 slides Apr 12, 2020
Slide 1
Slide 1 of 12
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9
Slide 10
10
Slide 11
11
Slide 12
12

About This Presentation

Its all about E-R diagram. Very clear discuss all about information entity relationship.


Slide Content

Er-Model Discussion Ashiqur Rahaman Anik : 181-15-11012 Mehedi Hasan: 181-15-10826 Khadija Akter : 181-15-10924 Nusrat Jahan Nisha : 181-15-11342

Introduction to ER Diagram 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.

What is an Entity Relationship Diagram (ER Diagram)? An ER diagram shows the relationship among entity sets. An entity set is a group of similar entities and these entities can have attributes. ER diagram shows the complete logical structure of a database.

A simple ER Diagram

Symbol of E-R Diagram Strong entity Weak entity Associative entity Entity, Entity Type, Entity Set:

Symbol of E-R Diagram Attributes: Key Attribute Composite Attribute Multivalued Attribute Derived Attribute 

Symbol of E-R Diagram Degree of a relationship set: Unary Relationship   Binary Relationship n- ary Relationship 

Keys of Er -Diagram Types of keys in DB: 1.Primary key 2.Candidate key 3.Alternate key 4.super key 5.Foreign key

Keys of Er -Diagram

Keys of Er -Diagram

Example of Er -Diagram