Project CSPP 528 Database Name: EDF Software/Dan Rocco Date: 12/08/2000 System Overview --------------- This system is developed to allow administrators, students, and faculty to help manage their responsibilities. There are four sections in this system: (1) Administrators * Add/edit a student record (including student's username and password) * Add/edit a faculty record (including faculty's username and password) * Add/edit a course record into the catalog * Add/edit a course record into the schedule * Open or close enrollment for a semester (2) Students * View their record and grades * Register/drop for courses * Change address/personal information (3) Faculty * View enrollment rosters and class size * Enter grades for a class * Enter notes for a student * View courses that they taught in the past * Review the enrollment rosters (4) All Users * View the course catalog * View the course offered * View the courses that will be offered Security -------- Except the "All Users" section, users will need a username and password to enter the system. The username and password are created by Administrators and stored in the "SECURITY" table in the database. Once the users log in and get authenticated by the system, the social security of the user will be derived from the "SECURITY" table. The table also contains the Status column that indicates if the user is a Student, Faculty, or Admin. The followings are some of the valid username and password: (1) Administrators i. Username: slee password: xxx (2) Faculty i. Username: brady password: brady ii. Username: milton password: milton (3) Students i. Username: 333333333 password: sss