Find a list of courses where the percentage of students

Assignment Help Database Management System

Reference no: EM132080153

You 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

professors(ssn,name,address,phone,deptid) // ssn is the primary key

enrollment(sid,cid,section,grade) cid makes reference to the courses table. // sid, cid, and section is the primary key

teaches(cid,section,ssn). cid, section makes reference to the enrollment table // cid, section is the primary key

a. 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. 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.

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

Reference no: EM132080153

Questions Cloud

Increase in the quantity demanded : An "increase in the quantity demanded" means that a. the demand curve has shifted to the right

Draw a plan view of the front panel : ENGINEERING DESIGN - DESIGN PROJECT - Teesside University - An analogue/digital circuit trainer is required for open learning students to use to build circuits

Describe a competitive market : Identify whether or not each of the following scenarios describes a competitive market, along with the correct explanation of why or why not.

Demand schedule or law of demand : A graph showing the relationship between the price of a good and the amount that buyers are willing to and able to purchase at a variety of prices

Find a list of courses where the percentage of students : 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.

What is the income velocity of money in freedonia : The money supply is growing at 12% per year and real income, Y, is growing at 4% per year.

Price of a chinese-made car : Which does an increase in the price of a Chinese-made car that is popular among U.S. consumers show up in?

Write a program that transmits a series of characters : Write a program that transmits a series of characters (in C).The sequence will consist of "AlphaNumber", where Alpha is meant to be a letter.

To create and add the customer record to the database : Program should use a function, generateRecord, to create and add the customer record to the database (a dict that stores customers' information).

User Account

All Pages