The table below shows a small database whose records corresp

The table below shows a small database whose records correspond to courses offered in a university. Show the results of the operation Show the results of the operation Project[Instructor] Show the results of the operation Select [Quarter \"Spring\"] followed by Project[Course Number].

Solution

A) .Input query selects all the rows from database where Course Number equals to either ”CS 122A” or “CS 122C”

Results :

Course Number

Course Title

Instructor

Quarter

CS 122A

Intro to Database Managment

Spencer

Spring

CS 122A

Intro to Database Managment

Wang

Winter

CS 122C

Principles of Database Managment

Spencer

Winter

Note : if your condition only getting Course Number column then output is

Course Number

CS 122A

CS 122A

CS 122C

B). Input query selects all the names of instructors from db .

Results : : if your condition only getting Course Number column then output is

Instructor

Gupta

Gupta

Hawkins

Hawkins

Spencer

Wang

Spencer

C.) Input query selects rows with columns quarter ,Course title, Course Number from db where quarter equal to “Spring”

Quarter

Course Title

Course Number

Spring

Digital Image Processing

CS 111

Spring

Computer Graphics

CS 112

Spring

Intro to Database Managment

CS 122A

Course Number	Course Title	Instructor	Quarter
CS 122A	Intro to Database Managment	Spencer	Spring
CS 122A	Intro to Database Managment	Wang	Winter
CS 122C	Principles of Database Managment	Spencer	Winter