0% found this document useful (0 votes)
38 views3 pages

ERD for Student Management System

The document describes an entity relationship diagram with entities like instructor, department, student and subject. It details the attributes of each entity and relationships like teaches, learns, provides between the entities.

Uploaded by

Waseem Akram
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
38 views3 pages

ERD for Student Management System

The document describes an entity relationship diagram with entities like instructor, department, student and subject. It details the attributes of each entity and relationships like teaches, learns, provides between the entities.

Uploaded by

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

{"version":2,"www":"erdplus.

com","shapes":[{"type":"Entity","details":
{"name":"INSTRUCTOR","type":"regular","x":485,"y":243.3333282470703,"id":2}},
{"type":"Entity","details":
{"name":"DEPARTMENT","type":"regular","x":485,"y":525.3333282470703,"id":3}},
{"type":"Entity","details":
{"name":"STUDENT","type":"regular","x":943,"y":244.3333282470703,"id":4}},
{"type":"Entity","details":
{"name":"SUBJECT","type":"regular","x":963,"y":510.3333282470703,"id":5}},
{"type":"Attribute","details":
{"name":"usn","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposi
te":false,"isUnique":false,"x":827,"y":168.3333282470703,"id":7}},
{"type":"Attribute","details":
{"name":"id","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposit
e":false,"isUnique":true,"x":272,"y":212.3333282470703,"id":8}},
{"type":"Attribute","details":
{"name":"name","isDerived":false,"isMultivalued":false,"isOptional":false,"isCompos
ite":false,"isUnique":false,"x":293,"y":159.3333282470703,"id":9}},
{"type":"Attribute","details":
{"name":"email","isDerived":false,"isMultivalued":false,"isOptional":false,"isCompo
site":false,"isUnique":false,"x":354,"y":114.33332824707031,"id":10}},
{"type":"Attribute","details":
{"name":"phone","isDerived":false,"isMultivalued":false,"isOptional":false,"isCompo
site":false,"isUnique":false,"x":445,"y":82.33332824707031,"id":11}},
{"type":"Attribute","details":
{"name":"address","isDerived":false,"isMultivalued":false,"isOptional":false,"isCom
posite":false,"isUnique":false,"x":545,"y":63.33332824707031,"id":12}},
{"type":"Attribute","details":
{"name":"dob","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposi
te":false,"isUnique":false,"x":681,"y":118.33332824707031,"id":13}},
{"type":"Attribute","details":
{"name":"gender","isDerived":false,"isMultivalued":false,"isOptional":false,"isComp
osite":false,"isUnique":false,"x":650,"y":66.33332824707031,"id":14}},
{"type":"Attribute","details":
{"name":"name","isDerived":false,"isMultivalued":false,"isOptional":false,"isCompos
ite":false,"isUnique":false,"x":878,"y":124.33332824707031,"id":15}},
{"type":"Attribute","details":
{"name":"email","isDerived":false,"isMultivalued":false,"isOptional":false,"isCompo
site":false,"isUnique":false,"x":938,"y":84.33332824707031,"id":16}},
{"type":"Attribute","details":
{"name":"phone","isDerived":false,"isMultivalued":false,"isOptional":false,"isCompo
site":false,"isUnique":false,"x":1010,"y":48.33332824707031,"id":17}},
{"type":"Attribute","details":
{"name":"address","isDerived":false,"isMultivalued":false,"isOptional":false,"isCom
posite":false,"isUnique":false,"x":1110,"y":65.33332824707031,"id":18}},
{"type":"Attribute","details":
{"name":"gender","isDerived":false,"isMultivalued":false,"isOptional":false,"isComp
osite":false,"isUnique":false,"x":1172,"y":107.33332824707031,"id":19}},
{"type":"Attribute","details":
{"name":"dob","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposi
te":false,"isUnique":false,"x":1219,"y":159.3333282470703,"id":20}},
{"type":"Attribute","details":
{"name":"Sub_id","isDerived":false,"isMultivalued":false,"isOptional":false,"isComp
osite":false,"isUnique":true,"x":1138,"y":486.6666669845581,"id":35}},
{"type":"Attribute","details":
{"name":"Subject","isDerived":false,"isMultivalued":false,"isOptional":false,"isCom
posite":false,"isUnique":false,"x":1141,"y":544.6666669845581,"id":36}},
{"type":"Attribute","details":
{"name":"Department_id","isDerived":false,"isMultivalued":false,"isOptional":false,
"isComposite":false,"isUnique":true,"x":367,"y":599.6666669845581,"id":39}},
{"type":"Attribute","details":
{"name":"Department_name","isDerived":false,"isMultivalued":false,"isOptional":fals
e,"isComposite":false,"isUnique":false,"x":507,"y":616.6666669845581,"id":40}},
{"type":"Relationship","details":
{"name":"LEARNS","isIdentifying":false,"x":944,"y":379.3333339691162,"slots":
[{"slotIndex":0,"minimum":"","maximum":"","participation":"unspecified","cardinalit
y":"many","role":"","entityId":4},
{"slotIndex":1,"minimum":"","maximum":"","participation":"unspecified","cardinality
":"many","role":"","entityId":5}],"id":43}},{"type":"Relationship","details":
{"name":"TEACHES","isIdentifying":false,"x":682,"y":253.3333282470703,"slots":
[{"slotIndex":0,"minimum":"","maximum":"","participation":"unspecified","cardinalit
y":"many","role":"","entityId":2},
{"slotIndex":1,"minimum":"","maximum":"","participation":"unspecified","cardinality
":"many","role":"","entityId":4}],"id":46}},{"type":"Relationship","details":
{"name":"PROVIDES","isIdentifying":false,"x":704,"y":513.3333282470703,"slots":
[{"slotIndex":0,"minimum":"","maximum":"","participation":"unspecified","cardinalit
y":"one","role":"","entityId":3},
{"slotIndex":1,"minimum":"","maximum":"","participation":"unspecified","cardinality
":"many","role":"","entityId":5}],"id":49}},{"type":"Relationship","details":
{"name":"INS_DEPT","isIdentifying":false,"x":496,"y":377.3333282470703,"slots":
[{"slotIndex":0,"minimum":"","maximum":"","participation":"unspecified","cardinalit
y":"many","role":"","entityId":2},
{"slotIndex":1,"minimum":"","maximum":"","participation":"unspecified","cardinality
":"one","role":"","entityId":3}],"id":52}},{"type":"Relationship","details":
{"name":"STU_DEPT","isIdentifying":false,"x":709,"y":367.3333282470703,"slots":
[{"slotIndex":0,"minimum":"","maximum":"","participation":"unspecified","cardinalit
y":"many","role":"","entityId":4},
{"slotIndex":1,"minimum":"","maximum":"","participation":"unspecified","cardinality
":"one","role":"","entityId":3}],"id":55}},{"type":"Relationship","details":
{"name":"TEACHES","isIdentifying":false,"x":310,"y":696.3333282470703,"slots":
[{"slotIndex":0,"minimum":"","maximum":"","participation":"unspecified","cardinalit
y":"many","role":"","entityId":2},
{"slotIndex":1,"minimum":"","maximum":"","participation":"unspecified","cardinality
":"many","role":"","entityId":5}],"id":58}}],"connectors":
[{"type":"Connector","details":{"id":21},"source":8,"destination":2},
{"type":"Connector","details":{"id":22},"source":9,"destination":2},
{"type":"Connector","details":{"id":23},"source":10,"destination":2},
{"type":"Connector","details":{"id":24},"source":11,"destination":2},
{"type":"Connector","details":{"id":25},"source":12,"destination":2},
{"type":"Connector","details":{"id":26},"source":14,"destination":2},
{"type":"Connector","details":{"id":27},"source":13,"destination":2},
{"type":"Connector","details":{"id":28},"source":7,"destination":4},
{"type":"Connector","details":{"id":29},"source":15,"destination":4},
{"type":"Connector","details":{"id":30},"source":16,"destination":4},
{"type":"Connector","details":{"id":31},"source":17,"destination":4},
{"type":"Connector","details":{"id":32},"source":18,"destination":4},
{"type":"Connector","details":{"id":33},"source":19,"destination":4},
{"type":"Connector","details":{"id":34},"source":20,"destination":4},
{"type":"Connector","details":{"id":37},"source":35,"destination":5},
{"type":"Connector","details":{"id":38},"source":36,"destination":5},
{"type":"Connector","details":{"id":41},"source":39,"destination":3},
{"type":"Connector","details":{"id":42},"source":40,"destination":3},
{"type":"RelationshipConnector","details":
{"slotIndex":0,"id":44},"source":4,"destination":43},
{"type":"RelationshipConnector","details":
{"slotIndex":1,"id":45},"source":5,"destination":43},
{"type":"RelationshipConnector","details":
{"slotIndex":0,"id":47},"source":2,"destination":46},
{"type":"RelationshipConnector","details":
{"slotIndex":1,"id":48},"source":4,"destination":46},
{"type":"RelationshipConnector","details":
{"slotIndex":0,"id":50},"source":3,"destination":49},
{"type":"RelationshipConnector","details":
{"slotIndex":1,"id":51},"source":5,"destination":49},
{"type":"RelationshipConnector","details":
{"slotIndex":0,"id":53},"source":2,"destination":52},
{"type":"RelationshipConnector","details":
{"slotIndex":1,"id":54},"source":3,"destination":52},
{"type":"RelationshipConnector","details":
{"slotIndex":0,"id":56},"source":4,"destination":55},
{"type":"RelationshipConnector","details":
{"slotIndex":1,"id":57},"source":3,"destination":55},
{"type":"RelationshipConnector","details":
{"slotIndex":0,"id":59},"source":2,"destination":58},
{"type":"RelationshipConnector","details":
{"slotIndex":1,"id":60},"source":5,"destination":58}],"width":2000,"height":1000}

You might also like