[solved]-Use Attached Schema Assignment Every Program Return Program Name Campus Name Tuition Fee A Q39007811

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 in in the same campus as this program. For example if computer science program is taught in 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 in Davis campus Return the name of the teacher(s) who have the 3rd 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 • Explain save point and rollback with example. [write this answer as a comment in sql file] B B dbo Campus Columns Campus ID (PK, int, not null) Campus_Name (varchar(24), null) Campus Address (varchar(24), null) Campus City (varchar(12), null) dbo. Program Columns 7 Program ID (PK, int, not null) Program Name (varchar(24), null) Program Description (varchar(2000), null) Tuition Fees (numeric(7.2), null) Program Coordinator_ID (FK, int, null) Campus_JD (FK, int, null) B e B dbo.Course Columns Course_ID (PK, int, not null) Course_Name (varchar(24), null) Course Semester (varchar(24), null) 7 Program ID (FK, int, null) Teacher ID (FK, int, null) dbo Student Columns Student ID (PK, int, not null) Student_Name (varchar(24), null) Student_Type (varchar(24), null) Student Admission Date (date, null) Student_GPA (numeric(3.2), null) Program_ID (FK, int, null) B dbo.Teacher Columns 7 Teacher_ID (PK, int, not null) Teacher_Name (varchar(24), null) Teacher Salary (numeric(3.2), null) Show transcribed image text 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 in in the same campus as this program. For example if computer science program is taught in 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 in Davis campus Return the name of the teacher(s) who have the 3rd 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 • Explain save point and rollback with example. [write this answer as a comment in sql file]
B B dbo Campus Columns Campus ID (PK, int, not null) Campus_Name (varchar(24), null) Campus Address (varchar(24), null) Campus City (varchar(12), null) dbo. Program Columns 7 Program ID (PK, int, not null) Program Name (varchar(24), null) Program Description (varchar(2000), null) Tuition Fees (numeric(7.2), null) Program Coordinator_ID (FK, int, null) Campus_JD (FK, int, null) B e B dbo.Course Columns Course_ID (PK, int, not null) Course_Name (varchar(24), null) Course Semester (varchar(24), null) 7 Program ID (FK, int, null) Teacher ID (FK, int, null) dbo Student Columns Student ID (PK, int, not null) Student_Name (varchar(24), null) Student_Type (varchar(24), null) Student Admission Date (date, null) Student_GPA (numeric(3.2), null) Program_ID (FK, int, null) B dbo.Teacher Columns 7 Teacher_ID (PK, int, not null) Teacher_Name (varchar(24), null) Teacher Salary (numeric(3.2), null)

Expert Answer

---

Answer to Use the attached schema for this assignment • For every program, return the program name, campus name, tuition fee and… . . .