Posted: August 4th, 2023

Database designs | Computer Science homework help

 Using the University Database:
Rank order all students by total credit (DESC)

Create a view tot_credits_dept
(columns: year, dept_name,
with the total
number of credits taken
by all students in each year for courses offered by each department

Compute average
number of credits over three
preceding years
per department using the view you created

Compute maximum
number of credits over for the window
of 2 years before and 2 years after the
current year per department
Using the view you just created, get the average
total credits by each department over all prior years. 

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: