-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathInfoErModel.txt
More file actions
13 lines (7 loc) · 890 Bytes
/
Copy pathInfoErModel.txt
File metadata and controls
13 lines (7 loc) · 890 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
Er diagram : doesnt have any important info , so we dont need it
1 ,Er diagram version1 : Er model for employee only. Employee entity is didiveded into twoo internal Employee and external Employee.
2,Er diagram version 2: a person tables is created as mister haralld recommanded. and the sudent table and Employee table are created with thier relation ship to employee
3, Er diagram version 3: All the tables are connected in Er model , tables are : person, student, employee , internal and external employees.
4 Er diagram version 4,: Additional table is created for the ternary relation ship between student , grade and registration,
5, Er diagram version 5, End of the Er diagram, additional table is introduced between lesson and location coz the relation ship was many to many.
6,Er diagram version 5:( logical model) all the primary keys and their relation ship is identified.