Need help with PHP and SQL
- or -
Post a project like this$$
- Posted:
- Proposals: 8
- Remote
- #1765548
- Expired
PPH #1 Service Provider in Development & IT : Wordpress|Magento|React Native|Mobile App Development|Angular|Node.js
Mohali
Angular | React | Vue | PHP | Laravel | CodeIgniter | MySQL| NoSQL| WordPress| WooCommerce| eCommerce| React Native| Ionic| Android| iOS| Docker| AWS| Firebase | Business & Finance
Paris
128342367988102707510792051411188157490617288931810194
Description
Experience Level: Intermediate
General information for the website: 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.
Database management system (DBMS): MySQL
Description of requirements/features: 1. 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.
2. 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
3. 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)
Extra notes:
Database management system (DBMS): MySQL
Description of requirements/features: 1. 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.
2. 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
3. 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)
Extra notes:
Stuart T.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
5 May 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Stuart, Could you please confirm whether the job has already been awarded or not? Thanks, Tom
528986
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies