database questions:

Part one involves designing and implementing login/logout and session controls for database users on the Web.

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.

The session of each logged-in user has to be managed appropriately to guarantee access control by different types of users.

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(can have access to Student User and Administrative User tables). Entity type User has attributes such as a user id and a password. Add other entity types to the EER diagram as necessary (e.g., Session).

create an SQL FILE corresponding to that EER diagram