Consider the following schema: Suppliers (sid, sname, city) Parts (pid, pname, color) Catalog (sid, pid, price) Write relational algebra expressions for the following queries: a. Find the sids of suppliers and names who are located in Riyadh. b. Find the name of suppliers who are located in Riyadh and Jeddah. c. Find the names of supplier who supply part name “fog light”. d. Find the sids of suppliers who supply every part.

Consider the following schema: Suppliers (sid, sname, city) Parts (pid, pname, color) Catalog (sid, pid, price) Write relational algebra expressions for the following queries: a. Find the sids of suppliers and names who are located in Riyadh. b. Find the name of suppliers who are located in Riyadh and Jeddah. c. Find the names of supplier who supply part name “fog light”. d. Find the sids of suppliers who supply every part.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter8: Advanced Sql

Section: Chapter Questions

Problem 18RQ

See similar textbooks

Similar questions

Consider the following schema: Suppliers (sid, sname, city) Parts (pid, pname, color) Catalog (sid, pid, price) Write relational algebra expressions for the following queries: 1. Find the sids of suppliers and names who are located in Riyadh. 2. Find the name of suppliers who are located in Riyadh and Jeddah. 3. Find the names of supplier who supply part name “fog light”. 4. Find the sids of suppliers who supply every part. please only answer point number 4
Consider the following schema: Suppliers (sid, sname, city) Parts (pid, pname, color) Catalog (sid, pid, price) Write relational algebra expressions for the following queries: d. Find the sids of suppliers who supply every part.
Consider the following schema ,write the relational algebra queries for the following: Supplier(sid,name,address) Parts(pid,name,color) Catalog (sid,pid,cost) i)Find sid of supplier who supplies every part) ii)find the name of suppliers who supplies only red parts. iii) find the ID’s of suppliers who supplies only red parts. iv) find the sid of suppliers who supplies only red parts or are at 221 park street.
Consider the following schema and: Write relational algebra expression for the following queries. Draw the query tree for 3,6 and 10. 1. Find the product code, product name and price of all the products. 2. Find the total number of orders of each customer. 3. Find the total number of orders placed by customer “David”. 4. Find the customer numbers who have not placed any order. 5. Find the order number that includes all the products. 6. Find the customer name and check number of payments that are made between 1-2-2020 and 28-2-2020. 7. Find the cities where there is an office and customer as well. 8. Display the products name along with product description. 9. Find the employees who work in city “NY”. 10. Find the payment amount of orders that has status “confirmed”.
1.Consider the relation schema given in below fig. Design and draw an ER diagram that capture the information of this schema.(Analyse)(Apr/May 2017)Employee(empno,name,office,age)Books(isbn,title,authors,publisher)Loan(empno,isbn,date)Write the following queries in relational algebra and SQL.Find the names of employees who have borrowed a book published by McGraw-Hill.Find the names of employees who have borrowed all books published by McGraw-Hill.
translate the following ER diagram into the appropriate relational schema(s):
Question- Translate the following ER diagram into the appropriate relational schema(s):
Use the following business rule to create a Crow's Foot ERD that can be implemented in the Relational Model. A CUSTOMER may rent many DVD's in a movie rental company and a DVD can be rented by many CUSTOMER's. Show the primary and foreign keys in your entities.
Solve only 1,2,3 please fast. Consider the following scheme Supplier (sid, Sname, rating) Parts (Pid, pname, color) Catalog (sid. Pid, cost) The catalog relation lists the prices charged for parts by suppliers. Write the following queues in relational algebra. (i) Find name of suppliers who supply some red part. (ii) Find the sids of suppliers who supply some red part or green part (iii) find the sids of supplier who supply some red part and some green part (iv) Find the sids of supplier who supply every part (v) Find the sids of suppliers who supply every red part (vi) Find the pids of parts supplied by two different supplier. (vii) Find pair of sids such that the supplier with the first sid charges more for some part than the supplier with the second sid. (viii) Find the sid of supplier who supply most expensive part.
How do you make the relational schemas for this problems? I got all the other information. D.
Consider the following relational data model. Employee (empid, ename, address, title, headid) Works (Empid,Deptid,joindate) Department (Deptid, dname, block) Payment (title, salary) A) Write relational algebra for Display the employee name and department name of each employee. Display the employee who works as senior lecturer and belongs to BEI or BCT department. Display the employee name with corresponding department head. B) Write sql query for Creating the above relations; including appropriate versions of all primary and foreign key constraints Find the employee name and address whose address name ends with substring ‘pur’. Update the salary of senior lecturer by 25%.(Solve A - 1,2,3 only)
Please draw an relational ERD with multiplicities and all the attributes based on following description: ( Please identify the primary key in each entity.) An Adult Education Department runs various courses during the daytime and evenings, and at different times of the year. For example, ‘Spanish level 1’ is offered on Monday mornings, Monday evenings or Wednesday evenings, and runs over 25 weeks from October to March. On the other hand, ‘Introduction to Digging Up Your Ancestors’ only runs for 8 weeks, but is offered on Tuesday or Wednesday evenings from October to December, January to March, and April to June, with an optional field week in August. There is always a maximum number of places for each course offering, which is dependent on the individual teacher. For example, ‘Spanish level 1’ on Monday evenings may be limited to 20 places, but on Wednesday evenings the limit may be 25. Each course offering is only taken by one teacher, however teacher may take…

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS