7. The table below shows a small database whose records correspond to courses of

Question

7. The table below shows a small database whose records correspond to courses offered in a university Course Number Course Title CS 111 CS 112 CS 117 CS 116 CS 122A CS 122A CS 122C Digital Image Processing Computer Graphics Project in Computer Vision Intro to Computer Vision Intro to Database Managememt Intro to Database Management Principles of Database Management Spencer Instructor Quarter GuptaSpring Gupta Spring Hawkins Fall Hawkins Winter Spencer Spring WangWinter Winter (a) Show the results of the operation Select[Course Number- "CS 122A" V Course Number-"CS 122C"] (b) Show the results of the operation Project[Instructor] (c) Show the results of the operation Select[Quarter-"Spring" followed by Project[Course Number]

Explanation / Answer

A.Ans
select * from operation where course_number= 'CS122A' and course_number= 'CS122C' ;

B.Ans

Select Instructor from operations;

C. Ans

select Course_number from operations where Quarter='Spring' ;

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

---

---

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