Consider the tables given below and write the relational Algebra for the following tasks Table Name: Products ProductID ProductName Unit Price SupplierlD 1 Chais 10 boxes x 20 bags 18 1 Chang 24 - 12 oz bottles 19 1 3. Aniseed Syrup 12 - 550 ml bottles 10 1 4 ChefAnton's Cajun Seasoning 48 - 6 oz jars 22 Table Name: Suppliers SupplierID SupplierName ContactName Address City 1 Exotic Liquid Charlotte 49 Gilbert St. Londona Сооper New Orleans Cajun Shelley Burke P.O. Box 78934 New Delights Orleans Grandma Kelly's Regina Murphy 707 Oxford Rd. Ann Arbor Homestead 4 Tokyo Traders Yoshi Nagase 9-8 Sekimai Tokyo Musashino-shi A. Write the Relational algebra for the following questions. i. Find all the information of products whose price is from 15 to 25 inclusively. ii. Find the lowest price of products for each supplier ID. iii. Find ID, name and address of suppliers whose city is Tokyo. B. Convert the following SQL statements to Relational Algebra expressions: i. Select * From Products Where SupplierlD in (1,2,3); ii Select ProductID, ProductName From Products Where Price between 10 and 20; 21

Consider the tables given below and write the relational Algebra for the following tasks Table Name: Products ProductID ProductName Unit Price SupplierlD 1 Chais 10 boxes x 20 bags 18 1 Chang 24 - 12 oz bottles 19 1 3. Aniseed Syrup 12 - 550 ml bottles 10 1 4 ChefAnton's Cajun Seasoning 48 - 6 oz jars 22 Table Name: Suppliers SupplierID SupplierName ContactName Address City 1 Exotic Liquid Charlotte 49 Gilbert St. Londona Сооper New Orleans Cajun Shelley Burke P.O. Box 78934 New Delights Orleans Grandma Kelly's Regina Murphy 707 Oxford Rd. Ann Arbor Homestead 4 Tokyo Traders Yoshi Nagase 9-8 Sekimai Tokyo Musashino-shi A. Write the Relational algebra for the following questions. i. Find all the information of products whose price is from 15 to 25 inclusively. ii. Find the lowest price of products for each supplier ID. iii. Find ID, name and address of suppliers whose city is Tokyo. B. Convert the following SQL statements to Relational Algebra expressions: i. Select * From Products Where SupplierlD in (1,2,3); ii Select ProductID, ProductName From Products Where Price between 10 and 20; 21

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter11: Database Performance Tuning And Query Optimization

Section: Chapter Questions

Problem 21P: Problems 1721 are based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM...

See similar textbooks

Similar questions

Problems 2224 are based on the following query: SELECT P_CODE, P_DESCRIPT, P_PRICE, P.V_CODE, V_STATE FROM PRODUCT P, VENDOR V WHERE P.V_CODE = V.V_CODE AND V_STATE = 'NY' AND V_AREACODE = '212' ORDER BY P_PRICE; Write the command(s) used to generate the statistics for the PRODUCT and VENDOR tables.
Problems 1721 are based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM VENDOR WHERE V_STATE = 'TN' ORDER BY V_NAME; Assume that you have 10,000 different products stored in the PRODUCT table and that you are writing a web-based interface to list all products with a quantity on hand (P_QOH) that is less than or equal to the minimum quantity, P_MIN. What optimizer hint would you use to ensure that your query returns the result set to the web interface in the least time possible? Write the SQL code.
Consider the following Account table and express in Relational Algebra each of the questions below: accountID amount accountType customerID ac200 5000 current 100 ac201 8800 Saving 104 ac202 3900 current 103 ac203 2000 current 101 ac204 15700 Saving 105 ac205 9655 Saving 106 List the details of all the accounts of type ‘Saving’. Find the balance amount of the account that is owned by the customer whose id is 106. List the ids of customers who own an account of type “current” and its balance amounts is less than 7000 Omani rials.
Consider the following schema for STUDENT- Student (RollNo, Name, City, Father-Name, Branch, Sem, Per) Write the following queries in Relational Algebra: (i) List the records of students. (ii) List the records such students whose city is Mbd. (iii) List the records of those students whose Percentage marks is more than 75%. (iv) List the records of those students whose Percentage marks is less than 40%. (v) List the records of those students whose Percentage marks between 80 to 90%. (vi) Show student’s name and City and branch who live in Delhi. (vii) Show student’s RollNo, Name and Sem whose Percentage Mark is more than 80%. Plz try to give solution of this question within 1hrs as it is very urgent plzz....
Consider the following relational schema, and answer the following questions by writing relational algebra queries: Employee (EmpID, City, Zipcode) Works (EmpID, CorpID, Salary) Corporation (CorpID, City) Manages (EmpID, MngrID) a. Find the ID of all employees who work for Amawig Corporation. b. Find the ID and City of all employees who work for Amawig. c. Find the ID and City of all employees who work for Amawig corporation and earn more than $100,000. d. Find the IDs of all employees who live in the same city as the corporation for which they work. e. Find the ID of all employees who live in the same area (zipcode) as do their managers. f. Find the IDs of all employees who earn more than every employee in the Amawig Corporation. g. Suppose that the corporations may have more than a branch in different cities. Find all corporations located in every city in which Amawig Corporation is located.
Material : Relational Algebra Course : Database Systems Create a Relational Algebra From Entity Relational Diagram (ERD) Below for:a) Displays books published in the last 5 years from 2020.b) Displays details of customers who have done shopping (using the Join operator)c) Displays email customers who have done shopping (using the Set operator)d) Displays the ISBN book that has never been purchased (using the Set operator)
Consider the following relational schema and answer the following questions. Employee (Employee_Id, First_Name, Last_Name, Email, Phone_Number, Hire_Date, Job_Id, Salary, Commission_Pct, Manager_Id, Department_Id) a. Write a query to find the manager ID and the salary of the lowest-paid employee for that manager. b. Write a query to get the department ID and the total salary payable in each department. c. Write a query to get the average salary for each job ID excluding programmer. d. Write a query to get the total salary, maximum, minimum, average salary of employees (job ID wise), for department ID 90 only.
QUESTION 9 Consider the following Grades table and express in Relational Algebra each of the questions below: Grades StudentId CourseCode Semester Grade 1001 ITDR3101 FL20 B 1002 ITSW3104 FL20 A 1003 ITGP4101 SP20 A 1001 ITDR2106 SP21 C List the grades of students who studied the course having the code “ITDR2106” in the semester “FL20”. List the details of students who didn't get the grade ‘A’ in any course. List the ids students who got the grade ‘B’ in ‘SP20’ semester.
Consider the following Account table and express in Relational Algebra each of the questions below: accountID amount accountType customerID ac200 5000 current 100 ac201 8800 Saving 104 ac202 3900 current 103 ac203 2000 current 101 ac204 15700 Saving 105 ac205 9655 Saving 106 a. List the details of all the accounts of type ‘Saving’. ( . . . . . . . . . . . . . . ) b. Find the balance amount of the account that is owned by the customer whose id is 106. ( . . . . . . . . . . . . . . ) c. List the ids of customers who own an account of type “current” and its balance amounts is less than 7000 Omani rials. ( . . . . . . . . . . . . . . )
Consider the following schema and write the following queries in relational algebra. Product(pid, pname, pcolour, price, supplier, year_manufacture) Select the records where product is 'shoes'. Select the records where product colour is 'red' and 'price' is 450. 3. Select records from Product table where supplier is 'Davidson' and price is 500 or those products manufactured after 2018 . 4.Project the columns named as pid and supplier from the Product table.
Run the problem using Relational Algebra, below the problem I added the needed table. Use self join find the answer (4) Find the name (fname,lname) of the direct supervisor of “Mary Smith”. (“Mary Smith” is an employee). group: emplyeeemployee = {fname, lname, ssn,superssn, departnumber'Mary', 'Smith',111, 222, 11'Green', 'Marjorie',333, 222, 12'Gren', 'Cheryl',222, 777, 14}
Transcribed Image Text Based on the following table, write the relational schema that meets 1NF, 2NF and 3NF requirements. You are required to draw the dependency diagram for 2NF. TABLE 6: CUSTOMER-SHARE RECORDS SAMPLE | CompanyNo | CustiD CustName Brokerl 122 Ali CompanyType DateBought Share BoughtPrice |Dividend |Consumer Products 23/7/2009 450 BrokerName CompanyName Nestle (M) Sơn. Bhd. |Cheetah Holdings Sdn. Bhd. Properties Victory Manufacturing Sdn. Bhd |Manufacturing Berjaya Hotel Sdn. Bhd. Cheetah Holdings Sdn. Bhd. Properties |Berjaya Hotel Sdn. Bhd. Nestle (M) Sơn. Bhd. B22 Melaka Securities 23 0.80 1.10% 1/9/2009 100 15/10/2010 20/1/2011 30/5/2009 19/4/2010 45 2.00 2.00% 301 Mary B12 Kuala Lumpur City Securities 50 0.50 0.50% 11 21 Hotel 220 0.50 1.00% 45 50 3.10 2.00% 1001 Jeffry Hotel |Consumer Products 10/8/2011 | 1000 822 Melaka Securities 21 50 1.80 1.00% 23 1.20 1.10%

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