Changes between Version 5 and Version 6 of P1

Timestamp:

03/03/26 11:47:00 (3 weeks ago)

Author:

216009

Comment:

--

P1

@@ -107 +107 @@
 • Student_Subject: This relationship shows which students are enrolled in which subjects. It also stores their grades, attendance, and enrollment status.
 
-   º Candidate keys: (Student_Id, Subject_Id) (composite primary key)
+   º Candidate keys: ssId (primary key)
 
    º Attributes:
 
-    Final_Grade – number, optional, 5–10 or pass/fail
+    Final_Grade – number, optional, 6–10 or pass/fail
 
-    Status – text, optional, e.g., "Enrolled", "Completed", "Dropped"
+    Status – text, optional, e.g., "Enrolled", "Passed", "Failed"
 
-    Enrollment_Date – date, optional
+    Enrollment_Date – date, required
 
     Absence_Count – number, optional, 0–100