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 admin 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.

Data Requirements

$$ Each user has a unique username and a password. A user also has a first name, and a last name.

$$ An admin user has a start date while a student user has a date of admission.

$$ Some users are both student users and admin users $($student admin$).$ We do not have any other types of users in the system.

$$ A user session has a unique session id and a session date.

$$ A user may own several sessions $($one for each login$),$ while a session can only be owned by one user.

$$ A user may own zero sessions $($when not logged in$),$ while a session must be owned a user.

Function Requirements

$$ Login: A user can login the system using his$/$her username and password. When login is successfully, a user session should be generated for the user.

$$ Session management: A user session should be used to verify a user$$s identity after a user has logged in$.$ Except the login page, access to any other web$/$PHP pages of the system should be denied unless a provided user session can be verified. $($See Lab $8$ for more details on session control.

$$ Logout: A user can logout the system after logged into it$.$ When a user is logged out, the respective session of the login of the user should be removed from the system.

$$ Web page access: Make sure that a student user can access only student user pages while an admin user access only admin user pages. A student admin may access both types of web pages.

$$ Changing password: A user $($admin or student$)$ can change his$/$her password after login$.$

$$ Managing users: An admin user can list all users or search for any users in the system. An admin user can add new users, delete users, and update any information pieces of an existing user.

General Requirements

You should complete the following tasks for Part One of the project:

$$ Create an EER model$/$diagram based on the data requirements.

$$ Create a database schema based on the EER