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

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 08:00

Digital information is stored using a series of ones and zeros. computers are digital machines because they can only read information as on or off –1 or 0. this method of computation is known as the system

Answers: 1

Answer

Computers and Technology, 22.06.2019 23:00

Suppose s, t, and w are strings that have already been created inside main. write a statement or statements, to be added to main, that will determine if the lengths of the three strings are in order by length, smallest to largest. that is, your code should determine if s is strictly shorter than t, and if t is strictly shorter than w. if these conditions hold your code should print (the boolean value) true. if not, your code should print false. (strictly means: no ties) example: if s, t, and w are "cat", "hats", and "skies" your code should print true - their lengths are 3-4-5; but if s, t, and w are "cats" "shirt", and "trust", then print false - their lengths are 4-5-5 enter your code in the box below

Answers: 2

Answer

Computers and Technology, 23.06.2019 01:50

Write a program that uses a random number generator to generate a two digit positive integer and allows the user to perform one or more of the following operations: a. double the number. b. reverse the digits of the number. c. raise the number to the power of 2, 3, or 4. d. sum the digits of the number. e. if the number is a two-digit number, then raise the first digit to the power of the second digit. f. if the number is a three-digit number and the last digit is less than or equal to 4, then raise the first two digits to the power of the last digit. after performing an operation if the number is less than 10, add 10 to the number. also, after each operation determine if the number is prime. each successive operation should be performed on the number generated by the last operation. your program should not contain any global variables and each of these operations must be implemented by a separate function. also, your program should be menu driven. 7. (fraction calculator) write a program that

Answers: 1

Answer

Computers and Technology, 23.06.2019 19:30

Of the following pieces of information in a document, for which would you most likely insert a mail merge field?

Answers: 3

Answer

You know the right answer?

Given the following tables: • students(sid, name, age, gpa) • courses (cid, deptid, name) • professo...

Questions