== UC2001 – Assign Grade to Student ==

'''Initiating actor:''' Professor
'''Other actors:''' None

'''Description:'''
A professor records the final grade for a student enrolled in a subject under their supervision.

'''Scenario:'''
1. Professor logs in and selects “Enter Grades.”
2. System shows students and subjects that this specific professor teaches (вклучувајќи го и Ss_Id):
{{{
SELECT ss.Ss_Id, sub.Id AS Subject_Id, sub.Name AS Subject_Name, st.Id AS Student_Id, st.Name, st.Surname
FROM Student_Subject ss
JOIN Subject sub ON ss.Subject_Id = sub.Id
JOIN Student st ON ss.Student_Id = st.Id
WHERE ss.Professor_Id = :professor_id;
}}}
3. Professor selects a student/subject entry and enters the final grade.
4. System updates the database with the grade and changes status to 'Passed' (усогласено со композитниот клуч и ENUM):
{{{
UPDATE Student_Subject
SET Final_Grade = :grade, Status = 'Passed'
WHERE Student_Id = :student_id AND Subject_Id = :subject_id AND Ss_Id = :ss_id;
}}}
5. System confirms the update and allows the professor to continue grading other students.


== UC2002 – Advise Student ==

'''Initiating actor:''' Professor
'''Other actors:''' None

'''Description:'''
A professor records an academic advising relationship with a student for a specific time period.

'''Scenario:'''
1. Professor selects “Start Advising Student”.
2. System shows a list of students belonging to the same faculty as the professor:
{{{
SELECT st.Id, st.Name, st.Surname
FROM Student st
JOIN Professor p ON p.Faculty_Id = st.Faculty_Id
WHERE p.Id = :professor_id;
}}}
3. Professor selects a student and enters the advising start and end dates.
4. System inserts the advising record into the database:
{{{
INSERT INTO Advice (Student_Id, Professor_Id, Start_Date, End_Date)
VALUES (:student_id, :professor_id, :start_date, :end_date);
}}}
5. System confirms the advisor assignment.