Just the Highlighted ones. STUDENT Major Name Student_numberClass Smith 17 CS CO

Question

Just the Highlighted ones.

STUDENT Major Name Student_numberClass Smith 17 CS COURSE Course_ name Course_number Credit hours Department Intro to Computer Science CS1310 Data Structures Discrete Mathematics Database CS3320 MATH2410 CS3380 CS CS MATH CS SECTION ster Year Instructor King Anderson Knuth Course numberSemester 85 92 102 112 119 135 MATH2410 CS1310 CS3320 MATH2410 CS1310 CS3380 07 07 08 08 Chang 08 08 Anderson Stone GRADE REPORT Student_numberSection_identifier Grade 112 119 17 17 92 102 135 PREREQUISITE Course_number Prerequisite_number Figure 1.2 A database that stores student and course information. CS3380 CS3380 CS3320 CS3320 MATH2410 CS1310

Explanation / Answer

Sql queries are given below:

a)

SELECT Name from STUDENT WHERE Major = 'CS'

b)

SELECT SECTION.Instructor, SECTION.Year, COURSE.Course_name FROM
SECTION INNER JOIN COURSE ON SECTION.Course_number = COURSE.Course_number WHERE SECTION.Year BETWEEN 2007 AND 2008

c)

SELECT SECTION.Instructor, SECTION.Year, SECTION.Course_number, SECTION.Semester, GRADE_REPORT.Student_number FROM
SECTION INNER JOIN GRADE_REPORT ON SECTION.Section_identifier = GRADE_REPORT.Section_identifier

Related Questions

Navigate

• Browse (All)
• Browse J
• Subjects

---

---

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