Appendix A: Database to be used for SQL select problemsSTUDENTNameStudent_numberClassMajorCSSmith171Brown8CSCOURSECourse_nameCourse numberCredit hoursDepartmentIntro to Computer ScienceCS13104CSData StructuresCS33204CSDiscrete MathematicsMATH24103MATHDatabaseCS33803CSSECTIONSection_identifier Course_numberSemesterYearInstructor85MATH2410Fall07King92CS1310Fall07Anderson102CS3320Spring08Knuth112MATH2410Fall08Chang119CS1310Fall08Anderson135CS3380Fall08StoneGRADE REPORTStudent_numberSection_identifierGrade1711217119C858.9281028135APREREQUISITECourse_numberPrerequisite_numberCS3380CS3320CS3380MATH2410CS3320CS1310Ex 5) Write SQL statement to retrieve the names of all students who took both sections 112 and119. Show the result of this query applied to the given DB state.ANSWER:Ex 6) Write SQL statement to retrieve the names of all freshman students majoring in computerscience. (Freshman students have class = 1).ANSWER:

A query is a question or inquiry about a set of data.

Answered: Ex 5) Write SQL statement to retrieve…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Computer science Short answer What is a software as a service (SaaS)?
Consider the following table. Kids (id: string, race: string, height: numeric, weight: numeric, age: integer, gender. string) Task: Write a SQL statement to retrieve all information of female kids taller than 150 CM.
Question 14 Write a SQL statement to un-grant the select and alter privilege from the user Ahmed. Assume that the table name is 'student' Use the editor to format your answer
1. The management of the organization has decided to increase the salaries of all employees to15% for this, write a PL/SQL block to accept the employee number and to update the salary ofthat employee. Display the output based on the existing records of the employees.
order db orderid int custid int itemcode int orderquantity int deliverydate date modeofpayment char(1) date_of_order date
(a) How do you take union of two tables in SQL? (b) How do you take the intersection of two tables in SQL? (c) How do you take the difference of two tables in SQL? (d) Are there any restrictions on the tables when performing any of these operations?
Database Q1: Select the correct SQL statement to provide the user Samer with read only permission on Employees table a) Grant read on Employee where username = Samer; b) Grant read only on Employee to Samer; c) Grant select to Samer on Employee; d) Grant select on Employee to Samer; Q2: Based on the TWO schema structures below, which SQL statement will create a view to show department names where each department has at least 5 employees? Employee (E_ID, E_Name, D_ID, E_Salary) Department (D_ID, D_Name, D_Address) (Select one) a) Create View Dept_Emp as select D_Name, count(E_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Where count (E_ID) >= 5; b) Create View Dept_Emp as select D_Name, count(E_ID) from Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; c) Create View Dept_Emp as select D_Name, count(D_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; d)…
Is this statement true or false: Oracle SQL allows full expression-based use of both provided (built-in) and user-definable functions.
Create a SQL statement to Add a CHECK constraint for the CTYPE column in the CLIENTS table. It must accept either New or Old only.
Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle, ProductColor, ProductPrice). Note: ProductWeight and ProductPrice are numeric fields, and the other attributes are character fields, i.e., store text. Write a SQL query to display the product class whose average price is at least 50
Write an SQL query to get 127.57 as output for the number 127.569. Use appropriate number function to get 127.57
5. Write an SQL statement to display all orders from the tables Catalog2015 and Catalog2016 for orders happened in 2016 not 2015. (CL0 e)

SEE MORE QUESTIONS

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS