Question: Answer each request about the university database below with an SQL query. Produce a list of students and their IDs who enrolled in some section

Answer each request about the university database below with an SQL query.

Produce a list of students and their IDs who enrolled in some section of algebra in 2017.

Produce a list of courses (not sections) offer?ed by the mathematics department in 2017.

Determine the number of courses offered by each department in 2016.

Determine the total enrollment in each section of courses offered in 2017.

Determine the number of sections taught by Professor Einstein in 2016.

Determine the year Professor Brando started teaching.

Determine the total number of sections Professor Turing has taught of the compilers course.

Determine the total number of As Amy (Id #2) has earned.

Determine the number of professors who have taught the database systems course.

Determine the number of years Professor Brando has been teaching.

Determine the number of students who graduated in 2017.

Determine the number of students who enrolled in at least one section of a course in 2017.

Answer each request about the university database below with an SQL query.

Some sample data STUDENT DEPT Sid SName GradYear Majorld DId DName 1 Joe 2018 2 amy 2018 max 2017 sue 2016 5 bob 2015 6 kim 2015 2017 pat 2016 9 lee 2017 2018 11 tom 2018 10 20 10 20 30 20 30 20 10 20 10 computer science 20 mathematics 30 drama 7 art 10 ali COURSE SECTION Deptld Sectld Courseld Prof YearOffered 2017 2018 2017 CId Number Title 12 466 databases 10 22 395 32 300 calculus 42 200 algebra 52 350 acting 62 400 elocution 10 20 20 30 30 13 12 23 12 32 43 32 53 62 63 42 turing turing newton einstein brando newton compliers 2017 2017 ENROLL Eld StudentId Sectionld Grade 24 34 13 43 43 53 53 43 63 23 54 74 84 94 null

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Consider the Schema diagram for a university database a. Find the names and IDs of all students who have taken a course taught by Dr. Who. Use at least one natural join in your answer. Be careful...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

/*Please answer the Queries and display the code and output.*/ This assignment focuses on the use of the aggregate functions. These functions combine all the results to perform a statistical...

1 Find the names of courses in Comm.Sci.department which have 3 credits. 2 For the student with ID 1 1 4 5 5 . show all course _ ( i ) d and title of all courses registered for by the student. 3 Find...

Write the relational algebra expressions for the following queries: Here is the Database. Now the questions.. toyu.course: 11 rows total (approximately) courseld rubric number name 2,000 CSCI 3333...

1. Consider the 4 relations, namely, student, takes, section, and course in the relational database schema above. Answer the following questions while keeping the efficiency and answer correctness in...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Question 1 : Based on the following information, draw an ER model in the 3 rd Normal form using Visio. Copy and paste your ER Model from Visio to your MS Word answer document. A Painter might paint...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Part 1) Queries with Relational Algebra This part is to get you familiar with expressing queries in Relational Algebra and to further familiarize you with the tables used to implement the telephone...

Alex Rodriguez (known to fans as A-Rod) was the youngest player ever to hit 500 home runs. Here is a stem-and-leaf display of the number of home runs hit by A-Rod during the 1994-2013 seasons,...

Identify the reactant, reagent, and solvent to synthesize the following Grignard reagent. Note: If one or more items are incorrectly placed, a single red X will appear on the top left. CHCHOCHCH,...

Market timing strategies Blank _ _ _ _ _ _ . Multiple select question. rely on shifting between investments in cash and a risky portfolio rely on the manager's forecast of the relative performance...

Calculate revenue for the month of September using the cash basis of accounting.1. Collected $180 cash from customers for services performed in August.

LAST WORD Suppose that a tax cut involves two alternative schemes: ( a ) a $2 tax cut or tax rebate for each of the 10 people in the breakfast club, or ( b ) a tax savings for each of the 10 in...

KEY QUESTION Suppose the government misjudges the natural rate of unemployment to be much lower than it actually is, and thus undertakes expansionary fiscal and monetary policies to try to achieve...

Use the short-run aggregate supply schedules below to answer the questions that follow: AS (P100) AS (P125) AS (P75) P Q P Q P Q 125 $280 125 $250 125 $310 100 250 100 220 100 280 75 220 75 190 75...