Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Project Description: Please write SQL queries to update tables extract the following information. Write your queries based on the database you developed in the previous
Project Description: Please write SQL queries to update tables extract the following information. Write your queries based on the database you developed in the previous project. For each question, write a SQL query and save it as a sql" file using a different query name, for example, query1, query2, etc. Please execute these queries sequentially descriptioin (Not Null) Fundamentals of Computer Sys. Software Engineering I Computer Programming I Introduction to Algorithms Operating Systems Software Design Advanced Database course id level instructor semester (PK) Not Null)(FK) ugrad ugrad ugrad Spring 2018 Spring 2018 Spring 2018 Fall 2017 Fall 2017 Spring 2017 Spring 2017 4 grad uery 1Update the Courses table by adding another column as shown above uery 2 Retrieve all the courses (description) open in year 2018 uery 3 List the name(s) of all the graduate course(s) taught by Steven Garden uery 4 List the name(s) of instructor(s) who taught course(s) in Spring 2017 uery 5 Retrieve all the courses (as well as grades) Alice Wood has taken, ordered b Query 6 List the name(s) of the faculties who offer(s) more than one courses Query 7List the names and grades of the students who take the course "Fundamentals of Computer Svs.", ordered by grades
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started