PHP: Goal of the Course Project

The course project contains two parts. Part one involves designing and implementing login/logout and session controls for database users on the Web. Part two involves designing and implementing a "Student Enrollment Information System" for these users. This enrollment system will allow a student to query his/her course information as well as allow them to enroll in courses through a Web interface. Administrators of the system will be able to manage and maintain the student enrollment information system through a Web interface.

Part One Description
Note that you are allowed to re-use the code in demo. zip provided for Lab 8 for this project.

In this part, you will design and implement a login/logout system where a student will be able to login as a student user through a Web interface. An administrator of the enrollment information system will be able to login as an administrative user through a Web page interface and will have more privileges to access and update the database.

You will design and implement PHP programs that generate student and administrative user Web pages. The session of each logged-in user has to be managed appropriately to guarantee access control by different types of users.

You will design and implement the following items in part one of the project.

(a) Create an EER diagram that includes all entity types that are involved in this part of the project, such as User, Student User and Administrative User among others. Note that there might be student administrators.

(b) Entity type User has attributes such as a user id, a password and a user type (student or administrator or both).

(c) Add other entity types to the EER diagram as necessary (e. g., Session).

(d) You design your own user interface. Interface should be intuitive and clear.

(e) Implement the following functions for part one:

· Login and logout functions. Make sure that a student user can access only student user Web pages while an administrative user access only administrative user Web pages. A student administrator may access both types of Web pages.

· Change password. A user (administrator or student) can change user password after login.

· Manage users. An administrative user can list all or search any user information. An administrative user can add, delete and update user information. An administrative user can reset a user’s password to a default password.

Submission Requirement
(a) The modified EER diagram

(b) Relational database schema (SQL file) needed for part one

(c) The COMSC account name of the group member who has the Web pages of the project in his/her account

(d) The URL of the project

(e) An administrative user account and a student user account. You need to enter some data in the database for testing purpose

(f) You do NOT need to submit a hard copy of your source code

Grade Distribution
(a) EER diagram. (20 pts)

(b) Database schema. (20 pts)

(c) Correct implementation of all functions (50 pts)

(d) Submission according to requirements (10 pts)