Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need queries in mysql. Given the following tables: o students(sid,name,age,gpa) e courses(cid,deptid, name) . professors(ssn,name,address,phone,deptid) * enrollment (sid.cid,section,grade, foreign key (sid) references students, foreign key
Need queries in mysql.
Given the following tables: o students(sid,name,age,gpa) e 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 {'198:11',640:151','198:112'....] . deptid is in 'cs','math'music,.. . grade is in ['A','B','('... section, age, ssn are an integers . address, phone, name are strings . gpa is float
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