Please solve and show work. 2.18 Write the following queries in relational algebra, using the university schema.A. Find the ID and name of each instructor in the Physics department. Page 63B. Find the ID and name of each instructor in a department located in the building "Watson."C. Find the ID and name of each student who has taken at least one course in the "Comp. Sci."department.D. Find the ID and name of each student who has taken at least one course section in the year2018.

Answered: 2.18 Write the following queries in…

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

Question 13 Given the following relation: Book (BookID, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: i. Read a Book id provided by user at run time and store it in a variable. ii. Fetch the Author and title of the book having the entered id and store them inside two variables iii. Display the fetched book author and title.
Question 13 Given the following relation: Movie (MovielID, Title, Genre, Year) Write a PL/SQL block of code that performs the following tasks: i Read a movie id provided by user at nun time and store it in a variable. i. Fetch the Genre and title of the movie having the entered id and store them inside two variables i Display the fetched movie Genre and title. TTTT Paragraph - Arial 3 (12pt) O f Mashups- HTHL ESS
A company that provides a movie-streaming subscription service uses a relational database to store information on movies to answer customer questions. Each entry in the database contains the following items: Movie ID (the primary key), movie title, year made, movie type, MPAA rating, starring actor #1, starring actor #2, starring actor #3, and director. Movie types are action, comedy, family, drama, horror, science fiction, and western. MPAA ratings are G, PG, PG-13, R, NC-17, and NR (not rated). Using a graphics program, develop an entity-relationship diagram for a database application for this database.
Consider the following expressions, which use the result of a relational algebra operation as the input to another operation. For each expression, explain in words what the expression does. a. year 2009 (takes) ▷ student b. year 2009 (takes ▷ student) C. ID.name, course_id (student takes)
Question 13 Given the following relation: Movie (MovielID, Title, Genre, Year) Write a PL'SQL block of code that performs the following tasks: i. Read a movie id provided by user at run time and store it in a variable. i. Fetch the Genre and title of the movie having the entered id and store them inside two variables i. Display the fetched movie Genre and title. T T T T Paragraph v 3 (12pt) Arial T T O f. O Mashups HTHL CSS
Write the appropriate SQL query for each of the following questions: 1) Display details of ALL the clubs running by the college 2) Display the details of the IT club (IT is the name of the club)
Write the appropriate SQL query for each of the following questions: A) Display ALL the activities organized by the IT club B) Display the number of students who are acting in each club.
Database Programming
Consider the following relational schemaStudent (StudentID, SName, Major, level, age) Class (ClassCode, CName, Room, ProfID) Enrolled (StudentID, ClassCode) Professor (ProfID, ProfName, DeptID) Department (DeptID, DeptName) Write the SQL statements for the following queries: a) Find the class name and name of professor who teach each class. b) Find the names of all Professors who work in the Business department. c) Find the Class information of the classes that have more than 50 students enrolled. d) Find the names of all year level 3 students who are enrolled in a class taught by Professor John e) Find the student name, major, level, and average age for all of the students in each year level.
Write the appropriate SQL query for each of the following questions: Display the list of students who are involved in the IT club Display the details of all the activities that have taken place in 'Salalah Hall'
Given the following relation: Movie (MovieID, Title, Genre, Year) Write a PL/SQL block of code that performs the following tasks: Read a movie id provided by user at run time and store it in a variable. Fetch the Genre and title of the movie having the entered id and store them inside two variables Display the fetched movie Genre and title.
Part II (50 points, each problem is worth 5 points) Write SQL queries for the following database: id Customers name email id Categories name Ho Ho 8 Orders id customer_id B id Products category_id name price но HO Order_Product id order_id product_id quantity 1. Display all customers whose email is null or ends with 'fiu.edu' or 'gmail.com' 2. Display the number of orders placed by a customer whose name is ‘Jason Bourne' (assume there is only one customer with this name). 3. Insert a new product (category_id = 1, name = 'apple', price = 3.00) into the product table. Assume Products.id has a default value. 4. Create the Order_Product table as follows: id is the primary key and its data type is serial, quantity is an integer which doesn't allow null, order_id and product_id are foreign keys and will be set to null on delete. 5. Display the average price of all the products. For example, there are only three products in the database with a price of 7, 8 and 9. Then the average price would…

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