The table below shows the database of course offerings for the Computer Science
ID: 666111 • Letter: T
Question
The table below shows the database of course offerings for the Computer Science Department for the current academic year. It's actually just a portion of the course offerings, but for the purposes of this question, assume it lists all the courses.
a. Give a key for this database.
b. Show the results of the operation SELECT[Course number = "CS122A" ? Course number = "CS122C"]
c. Show the results of the operation PROJECT[ Instructor ]
d. Show the results of the operation SELECT[Quarter="Spring"] followed by Project[Course number]. Express in English what question this combination of queries is asking.
e. What operation or operations should be performed if you wanted to know which quarters CS 122A is being offered?
f. What operation or operations should be performed if you wanted to know which courses are being taught by Prof. Majumder?
Explanation / Answer
A)
Give a key for this database.
Answer: Course number, Quarter
B)
Show the results of the operation SELECT[Course number = "CS122A" Course number = "CS122C"]
Answer:
Course number
Course title
Instructor
Quarter
CS 122A
Introduction to Data Management
Carey
Spring
CS 122A
Introduction to Data Management
Li
Winter
CS 122C
Principles of Data Management
Carey
Winter
C)
Show the results of the operation PROJECT[ Instructor ]
Answer:
Instructor
Majumder
Majumder
Fowlkes
Fowlkes
Carey
Li
Carey
D)
Show the results of the operation SELECT[Quarter="Spring"] followed by Project[Course number]. Express in English what question this combination of queries is asking.
Answer:
Course number
CS 111
CS 112
CS 122A
E)
What operation or operations should be performed if you wanted to know which quarters CS 122A is being offered?
Answer: SELECT[Course number =”CS 112 A”] followed by Project[Quarter].
F)
What operation or operations should be performed if you wanted to know which courses are being taught by Prof. Majumder?
Answer: SELECT[Instructor =” Majumder”] followed by Project[Course number]
Course number
Course title
Instructor
Quarter
CS 122A
Introduction to Data Management
Carey
Spring
CS 122A
Introduction to Data Management
Li
Winter
CS 122C
Principles of Data Management
Carey
Winter
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.