The CS department liked your skills in SQL, so they decided to grant you full permission...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The CS department liked your skills in SQL, so they decided to grant you full permission over the database. Students Name Netld Type VARCHAR(8) FirstName VARCHAR(255) LastName VARCHAR(255) Department VARCHAR(255) Enrollments Name Type Netld VARCHAR(8) CRN INT Credits INT Score REAL Courses Name CRN Title Type INT VARCHAR(255) Department VARCHAR(255) Instructor VARCHAR(255) There will be a new course this semester. The CRN is 49498; the Title is 'Data Management in the Cloud'; the Department is 'CS'; the Instructor is 'Abdu Alawini'. Insert this new course to the Courses table. A student just transferred to the CS department, the student's NetId is 'deco27'. Update the student's Department to 'CS'. This student is now enrolling in CS411. The NetId is 'deco27'; the CRN is 31355; the Credits will be 4; the Score will be 0. Insert this new enrollment to the Enrollments table. Another course is only offered during fall. The CRN is 11451. Remove it from the Courses table. (Since this is happening before registration, we do not need to worry that there are students already enrolling in this course.) Finally, return the Net Id and CRN of all students enrolled in courses offered by the 'CS' department, in the ascending order of NetId and CRN. Notes and Hints: You should write multiple queries for this question. Remember to type ';' at the end of each query. Do not use views. The CS department liked your skills in SQL, so they decided to grant you full permission over the database. Students Name Netld Type VARCHAR(8) FirstName VARCHAR(255) LastName VARCHAR(255) Department VARCHAR(255) Enrollments Name Type Netld VARCHAR(8) CRN INT Credits INT Score REAL Courses Name CRN Title Type INT VARCHAR(255) Department VARCHAR(255) Instructor VARCHAR(255) There will be a new course this semester. The CRN is 49498; the Title is 'Data Management in the Cloud'; the Department is 'CS'; the Instructor is 'Abdu Alawini'. Insert this new course to the Courses table. A student just transferred to the CS department, the student's NetId is 'deco27'. Update the student's Department to 'CS'. This student is now enrolling in CS411. The NetId is 'deco27'; the CRN is 31355; the Credits will be 4; the Score will be 0. Insert this new enrollment to the Enrollments table. Another course is only offered during fall. The CRN is 11451. Remove it from the Courses table. (Since this is happening before registration, we do not need to worry that there are students already enrolling in this course.) Finally, return the Net Id and CRN of all students enrolled in courses offered by the 'CS' department, in the ascending order of NetId and CRN. Notes and Hints: You should write multiple queries for this question. Remember to type ';' at the end of each query. Do not use views.
Expert Answer:
Answer rating: 100% (QA)
1 Insert a new course to the Courses table INSERT INTO Courses CRN Title De... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
You have just accepted a role as CEO of a company The company has both growing expenses and declining sales The Board of Directors have given you a two million dollar budget to turn the company...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The accountant of your business has recently been taken ill through overwork. In his absence his assistant has prepared some calculations of the profitability of a project, which are to be discussed...
-
Give some examples of types for which it might be useful to define two or more distinct possible representations. Can you think of an example where distinct possible representations for the same type...
-
The lesson from the Korean peninsula seems to be that if you're going to choose the economic system of a country, operating like South Korea under a(n) ? will yield higher annual incomes and gains...
-
Consider the simple linear regression model fit to the rental price data from Problem 2.36. Data From Problem 2.36 Table B.24 contains data on median family home rental price and other data for 51 US...
-
On 13 September 20X1, Nitish Corporations board of directors moved the companys operations into a newly constructed building and declared its old building available for sale. The original cost of the...
-
UNIT 1- MY SELF THE FOOD YOU EAT THE 3 MACH NUTRIENT CATEGORIES FOR HUMAN DIGESTION ARE: CARBOHYDRATES, FATS, PROTEIN DIGESTIVE SYSTEM IS RESPONSIBLE FOR DIGESTING FOOD: 1) PHYSICALLY BREAKING DOWN....
-
(a) For the cascade shown in Figure a, calculate the compositions of streams V4 and L1. Assume atmospheric pressure, saturated liquid and vapor feeds, and the vapor-liquid equilibrium data given...
-
1. Suppose your database stores 10 data records in the following order where each data block can contain at most 2 data records: [2.5+2.5] (2020-01-11, 1, abc) (2020-01-17, 11, def) (2020-02-29, 4,...
-
What are non-current liabilities? Give several examples.
-
What is the eco-efficiency ratio formula?
-
Distinguish between a general benefit and a specific benefit. Why do customers respond positively to specific benefits?
-
What are mutually exclusive capital expenditure proposals? Give an example.
-
Nibbets Baskets Business had net cash provided by operating activities of \(\$ 4300\) for \(20 \mathrm{X} 3\). The business' income statement showed sales (net) of \(\$ 40000\), interest expense of...
-
Question 38 The production function shows the relationship between the costs of inputs and the price of the output. level of outputs that maximize revenue. quantity of the labor input needed for each...
-
Consider the advantages and disadvantages of extending property rights so that everyone would have the right to prevent people imposing any costs on them whatsoever (or charging them to do so).
-
The management of Colonial Adventure Tours wants to upgrade its database and wants you to help select a different DBMS. To help management, they would like you to complete the following exercises....
-
The management of Colonial Adventure Tours asks you to research improvements it might make to its database processing. To help management, they would like you to complete the following exercises. You...
-
The owner of Colonial Adventure Tours knows that being able to run queries is one of the most important benefits of using a DBMS. In the following exercises, you will use the data in the Colonial...
-
Figure P17.65 shows the light intensity on a screen behind a single slit. The wavelength of the light is \(500 \mathrm{~nm}\) and the screen is \(1.0 \mathrm{~m}\) behind the slit. What is the width...
-
If sunlight shines straight onto a peacock feather, the feather appears bright blue when viewed from \(15^{\circ}\) on either side of the incident beam of sunlight. The blue color is due to...
-
The shiny surface of a CD is imprinted with millions of tiny pits, arranged in a pattern of thousands of essentially concentric circles that act like a reflection grating when light shines on them....
Study smarter with the SolutionInn App