Changes between Version 11 and Version 12 of P1

Timestamp:

06/16/26 18:20:56 (20 hours ago)

Author:

216009

Comment:

--

P1

@@ -121 +121 @@
   Professor_Id – number, required, foreign key to Professor
 
+----
+
+• Advice: This ternary associative relationship entity tracks the history of formal advice and mentorship sessions between professors and students.
+
+ º Candidate keys: Composite key made of (student_id, professor_id, start_date).
+
+ º Attributes:
+
+  student_id – number, required, foreign key to Student
+
+  professor_id – number, required, foreign key to Professor
+
+  start_date – date, required, unique part of the key
+
+  end_date – date, optional
+
+  status – text, optional, e.g., "Active", "Completed"
+
+----
+
+• Professor_Subject: This bridge entity materializes the Many-to-Many relationship between professors and the subjects they are certified or eligible to teach.
+
+ º Candidate keys: Composite key made of (subject_id, professor_id).
+
+ º Attributes:
+
+  subject_id – number, required, foreign key to Subject 
+
+  professor_id – number, required, foreign key to Professor
+
 == Entity-Relationship Model History
 
-v01: First version of the conceptual ER model including University, Faculty, Professor, Student, Subject, and Student_Subject relationship. Attributes, primary keys, and relationships defined.
+v1: First version of the conceptual ER model including University, Faculty, Professor, Student, Subject, Student_Subject weak entity, advice mentorship tracking, and professor_subject competency mapping. Attributes, candidate keys, nullability constraints, and precise entity relationships defined.