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 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

Related questions

Q: Product Name Sales Rep Country Product 1 Paul China Product 1 Paul Singapore Product 1 John…

A: A sorting algorithm is defined as the algorithm that puts elements of a list into an order as…

Q: For the below given schema diagram develop a SQL query to find the guest name whose total bill…

A: According to the given problem statement we are required to develop a SQL query to find the guest…

Q: Write a SQL statement that displays the customer code, customer first name, customer last name and…

A: SELECT Cus_Code, Cus_FName, Cus_LName, Cus_Balance AS Amount Owed FROM CUSTOMER ORDER BY Cus_Code;

Q: and express in Relational Algebra each of the questions below: Grades StudentId CourseCode…

A: Q9.

Q: List the grades of students who studied the course having the code “ITDR2106” in the semester…

Q: Find the numbers that has not been used as DEPTNO in the DEPT table.

A: you can use this query

Q: Please convert following figure into a relational schema. In each table, the primary key and foreign…

A: Here entity branch is a weak entity and therefore it will include primary key of bank as prime…

Q: key and foreign keys (arrows) must be identified. Code BANK Name Addr Phone BRANCHES Acct no San…

A: Here the entity BankBranch is a weak entity and therefore we need to include primary key of Bank as…

Q: Analyze the given tables showing the information of different candidates and departments. You are…

A: => here in the question given 2 tables one is Candidates and other one is Departments

Q: 97. The column header of table in relational model terminology is classified as a. attribute b.…

A: The answer is given below.

Q: Using the below given relational schema develop a SQL query to find out the name of the town having…

A: What is SQL: SQL is a standard language for accessing and manipulating databases. SQL stands for…

Q: CREATE A SQL QUERY FROM QUESTION BELOW: List the name of the division that has more than one…

A: A query is to retrieve the data and execute it using commands. The subquery is defined as a query…

Q: write one relational algebra statement to show the cities and the number counts of staffs in each…

A: Relational algebra statement: RELATIONAL pure mathematics could be a wide used procedural command…

Q: Note: please make sure to draw if required and please double check the answer

A: The relationship between Order and Product is many to many. So we need to create a new relation…

Q: Compute the average number of hours for the courses offered by each college.

A: Below i have written the query:

Q: Given the following Staff2 table, please write a SQL statement to find the superno who supervised 4…

A: To find the superno where COUNT(superno) is greater than or equal to 4.

Q: raw ERD for these tabels The system must contain tables such as category(catNo,catogeryName)…

A: ERD diagram:

Q: DATABSE

A: Here the entity BankBranch is a weak entity and therefore we need to include primary key of Bank as…

Q: Write the following subqueries for these statements in SQL using this ERD diagram 1.…

A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: Using the below given relational schema develop a SQL query to find out the name of the town having…

A: As per the given problem statement we are required to develop a SQL query to find out the name of…

Q: Please convert following figure inn a relational schema, In cach table, the primery key and foreign…

A: Here the entity BankBranch is a weak entity and therefore we need to include primary key of Bank as…

Q: Consider the table (employee) below: Emp_qualification Dept_id BSc, A01 Emp_no Emp_name Dept_name…

Q: QUESTION 8 Answer All the questions: Consider the below Student table and write the appropriate…

A: Relational algebra query to display the details of students who study programming course and also…

Q: Please convert following figure into a relational schema. In each table, the primary key and foreign…

A: Here the entity BankBranch is a weak entity and therefore we need to include primary key of Bank as…

Q: Table name: EMPLOYEE EMP CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP DOB STORE_CODE 1 Mr.…

A: We are going to write relation schema for EMPLOYEE and STORE relations and will also show…

Q: a) Your task is to write a SQL query to find count of employee who does not have a manager in the…

A: SQL query output is given in step2.

Concept explainers

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.

Question

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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

A (i): Select the information of the product where priice is >= 15 or <=25 from relation products

VIEW

A(ii): Aggregate All Supplier ID and calculate min price of each from relation products

VIEW

A(iii): Project SupplierID, SupplierName, Address where city is Tokyo from Relation Suppliers

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Three tables are given Student: studentNO, firstName, lastName, studentProgram Professor: professorID, professorProgram, professorName Student_professor: studentNO, professorID, mentor Complete the following requirements: Using the UNION operator, do a full outer join to display the student last name student program, professor name and professor program. Referring to the model created in step 2, determine the PK/FK relationships to build the SQL joining the three Create a query/subquery to display student first name, last name and program. The student program must be same as that in the professor table and the professor program name starts with a ‘C’. This query will use a subquery and not a join.
Find the minimum number of tables required to represent the following given ER diagram in relational model. b_city (b_name Ac_no Balance Assets Account branch Account Branch Depositor Loan branch Customer Borrower Loan c_city C_street Lno Amt C_name ID
Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).
I need C please
Data normalisation
Thank you for helping! Write the SQL code to produce the total number of hours and charges for each of the projects represented in the ASSIGNMENT table. The result is shown as below. Write the SQL code to display the information of employees who are working as either programmer or system analyst. Write the SQL code to produce job_descriptions(job_title) of employees who are working at project ‘Evergreen’.
Find the minimum number of tables required to represent the given ER diagram in relational model- Ac_no Balance b_city b_name Assets Account Account Branch branch Depositor Loan branch Customer Borrower Loan C_city C_street L_no Amt C name
Question 3 refers to two data tables giving the details of a company's employees and company's job titles, called EMP and JOB respectively, which have the following format: Table EMP Column name Column type Integer Up to 10 characters Example entry Description Employee ID number Employee surname EMPNO 7369 ΕΝΑΜΕ SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager Date employment started Monthly salary HIREDATE Date 17/12/1980 SAL Integer 1600 Table JOB Column type Integer Up to 15 characters Column name Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN b) Using EMP and JOB tables, give an example of the JOIN SQL statement which uses "WHERE", "GROUP BY", “HAVING" and “ORDER BY" clauses. Explain the result table of the SQL statement. (Maximum 300 words).
16. please use the picture below to answer the following question Write a SQL statement to display Invoice Number and total sale for each Invoice.
Write the resulting relations based on the following ER diagram Like_Group N Customer N name N name address Group Like_Artist amoun t N name Classify Artist year N birthplace 1 title style age type Artwork N Paints price