Computers and Technology, 17.08.2021 01:00 zhvianna
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 {'198:11','640:151','198:112,...} • deptid is in {'cs', 'math', 'music ,...} • grade is in 'A','B','C',...} • section, age, son are an integers • address, phone, name are strings • gpa is float Provide SQL instructions for each of the following questions
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: deptid small medium large CS math Each table entry must have the number of sections of a given size offered by each department.
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.
14. Write a query that produces the following table: deptid SPS % A % B % C % D % F math Where SPS is the average number of students in each section and column %A has the per- centage of students that got an A. and so on, over all the courses offered by each denartment.
Answers: 2
Computers and Technology, 22.06.2019 15:20
This os integrated the processing power of windows nt with the easy-to-use gui of windows 98. windows 2000 windows 3.11 windows for workgroups windowa millennium edition
Answers: 1
Computers and Technology, 22.06.2019 20:00
The blank button automatically displays next to the data when you select a range of numeric data which is an available option for creating a chart
Answers: 3
Computers and Technology, 25.06.2019 11:30
Give two reasons why cloud computing could be detrimental to a company.
Answers: 1
Computers and Technology, 25.06.2019 12:30
Why is outfitting a workspace with video games in technology development company considered a strategic use of money
Answers: 2
Given the following tables: • students(sid, name, age, gpa) • courses (cid, deptid, name) • professo...
Social Studies, 22.07.2021 19:00
Social Studies, 22.07.2021 19:00
Biology, 22.07.2021 19:00
World Languages, 22.07.2021 19:00
Mathematics, 22.07.2021 19:00
Chemistry, 22.07.2021 19:00
Mathematics, 22.07.2021 19:00
Biology, 22.07.2021 19:00