Question: 8. Assume that small sections have less than 30 students, medium sections have at least 30 students but less than 80, and large sections have

8. Assume that small sections have less than 30 students, medium

8. Assume that small sections have less than 30 students, medium sections have at least 30 students but less than 80, and large sections have at least 80 students. Your result table should have the following rows and columns: Each table entry must have the number of sections of a given size offered by each department.

sections have at least 30 students but less than 80, and large

9. List of professors that work for departments with more than 20 faculty members and that offer more large sections than small and medium sections combined.

10. Assume grades are A, B, C, D, F where D and F are failing grades. For each course (section) find the percentage of students that failed the course.

11. Find the name of the professor with the maximum percentage of students that failed his course.

12. On average what percentage of students fail a course? (total number of students that failed a course / total number of enrolled students).

13. Find a list of courses (sections) where the percentage of students with D or F is greater than average.

In the case it's too many questions, I think I can figure out to do the rest if I know how to do the first three and the last one.

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

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!

12. Assume that small sections have less than 30 students, medium sections have at least 30 students but less than 80, and large sections have at least 80 students Your result table should have the...

I need help with this two quieries in sql. here are the tables students(sid,name,age,gpa) // sid is the primary key courses(cid,deptid, description) // cid,deptid is the primary key...

I need help with these two quieries in sql. here are the tables students(sid,name,age,gpa) // sid is the primary key courses(cid,deptid, description) // cid,deptid is the primary key...

need help with this query in sql. here are the tables students(sid,name,age,gpa) // sid is the primary key courses(cid,deptid, description) // cid,deptid is the primary key...

Write a query in mysql to show the above. Assume that small sections have less than 30 students, medium sections have at least 30 students but less than 80, and large sections have at least 80...

need help with this two quieries in sql. students(sid,name,age,gpa) // sid is the primary key courses(cid,deptid, description) // cid,deptid is the primary key...

Tutorial 2.1 Chapter 3Graphical descriptive methods - Nominal data MULTIPLE CHOICE QUESTIONS 1. Which of the following is a graphical technique used to present nominal (categorical) data? A. Bar...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Set Student Name: 1. Answer true or false for each part, and if false, explain your answer. a. The point estimate for the population mean, , of an x distribution is x-bar, computed from a random...

1. True or False. Justify for full credit. (15 pts) (a) If the variance of a data set is zero, then all the observations in this data set are zero. (b) If P(A) = 0.4 , P(B) = 0.5, and A and B are...

What is the binder in the hot-box core-making process?

Assuming you have about $6000 in savings how much should you keep in your chequing account if your monthly expenses are approximately $4000 a month?

Amanda's husband, who was an air traffic controller for the past 8 years, was a vested member of a defined benefit pension plan before his death at age 3 9 . As his surviving spouse, to what is...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

5. The computer imposes a discipline of linear thinking. Organizations will need to find ways to encourage and protect nonlinear thinking and communicating.

6. Expectations of work performance may be machine driven. Employees in some organizations will perceive this as dehumanizing and coercive. (pp. 480481)

7. Where Do We Begin?