Question: Need queries in mysql. In question 13, the average actually means the total number of students with D or F/total number of enrolled students. Given

Need queries in mysql.

Need queries in mysql. In question 13, the average actually means the

total number of students with D or F/total number of enrolled students.

In question 13, the average actually means the total number of students with D or F/total number of enrolled students.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!