About CS515 Assignment 1
CS515 Assignment No 1 for Fall 2026 is from Advanced Database Management System. It covers lesson 4: Analytical SQL, Views and Server-Side Programming, carries 20 marks and closed on VULMS on Wednesday 18 November 2026. The solution is on this page, with the assignment file.
- Course
- CS515 Advanced Database Management System
- Assignment
- Assignment No 1
- Semester
- Fall 2026
- Lesson
- 4: Analytical SQL, Views and Server-Side Programming
- Total marks
- 20
- End date
- Wed 18 Nov, 11:59 pm
What CS515 Assignment 1 asks
This assignment evaluates your proficiency in advanced SQL techniques using the SALES and EMPLOYEE tables. You will work with Common Table Expressions, subqueries, and window functions to analyze data and generate specific reports. You are required to write SQL queries and provide the resulting output for each task. You may use PostgreSQL, MySQL 8, or SQL Server to execute your solutions.
-
1
Question No 01
10 marksUsing the SALES table, create a Common Table Expression named region_totals to calculate total sales per region. Then, use a subquery to determine the average of these regional totals. Finally, list the regions where total sales exceed this average, displaying the region, total_sales, and the rounded average_sales.
-
2
Question No 02
10 marksUsing the EMPLOYEE table, write a single query to display each employee's name, department, and salary. Include two ranking columns, salary_rank and salary_dense_rank, using the RANK() and DENSE_RANK() window functions respectively to rank salaries within each department. Provide a brief explanation of why these two ranking methods produce different results for the given data.
- What to submit
- One .doc or .docx file containing the SQL queries and their corresponding outputs.
- Topics covered
- Nested queries Common Table Expressions Advanced aggregation Window functions RANK() DENSE_RANK()
A summary of the assignment file, Fall 2026_CS515_1.docx. Download the file for the full wording before you start.
Lesson covered
The questions in this assignment come from this lesson. Read it in the CS515 handout before you open the assignment file, then practise it with the MCQs and past papers.
Solution
The solution for CS515 Assignment No 1 was added on 16 Nov 2026. It answers the questions in the assignment file, Fall 2026_CS515_1.docx.
Before you submit on VULMS
- 1 Solve the questions in the assignment file yourself first, then use the solution to check your method and answers.
- 2 Write the final answer in your own words. VU checks assignments for copying, and copied work gets zero marks.
- 3 Save your answer in the file type the assignment file asks for, and name it with your student ID, for example BC260012345.
- 4 Open the file once more to check it is not empty or corrupted, then upload it on VULMS before 11:59 pm on Wed 18 Nov.
Questions about this assignment
When is CS515 Assignment 1 due?
It closed on Wednesday 18 November 2026. VULMS no longer accepts files for it, but the assignment stays here for revision.
Is the CS515 Assignment 1 solution free?
The assignment file is free with no limit. The solution counts toward your daily downloads: 3 a day on the web, 30 a day with the free Chrome extension, 100 a day with Pro Semester and unlimited in the Android app.
Can I submit the solution as it is?
No. VU checks assignments for copying, and copied work gets zero marks. Use the solution to check your method, then write your own answer.
What file do I submit?
The assignment file says which file type to upload and lists any extra instructions from your instructor. Name the file with your student ID before you upload it on VULMS.