Student and Faculty Management System

1. Log In Authentication SSN, IP, time SSN, password User Input Login SSN, password Person Login Approved or Denied Generate Corresponding HTML Screen

2. Show List of Students (Faculty) SSN Faculty Student Show List of Students Name, email, phone#, bar, advisor_id,dean_id Web page containing List of Students Faculty SSN

3. Map Generator Student SSN,Residence Student_Transcript Student_ID,Course_ID,Term Current_Courses Map Generator Course_ID,Location Map Draw Map, Show Distance, Walking Times Path Lengths, Coordinates, Building Names Current Info SSN,Current Term

4. Search Display List of Courses List of Courses Current_Courses Instructor_ID,Course_ID Search Course_Info Course_ID,Course_Name,Description User Input Search String, Search By (course #, instructor, course name,description)

5. Scheduler Display List of Schedules Current_Courses Time,Course_ID, instructor Scheduler Students SSN,P_Major,S_Major Student_Transcript Student_ID,Course_ID Plan_Of_Study Study_ID,Gen_Reqs,Major_Reqs General_Requirements Req_ID,Course_ID Scheduling Options Major_Requirements Req_ID,Course_ID Times wanted, preferred teachers, courses

6. Show User Profile (Student) SSN,Name, address,password, Email, phone Person Student Show User Profile Advisor_ID,Dean_ID,residence User Profile Screen Student Social Security #

7. Show User Profile (Faculty) SSN,name,password,address,email,phone Person Show/Modify User Profile Faculty User Profile Screen SSN,department Faculty SS#

8. Change User Profile (Student) Name, Password, email, phone #, residence SSN,name, password,address,email, phone, residence User Input Person Modify Student User Profile

9. Change User Profile (Faculty) SSN,Name, Password, email, phone,address SSN,Name, password, Email, address, phone User Input Person Modify Faculty User Profile

10. Authentication (Student) Student SSN, bar Student Authentication Authentication Authentication SSN, IP time IP Allow user access or display error message Type of Transaction Search, scheduler, add/modify course, etc..

11. Authentication (Faculty) Person SSN,Advisor_ID,Dean_ID Faculty Authentication Authentication Authentication SSN, IP time Students SSN, Advisor_ID Allow user access or Display Error message IP Type of Transaction Transaction type, student SSN

12. Add Section to Database (Dean) Current_Courses User Input Course_ID, time, location, seats, instructor.,etc.. Add Section to Database Course_ID, Time, Location, Seats, instructor, etc.. Show new course information

13. Delete Section from Database (Dean) Current_Courses Course # Course# Delete Section from Database Delete Successful Or Unsuccessful

14. Retrieve Section Information This function will be used both in “Modify Course” for administrators And in retrieving the results for a search Current_Courses Course_ID, time, seats, location, etc.. Retrieve Section Information Course # Show new course information

15. Update Section Information (Dean) Current_Courses User Input Course_ID, location, seats, instructor, time, etc.. Update Section Information Course_ID, Time, Location, Seats, Instructor, etc.. Show new course information

16. Add Course to Database (Dean) Course_Info User Input Course_ID, Course_Name,Course_Number,Description, Number_Of_Credits Update Course Information Course_ID, Course_Name,Course_Number,Description, Number_Of_Credits Show new course information

17. Delete Course from Database (Dean) Course_Info Course # Course# Delete Course from Database Delete Successful Or Unsuccessful

18. Update Course Information (Dean) Course_Info User Input Course_ID, Course_Name,Course_Number,Description, Number_Of_Credits Update Course Information Course_ID, Course_Name,Course_Number,Description, Number_Of_Credits Show new course information