Question: need help with this two quieries. 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

need help with this two quieries.

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. Find the name of the professor with the maximum percentage of students that failed his course.

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

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!

Q:

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

Q:

need help with this two quieries. 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) //...

Q:

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

Q:

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

Q:

need help with this two quieries. 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) //...

Q:

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

Q:

CREATE TABLE students( sid char(10), name varchar, age int, gpa float, PRIMARY KEY(sid)); CREATE TABLE courses( cid varchar(7), deptid varchar(10), name varchar(20), PRIMARY KEY(cid)); CREATE TABLE...

Q:

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

Q:

Given the following tables: students(sid name,age,gpa) . courses(cid,deptid, name) . professors(ssn,name,address,phone,deptid) section.grade enrollment (sid.cid foreign key (sid) references students,...

Q:

I need a Dependency Diagrams for each entity type (show that there are no partial or transitive dependencies). a complete E/R diagram that satisfies Third Normal Form, and complete Data Dictionary...

Q:

LUFAX HOLDING company Prepare a schedule that presents the following ratios for my company: Book value of common stock; dividend payout; market to book; price earnings ratio Comment on the...

Q:

Clifford Shropshire has a flea market booth and marks all his items so that the price includes state sales tax at a rate of 6.5%. He sold a set of china for $285. How much sales tax should he send to...

Q:

Explain how credit risk can be managed with Credit default swap and Credit spread option with illustrative examples

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

4 What actions are needed to straighten out the matrix twist? CleanCo is a Polish manufacturer of cleaning products that serves the European grocery retailing market. CleanCo currently segments its...

Q:

1 When IKEA was founded 60 years ago by Ingmar Kamprad, he realised that customers did not mind queuing, collecting their purchases and assembling the furniture themselves as long as the price was...

Q:

1 Evaluate the changes that took place in the segmentation of Powerdrives market. Tom Cross took over as Managing Director at Powerdrive Motors in South Africa three years ago. At the time, the...