NOTE: THIS IS CHAPTER 3 - RELATIONS- IN "DISCRETE MATHEMATICS" (AKA DISCRETE STRUCTURE) COURSE FOR COMPUTER SCIENCE**

EXERCISE 3.4.3: Select and Project operations on a relational database: University courses The table below shows a small database whose records correspond to courses offered in a university Course Number CS 111 CS 112 CS 117 CS 116 CS 122A CS 122A CS 122C Course Title Digital Image Processing Computer Graphics Project in Computer Vision Intro to Computer Vision Intro to Database Management Intro to Database Management Principles of Database Management Spencer Winter Instructor Quarter Gupta Spring Gupta Spring Hawkins Fall Hawkins Winter Spencer Spring Wang Winter (a) Give a key for this database (b) Show the results of the operation Select[Course Number = "CS 122A" v Course Number = "CS 122 (c) Show the results of the operation Project[lnstructor] Show the results of the operation Select Quarter "Spring"] followed by Project[Course Number]. Express in English what question this combination of operations is asking (e) Which operations should be performed if you want to know in which quarters CS 122A is being offered? Which operations should be performed if you want to know which courses are being taught by Prof. Gupta? A course is identified by its course title Feedback