Changes between Version 2 and Version 3 of UC1002
- Timestamp:
- 06/15/26 14:12:13 (35 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UC1002
v2 v3 6 6 7 7 **Description:** 8 Administrator modifies faculty data, such as location, name, or study field.8 Administrator modifies faculty data, such as name, location, study field, or university affiliation. 9 9 10 10 **Scenario:** … … 13 13 14 14 2. System lists all faculties: 15 16 15 {{{ 17 SELECT Id, Name, Location, Study_field FROM Faculty;16 SELECT Id, Name, Location, Study_field, University_Id FROM Faculty; 18 17 }}} 19 20 18 21 19 3. Administrator selects a faculty and updates details. 22 20 23 21 4. System validates input and updates database: 24 25 22 {{{ 26 23 UPDATE Faculty 27 SET Name = :name, Location = :location, Study_field = :study_field 24 SET Name = :name, Location = :location, Study_field = :study_field, University_Id = :university_id 28 25 WHERE Id = :faculty_id; 29 26 }}} 30 27 31 32 28 5. System confirms update and reflects changes across related data (students, professors, subjects).
