Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the following tables: students(sid name,age,gpa) courses(cid,deptid, name) . professors(ssn,name,address,phone,deptid) * enrollment(sid cid section,grade, foreign key (sid) references students, foreign key (cid) references courses foreign
Given the following tables: students(sid name,age,gpa) courses(cid,deptid, name) . professors(ssn,name,address,phone,deptid) * enrollment(sid cid section,grade, foreign key (sid) references students, foreign key (cid) references courses foreign key (cid,section) references teaches) . teaches(cid section,ssn, foreign key (cid) references courses, foreign key (ssn) references professors) Domain cid is in f'198:11', 640:151','198:112'...^ o deptid is in {'cs', 'math','music',...) grade is in ['A''B', C. *section, age, ssn are an integers address, phone, name are strings . gpa is float Provide SQL instructions for each of the following questions Given the following tables: students(sid name,age,gpa) courses(cid,deptid, name) . professors(ssn,name,address,phone,deptid) * enrollment(sid cid section,grade, foreign key (sid) references students, foreign key (cid) references courses foreign key (cid,section) references teaches) . teaches(cid section,ssn, foreign key (cid) references courses, foreign key (ssn) references professors) Domain cid is in f'198:11', 640:151','198:112'...^ o deptid is in {'cs', 'math','music',...) grade is in ['A''B', C. *section, age, ssn are an integers address, phone, name are strings . gpa is float Provide SQL instructions for each of the following questions
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
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