Download ERD Examples PDF

TitleERD Examples
File Size318.9 KB
Total Pages8
Document Text Contents
Page 2

SUMMARY OF ER-DIAGRAM

NOTATION FOR ER SCHEMAS
Meaning

ENTITY TYPE

WEAK ENTITY TYPE

RELATIONSHIP TYPE

IDENTIFYING RELATIONSHIP TYPE

ATTRIBUTE

KEY ATTRIBUTE

MULTIALUED ATTRIBUTE

!OMPOSITE ATTRIBUTE

DERIED ATTRIBUTE

TOTAL PARTI!IPATION OF E" IN R 

!ARDINALITY RATIO 1#N FOR E 1#E" IN R 

STRU!TURAL !ONSTRAINT ($in, $a%) ON PARTI!IPATION

OF E IN R 

S&$'

E
1 R  E"

E
1 R  E"


($in,$a%)

E

 N

Page 3

ER DIAGRAM – Entity Types are:
EMPLOYEE DEPARTMENT PRO!ECT DEPENDENT

Page 7

ER DIAGRAM FOR A "AN#

DATA"ASE

 T+e Ben:a$in<!-$$ing. P-'i.+ing !$6an&, In*5 1CC?, E$a.i<Na4a/+e, F-na$en/a.  Da/a'a.e S&./e$., Se*n Ei/in

Similer Documents