Use the Student database to write queries for the followin

March 20, 2016 at 16:59:54
Specs: Windows 10, 8gb
1. Use the Student database to write queries for the following questions:

Student (Name, Student_no, Class, Major)
Course ( Course_name, Course_no, Credit_hours, Department)
Section ( SectionID, Course_no, Semester, Year, Instructor)
GradeReport ( Student_no, SectionID, Grade)
a) Retrieve the names of all courses taught by Professor King in 2007 and 2008.
b) Retrieve the name and transcript of each senior student (Class = 4) majoring in CS. A transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student.
c) For each section taught by Professor King, retrieve the course number, semester, year, and number of students who took the section.
d) Retrieve the names and major departments of all straight-A students (students who have a grade of A in all their courses)
e) Retrieve the names and major departments of all students who do not have a grade of A in any of their courses.


See More: Use the Student database to write queries for the followin

Report •

#1
March 20, 2016 at 17:00:48
can i get answer for that question in dbms

Report •

#2
March 20, 2016 at 23:48:46
Use the student brain to do your homework.

Report •
Related Solutions


Ask Question