Person (Name, ID, Address, DOB) Instructor (InstructorID, Rank, Salary) Student

Question

Person (Name, ID, Address, DOB)

Instructor (InstructorID, Rank, Salary)

Student (StudentID, Classification, GPA, MentorID, CreditHours)

Course (CourseCode, CourseName, PreReq)

Offering (CourseCode, SectionNo, InstructorID)

Enrollment (CourseCode, SectionNo, StudentID, Grade)

From the table above translate from English into SQL
(a). Report the Course(S) with lowest enrollments. You should output the Course Code and the number of enrollments.

(b). List the Student ID, name and Completed credit hour of all freshman born in or after 1976.

Explanation / Answer

a.) $query = "select CourseCode from Course where CourseName='S'"; $result = mysql_query($query); $coursecode = $resulst; $query1 = "select * from Enrollment where CourseCode='$coursecode'"; $result2 = mysql_query($query1); int $i=0; while($row=mysql_fetch_array($result2)){ //incrementing i ( here i is noofenrollments) $i++; } echo $coursecode; echo $i;

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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