Changes between Version 8 and Version 9 of P1


Ignore:
Timestamp:
06/15/26 12:56:04 (36 hours ago)
Author:
216009
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • P1

    v8 v9  
    99
    1010
    11 == Data Requirements
    12 • University: This entity stores information about universities. We need it to know which faculties, professors, and students belong to which university.
     11== Data Requirements ==
     12• University: This entity stores information about universities. We need it to know which faculties belong to which university.
    1313
    14   º Candidate keys: Id (primary key).
     14 º Candidate keys: Id (primary key).
    1515
    16   º Attributes:
     16 º Attributes:
    1717
    18    Id – number, required, unique
     18  Id – number, required, unique
    1919
    20    Name – text, required, max 255 characters
     20  Name – text, required, max 255 characters
    2121
    22    Location – text, optional, max 255 characters
     22  Location – text, optional, max 255 characters
    2323
    24    isprivate – boolean, required
     24  isprivate – boolean, required
    2525
    2626----
    … …  
    2828• Faculty: Represents a faculty inside a university. It helps organize students, professors, and subjects within that faculty. Each faculty belongs to one university.
    2929
    30   º Candidate keys: Id (primary key).
     30 º Candidate keys: Id (primary key).
    3131
    32   º Attributes:
     32 º Attributes:
    3333
    34    Id – number, required, unique
     34  Id – number, required, unique
    3535
    36    Name – text, required, max 255 characters
     36  Name – text, required, max 255 characters
    3737
    38    Location – text, optional, max 255 characters
     38  Location – text, optional, max 255 characters
    3939
    40    Study_field – text, optional, max 255 characters
     40  Study_field – text, optional, max 255 characters
    4141
    42    University_Id – number, required, foreign key to University
     42  University_Id – number, required, foreign key to University
     43
     44----
     45• Professor: This entity stores professors. Each professor works in a specific faculty, can guide students through advice sessions, and is assigned to teach subjects inside student enrollments.
     46
     47 º Candidate keys: Id (primary key).
     48
     49 º Attributes:
     50
     51  Id – number, required, unique
     52
     53  Name – text, required, max 255 characters
     54
     55  Surname – text, optional, max 255 characters
     56
     57  Age – number, optional, 25–100
     58
     59  Faculty_Id – number, required, foreign key to Faculty
    4360
    4461----
    4562
     63• Student: This entity stores students. Each student belongs to a faculty, can enroll in subjects, and can interact with professors during advice sessions.
    4664
    47 • Professor: This entity stores professors. Each professor works in a faculty and can teach subjects or advise students.
     65 º Candidate keys: Id (primary key).
    4866
    49    º Candidate keys: Id (primary key)
     67 º Attributes:
    5068
    51    º Attributes:
     69  Id – number, required, unique
    5270
    53     Id – number, required, unique
     71  Name – text, required, max 255 characters
    5472
    55     Name – text, required, max 255 characters
     73  Surname – text, optional, max 255 characters
    5674
    57     Surname – text, optional, max 255 characters
     75  Location – text, optional, max 255 characters
    5876
    59     Age – number, optional, 25–100
     77  Index – number, required, unique
    6078
    61     Faculty_Id – number, required, foreign key to Faculty
     79  Faculty_Id – number, required, foreign key to Faculty
    6280
    6381----
    6482
    65 • 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.
     83• Subject: This entity stores courses or subjects offered by a faculty. Students can enroll in these subjects.
    6684
    67    º Candidate keys: Id (primary key).
     85 º Candidate keys: Id (primary key).
    6886
    69    º Attributes:
     87 º Attributes:
    7088
    71     Id – number, required, unique
     89  Id – number, required, unique
    7290
    73     Name – text, required, max 255 characters
     91  Name – text, required, max 255 characters
    7492
    75     Surname – text, optional, max 255 characters
     93  Semester – text, optional, e.g., "Fall", "Spring"
    7694
    77     Location – text, optional, max 255 characters
     95  Credits – number, required, 1–15
    7896
    79     Index – number, required, unique
    80 
    81     Faculty_Id – number, required, foreign key to Faculty
    82 
    83     Professor_Id – number, optional, foreign key to Professor
     97  Faculty_Id – number, required, foreign key to Faculty
    8498
    8599----
    86100
    87 • Subject: This entity stores courses or subjects. Each subject belongs to a faculty and is taught by a professor. Students can enroll in subjects.
     101• Student_Subject: This entity represents a specific student enrollment in a subject. It tracks grades, attendance, and status. It also links the specific professor who teaches this instance of the course.
    88102
    89   º Candidate keys: Id (primary key)
     103 º Candidate keys: ssId (primary key).
    90104
    91   º Attributes:
     105 º Attributes:
    92106
    93    Id – number, required, unique
     107  ssId – number, required, unique
    94108
    95    Name – text, required, max 255 characters
     109  Final_Grade – number, optional, 6–10
    96110
    97    Semester – text, optional, e.g., "Fall", "Spring"
     111  Status – text, optional, e.g., "Enrolled", "Passed", "Failed"
    98112
    99    Credits – number, required, 1–15
     113  Enrollment_Date – date, required
    100114
    101    Faculty_Id – number, required, foreign key to Faculty
     115  Absence_Count – number, optional, 0–100
    102116
    103    Professor_Id – number, required, foreign key to Professor
     117  Student_Id – number, required, foreign key to Student
    104118
    105 ----
     119  Subject_Id – number, required, foreign key to Subject
    106120
    107 • Student_Subject: This entity shows which students are enrolled in which subjects. It also stores their grades, attendance, and enrollment status.
    108 
    109    º Candidate keys: ssId (primary key)
    110 
    111    º Attributes:
    112 
    113     Final_Grade – number, optional, 6–10 or pass/fail
    114 
    115     Status – text, optional, e.g., "Enrolled", "Passed", "Failed"
    116 
    117     Enrollment_Date – date, required
    118 
    119     Absence_Count – number, optional, 0–100
    120 
    121     Student_Id – number, required, foreign key to Student
    122 
    123     Subject_Id – number, required, foreign key to Subject
    124 
     121  Professor_Id – number, required, foreign key to Professor
    125122
    126123== Entity-Relationship Model History