Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE show using the website or SQL tool: https://www.db-book.com/university-lab-dir/sqljs.html You are a new student in the Computer Science department, and you are taking CS-315 in

image text in transcribedimage text in transcribed

PLEASE show using the website or SQL tool: https://www.db-book.com/university-lab-dir/sqljs.html

You are a new student in the Computer Science department, and you are taking CS-315 in the Spring semester of 2018 in section 1 . You do not have an assigned grade yet (assign null as the grade value), as you have just started the course. Give the SQL statements necessary to add yourself to the student and takes relations. It's the end of the semester, so update your CS-315 course with the grade your teacher gave you. (use a valid grade that represents what you believe you got) Display the student ID, student name, course id, and course title for any remaining student courses (takes) in the 2018 year with no grades. Write SQL statement that will remove records from takes for any records found in \#6 Show the total salary by department for any department that has exceeded its department budget (use a having clause) Use the university schema for the following questions Figure 2.9 Schema diagram for the university database

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Horse Betting The Road To Absolute Horse Racing 2

Authors: NAKAGAWA,YUKIO

1st Edition

B0CFZN219G, 979-8856410593

More Books

Students also viewed these Databases questions

Question

Distinguish between audit risk and engagement risk.. K-9875

Answered: 1 week ago

Question

Explain the factors influencing wage and salary administration.

Answered: 1 week ago

Question

Examine various types of executive compensation plans.

Answered: 1 week ago

Question

1. What is the meaning and definition of banks ?

Answered: 1 week ago

Question

How would you rate Hsiehs leadership using the Leadership Grid?

Answered: 1 week ago