Question: Develop a simple Web application that generates, from the database shown in the appendix, a simplified student transcript given his user name and password. The

 Develop a simple Web application that generates, from the database shown

in the appendix, a simplified student transcript given his user name and

Develop a simple Web application that generates, from the database shown in the appendix, a simplified student transcript given his user name and password. The site consists of three (3) modules, you name: login.php, register.php and generate.php In the login.php you just validate that the student has entered a username and a password. If valid redirect the user to the generate.php by clicking on the link Generate Report Otherwise notify the user that the username and password are required. 2. n the generate.php, do the following Check whether the student is registered (use query Q1). If not, direct the student to register.php by clicking on Registration Page Otherwise: Generate the transcript using query Q2 Format the output in a table as shown in Figure 2. Compute the average gpa from the database, using the query Q3 Update the student's gpa n the table students setting it with the grade defined in query Q3 Query Q1: check (with un an pw) if the student who attempts to login is registered Query Q2: generate the transcript for the logged student from transcript where un xxx (where 'xxx' is the username of the logged student and grade is the output of query) Query Q4: update the logged student setting the gpa to grade login.php

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!