Write queries that return the following resultsets: Faculty are awarded bonuses based on the progress made...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Write queries that return the following resultsets: Faculty are awarded bonuses based on the progress made by students in their courses. Write a query to list each Course Name and the Average Progress of students in that course. The Average Progress displayed should be rounded to one decimal place. The output should be sorted first by Average Progress in descending order, then by Course Name in ascending order. College Management System Schema COO department Yid name faculty id Column Name firstname lastname deptid id Column Name student Column Name firstname lastname street city state streetDetail postalCode LOC majorid int varchar(30) int Data Type int varchar(30) varchar(50) int Data Type Data Type varchar(30) varchar(50) varchar(50) varchar(30) varchar(30) varchar(30) char(5) int Allow Nulls 000 Allow Nulls 00000 Allow Nulls B FO # Fo course id Column Name name deptid studentCourse Column Name studentid courseld progress startDate facultyCourse Column Name o facultyld courseld int varchar(50) int Data Type int int int date int int Data Type Data Type Allow Nulls oooo Allow Nulls 00000 Allow Nulls 000 po Write queries that return the following resultsets: Students are awarded two grades based on the minimum and maximum progress they are making in their courses. The grading scale is as follows: Progress < 40: Progress < 50: Progress < 60: Progress < 70: Progress >= 70: Write a query that displays each student's First Name, Last Name, Minimum Grade based on their minimum progress, and Maximum Grade based on their maximum progress. The output should be sorted by Minimum Grade in descending order, then by Maximum Grade in descending order, then by First Name in ascending order, then by Last Name in ascending order department College Management System Schema faculty firstname lastname deptid id student street Column Name F D B Column Name firstname city state A streetDetail Column Name postalCode majorid int varchar(30) int int Data Type varchar(30) varchar(50) int Data Type int Data Type varchar(30) varchar(30) varchar(30) varchar(30) varchar(30) char(5) Allow Nulls 0 0 0 Allow Nulls 0 0 0 0 0000000000 course 2 id name Column Name deptid studentCourse Column Name 9 studentid ? courseld progress facultyCourse Column Name 9 facultyld int varchar(50) int int Data Type date Data Type O 0 0 0 Allow Nulls 0 0 O O 0 Allow Nulls 4 Write queries that return the following resultsets: Faculty are awarded bonuses based on the progress made by students in their courses. Write a query to list each Course Name and the Average Progress of students in that course. The Average Progress displayed should be rounded to one decimal place. The output should be sorted first by Average Progress in descending order, then by Course Name in ascending order. College Management System Schema COO department Yid name faculty id Column Name firstname lastname deptid id Column Name student Column Name firstname lastname street city state streetDetail postalCode LOC majorid int varchar(30) int Data Type int varchar(30) varchar(50) int Data Type Data Type varchar(30) varchar(50) varchar(50) varchar(30) varchar(30) varchar(30) char(5) int Allow Nulls 000 Allow Nulls 00000 Allow Nulls B FO # Fo course id Column Name name deptid studentCourse Column Name studentid courseld progress startDate facultyCourse Column Name o facultyld courseld int varchar(50) int Data Type int int int date int int Data Type Data Type Allow Nulls oooo Allow Nulls 00000 Allow Nulls 000 po Write queries that return the following resultsets: Students are awarded two grades based on the minimum and maximum progress they are making in their courses. The grading scale is as follows: Progress < 40: Progress < 50: Progress < 60: Progress < 70: Progress >= 70: Write a query that displays each student's First Name, Last Name, Minimum Grade based on their minimum progress, and Maximum Grade based on their maximum progress. The output should be sorted by Minimum Grade in descending order, then by Maximum Grade in descending order, then by First Name in ascending order, then by Last Name in ascending order department College Management System Schema faculty firstname lastname deptid id student street Column Name F D B Column Name firstname city state A streetDetail Column Name postalCode majorid int varchar(30) int int Data Type varchar(30) varchar(50) int Data Type int Data Type varchar(30) varchar(30) varchar(30) varchar(30) varchar(30) char(5) Allow Nulls 0 0 0 Allow Nulls 0 0 0 0 0000000000 course 2 id name Column Name deptid studentCourse Column Name 9 studentid ? courseld progress facultyCourse Column Name 9 facultyld int varchar(50) int int Data Type date Data Type O 0 0 0 Allow Nulls 0 0 O O 0 Allow Nulls 4
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
Oil flows through the 100-mm-diameter pipe with a velocity of 5 m/s. If the pressure in the pipe at A and B is 80 kpa, determine the x and y components of force the flow exerts on the elbow. The flow...
-
Find the area between the curve y=-x2+3x-2 and the x-axis from x=1 to x=2.
-
Identify three verbal and three nonverbal cues that may be observed when making inquiries of an individual who is being deceitful.
-
Determine the direction of the magnetic force exerted at the center of the wire or on the particles in Figure 28. 20. Data from Figure 28. 20 Figure 28.20 (a) (b) N S S N +8 te
-
1. Who would you recommend Stacey Thomas select to serve as project manager? Why? 2. How would you recommend this project be organized? Functional project? Pure project? Matrix? Why? 3. Do you agree...
-
Other than the wind speed, what factor has the most impact on the amount of power generated by a wind turbine? Swept area of rotor Turbine style Terrain Blade material.
-
At the instant illustrated, car B has a speed of 30 km/h and car A has a speed of 40 km/h. Determine the values of r and for this instant where r and are measured relative to a longitudinal axis...
-
1.When beta testing a new software application, the tester found an error and created a report about the error. Describe the items of information, including those related to the test plan, that...
-
Mr . Frimpong is a used clothing dealer in Accra. The business recorded a turnover of Ghs 7 5 , 0 0 0 in 2 0 1 7 . During the year, Mr . Frimpong had the following expenditures, receipts and...
-
According to your review, how PIPEDA applies to this case? Considering the results of the investigation, how would you define the importance of PIPEDA for Canadian society? Please answer according to...
-
A hospital germ-fighting and floor cleaning robot, named Maurice, costs $109,000. Patients are billed $1 per day for Maurice's use and upkeep. A certain 300-bed hospital is considering purchasing...
-
Establish mechanisms for ongoing evaluation and monitoring of the proposed policy changes regarding intimate partner violence and domestic abuse in Hawaii. Define key performance indicators to...
-
An electric circuit with a resistor, a capacitor, an inductor, and a voltage source can be described by the ODE $$ \begin {equation) L (dl\over dt} + RI+ (Q\over C} = E(t). \tag (76) \end{equation)...
-
Explain in detail the differences between the quantity theory of money and Keynes liquidity preference theory. Using Keynes liquidity preference theory, explain how would you expect velocity to...
-
A circular concrete shaft liner with Youngs modulus of 3.4 million psi, Poissons ratio of 0.25, unconfined compressive strength 3,500 psi and tensile strength 350 psi is loaded to the verge of...
-
Match the following terms to the appropriate definitions: well-structured a. constraint between two relation anomaly functional attributes b. functional dependency between the primary key and a...
-
Explain why SQL is called a set-oriented language.
-
Write an SQL command to display each item ordered for order number 1, its standard price, and the total price for each item ordered.
-
What important precedents were set by the Griggs v. Duke Power Company case? The Albemarle v. Moody case?
-
From a practical point of view, why is it important for all managers and future managers to have a good command of human resource management concepts and techniques?
-
Explain what HR management is and how it relates to the management process.
Study smarter with the SolutionInn App