The schema of the database is provided below (keys are in bold and underlined, field types are omitted): student( sid , sname, sex, age, year,
The schema of the database is provided below (keys are in bold and underlined, field types are omitted):
student(sid, sname, sex, age, year, gpa)
dept(dname, numphds)
prof(pname, dname)
course(cno, cname, dname)
major(dname, sid)
section(dname, cno, sectno, pname)
enroll(sid, grade, dname, cno, sectno)
Print the names and majors of students who are taking one of the College Geometry courses. For students who do not have a major, print out some special string, e.g., an empty string, as his/her major. (Hint: You'll need to use the "like" predicate and the string matching character in your query. You also likely need to use SET operations.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started