Changes between Version 3 and Version 4 of ERModel
- Timestamp:
- 01/15/26 14:11:10 (12 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ERModel
v3 v4 2 2 == '''Entity-Relationship Model v01''' 3 3 4 '''Diagram''' 4 5 == Diagram 5 6 6 7 [[Image(ERModel_v01.png)]] 7 8 8 9 9 '''Data Requirements''' 10 11 == Data Requirements 10 12 • University: This entity stores information about universities. We need it to know which faculties, professors, and students belong to which university. 11 13 … … 21 23 22 24 IsPrivate – boolean, required 25 26 ---- 23 27 24 28 • Faculty: Represents a faculty inside a university. It helps organize students, professors, and subjects within that faculty. Each faculty belongs to one university. … … 37 41 38 42 University_Id – number, required, foreign key to University 43 44 ---- 45 39 46 40 47 • Professor: This entity stores professors. Each professor works in a faculty and can teach subjects or advise students. … … 55 62 56 63 Faculty_Id – number, required, foreign key to Faculty 64 65 ---- 57 66 58 67 • Student: This entity stores students. Each student belongs to a faculty and can enroll in many subjects. They can also have a professor as their adviser. … … 76 85 Professor_Id – number, optional, foreign key to Professor 77 86 87 ---- 88 78 89 • Subject: This entity stores courses or subjects. Each subject belongs to a faculty and is taught by a professor. Students can enroll in subjects. 79 90 … … 93 104 94 105 Professor_Id – number, required, foreign key to Professor 106 107 ---- 95 108 96 109 • Student_Subject: This relationship shows which students are enrolled in which subjects. It also stores their grades, attendance, and enrollment status. … … 112 125 Subject_Id – number, required, foreign key to Subject 113 126 114 Entity-Relationship Model History 127 128 == Entity-Relationship Model History 115 129 116 130 v01: First version of the conceptual ER model including University, Faculty, Professor, Student, Subject, and Student_Subject relationship. Attributes, primary keys, and relationships defined.
