Question

Task 4 Consider the tables given below and write the relational Algebra for the following tasks: (30 Marks) Table Name: Products ProductID Product Name 1 Unit Price Supplier 10 boxes x 20 bags 181 24 - 12 oz bottles 191 12-550 ml bottles 10 1 2 Chang Aniseed Syrup MEC AMO_TEM OM ON Fundamentals of Relational Database Management Systems (COMP 20002) - Spring-2020 -CW Assignment - ALL-OP 4 ChefAnton's Cajun Seasoning 48-6 oz jars 22 2 Table Name: Suppliers Supplier SupplierName Contact Name Address 1 Exotic Liquid Charlotte 49 Gilbert St. Londona Cooper 2 New Orleans Cajun Shelley Burke P.O.Box 78934 New Delights Orleans 3 Grandma Kelly's Regina Murphy 707 Oxford Rd. Ann Arbor Homestead 4 Tokyo Traders Yoshi Nagase Sekimai Tokyo Musashino-shi A. Write the Relational algebra for the following questions. (3x6 Marks = 18 Marks) 1. 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 ii. Find ID, name and address of suppliers whose city is Tokyo B. Convert the following sal statements to Relational Algebra expressions (2x 6 Marks 12 Marks 1. Select From Products Where Supplieri in (1,2,3); ii Select ProductID, Product Name From Products Where Price between 10 and 20.

Answer 1

PLEASE LIKE THE ANSWER, IT HELPS A LOT