I want a web-based Student Certificate Management System (SCMS) built in PHP with a MySQL back-end. The application must let students register with their Gmail credentials, request academic certificates, track the progress of each request, and finally download the approved certificate. An open home page should also allow anyone to verify a certificate’s authenticity by entering the certificate number. The system will run with two internal roles only—Maker and Approver—each with clearly separated duties: • Maker: can check request status, create certificates directly when permitted, and download any generated certificate. • Approver: reviews and approves student registrations, generates certificates, and can update their own signature image. Core student functions include: – Gmail-based sign-up / login – Submit certificate request + automatic request-form download – Real-time request status check – Final certificate download once approved Administrative functions include password management for all roles, request forwarding or deletion, record searching, and bulk record downloads. Please build the full CRUD back-end, intuitive Bootstrap (or similar) front-end, and supply a well-structured MySQL schema. I will consider the project complete when I can deploy it on a standard LAMP stack, run test cases that demonstrate every feature above, and verify that certificate numbers entered on the public page return the correct details.