Changes between Version 2 and Version 3 of UC1002


Ignore:
Timestamp:
06/15/26 14:12:13 (35 hours ago)
Author:
216009
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UC1002

    v2 v3  
    66
    77**Description:**
    8 Administrator modifies faculty data, such as location, name, or study field.
     8Administrator modifies faculty data, such as name, location, study field, or university affiliation.
    99
    1010**Scenario:**
     
    1313
    14142. System lists all faculties:
    15 
    1615{{{
    17 SELECT Id, Name, Location, Study_field FROM Faculty;
     16SELECT Id, Name, Location, Study_field, University_Id FROM Faculty;
    1817}}}
    19 
    2018
    21193. Administrator selects a faculty and updates details.
    2220
    23214. System validates input and updates database:
    24 
    2522{{{
    2623UPDATE Faculty
    27 SET Name = :name, Location = :location, Study_field = :study_field
     24SET Name = :name, Location = :location, Study_field = :study_field, University_Id = :university_id
    2825WHERE Id = :faculty_id;
    2926}}}
    3027
    31 
    32285. System confirms update and reflects changes across related data (students, professors, subjects).