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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Task 4: Consider the tables given below and write the relational Algebra for the following tasks: Table Name: Products \begin{tabular}{|1|11|1|1]} \hline ProductiD & Product Name & Unit & Price &...

Task 4: Consider the tables given below and write the relational Algebra for the following tasks: Table Name: Products \begin{tabular}{|1|1|1|1|1|} \hline Productid & Product Name & Unit & Price &...

Exp19_Access_Ch02_Capstone - International Foodies 1.0 Project Description: International Foodies is an importer of exotic foods from all over the world. You landed a summer internship with the...

2 a all questions 2) Consider the tables given below. Table Name: Vegetables (V) Veg_ID Veg_Name Veg. Aty Veg.Price Veg Suppliers 1 Cucumber 10 boxes 3 1 2 Carrot 24 packets 2 1 3 Tomato 20 boxes 15...

Consider the following tables and: Write the relational algebra statements to answer EIGHT of the given queries, to be selected as follows: 3 from Part-1 (Easy) 4 from Part-2 (Moderate) 1 from Part-3...

Northwind Database Query Tool Create a JavaFX program to allow a user to query the Northwind database. You should be able to perform the following functionality using the program: Print order total...

TIME LIMIT!! Figure 1. Sample SQL table. Only the top 5 hoses of records in the table. Too much Consider that you are registered. Table name Products Questions 1. The part given in Figure 1 is given...

SQl plz solve this question 2) Consider the tables given below. Table Name: Vegetables (V) Veg_ID Veg_Name Veg_Qty Veg_Price Veg_Supplieri 1 Cucumber 10 boxes 3 1 2 Carrot 24 packets 2 1 3 Tomato 20...

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

54. Suppose the demand for lawnmowers goes down when the price of gasoline goes up. We can say that these two goods are: O substitutes O perfect substitutes unrelated goods. complements

Refer to Exercise 7.21. Find the probability that the sample mean is greater than 55. Exercise 7.21 A random sample of size n = 49 is selected from a population with mean = 53 and standard deviation...

13. Th ere are at least two attorneys in the offi ce. All attorneys are professionals. Th ere are at most two professionals in the offi ce. Th erefore, there are exactly two professionals in the offi...

Chloe's Cafe bakes croissants that it sells to local restaurants and grocery stores. The average costs to bake the croissants are $0.60 for 3,700 and $0.55 for 7,400. Required: If the total cost...