mySQL ~results are based on user selection of a value (using dropdowns in PHP).

Question

mySQL

~results are based on user selection of a value (using dropdowns in PHP). These values are marked with asterisks in the query description.~

1.) Produce a chronological list of all courses taken by a *specified student*. Show grades earned. Include overall hours taken and GPA at the end.

2.) Produce a list of students and faculty who were in a *particular building* at a *particular time*. Also include in the list faculty and advisors who have offices in that building.

I course_id I subject I credit_hoursI department id 1 I Introduction to Informatics 2 I Introduction to Cybersecurity I 3 I Mathematical Foundations of In I 4 I Information Representation 5 I Apparel Merchandising 6 I Graphic Design 7 I Photography 8 I Printmaking 9 I Basic Accounting Skills I 2 2 2 2 10 I Business Presentations 11 I The Computer in Business 12 I Legal Environment of Business I 13 I Music for the Listener 14 I Introduction to Music Theory I 15 I Hand Drumming 16 I Beginner Ukulele 17 I Beginner Acting 18 I Intermediate Acting 19 I Shakespearean Theater 20 I Advanced Interpretive Theater I 4 4

Explanation / Answer

If you have any doubts, please give me comment...

$sql = "SELECT `subject`, credit_hours, grade FROM (course NATURAL JOIN section) NATURAL JOIN details WHERE student_id = '".$student_id."'";

$sql = "SELECT student.*, employee.* FROM (((student NATURAL JOIN student_section) NATURAL JOIN employee E) INNER JOIN room R ON E.office=R.room_id) NATURAL JOIN bulding B WHERE B.building_id='".$building_id."'";

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.