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) create an SQL FILE corresponding to that EER diagram