Question

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.

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 and a password.

(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 new users, delete and update existing users. An administrative user can reset a user’s password to a default password.

(a) The modified EER diagram

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

Answer 1

(a):

(b):

(c)