Part 1
A. Get the fname, lname of students and the number of courses the student took.
B. Get the fnam, lname of students along with the title of the course and the numeric grade for the course.
C. Get the fname, lname and GPA of each student.
D. Get the course titles, term and lineno along with the enrolment for each course, sorted by enrolment (highest enrolment first)
E. Get the course titles that have never been ofered
F. Get the course title, term and lineno, along with the number of testing units ONLY for the ones that have the minimum number of testing units.
G. Get the term, lineno, component name along with the average percentile for each component in each section, course.
H. Get the course title, term and section number along with the average grade for each one.
Part 2
For this part you are to create a PHP front-end for the queries you created in project #2. The exact format of the PHP pages is up to your creativity, but I must be able to select which query I want to run, one at a time, and then execute. For two (2) of the queries, modify it to support user input via the PHP page.