$1$

Course Code: Course Title: Database Management

Class #: Semester: Summer $2024$

Page $1$ of $2$

ASSIGNMENT $2($SQL$)$

Use the attached schema for this assignment

$$ For every program, return the program name, campus name, tuition fee, and the average

tuition fee for the programs that are taught on the same campus as this program. For example,

if computer science program is taught on Davis campus, then I want you to return the program

name, campus name, tuition fee of the program, and the average tuition fee for all the

programs that are taught on the Davis campus

$$ Return the name of the teacher$($s$)$ who have the $3$rd highest salary

$$ For every student, return the difference between the student gpa and the average gpa of the

students who were admitted $30$ days before and $30$ days after the admission date of the

student

$$ Teacher table is queried often using teacher name as the condition. Create an index that will

improve the performance of this query. You need to choose the most appropriate index

$$ Write SQL statement that will create student table as index organized table

Instructions

$$ Deliver one $.$sql file that contains the questions and the select statements.

Assessment Rubrics

Task Possible Points Comments

SELECT

Statement

$12$

$22$

$32$

$42$

$52$

Total Points $10$

Course Code: Course Title: Database Management

Class #: Semester: Summer $2024$

Page $2$ of $2$

Please note that you need to create these tables and insert some rows to test your queries. Please share all code

plus snapshots of all results even statements you used for creating tables, as

we have to do this assignment in sql developer app and give the proper answers and with steps aswell