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

Don't use plagiarized sources. Get Your Custom Essay on
Need an answer from similar question? You have just landed to the most confidential, trustful essay writing service to order the paper from.
Just from $11/Page
Order Now

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.