Using the Schema - data/statistics. Transform following SQL queries intoRelational Algebraic queries.ItemsSalesID|_NamePriceSupplierS DateSID1CIDKetchup50Block Factory2012-5-2312012-5-242016-4-232016-2-122016-1-10222Salt40UniqueManufacturerS&s45364Soap301International4Toothpaste33BrothersEnterpriseGeneralSugar20BillTraders6Detergent34AlibabaSID1ID1Express1231Customer4CIDNameCity1AqibLahore22.SulemanPeshawar233NadeemSahiwal2PeshawarPeshawarOkaraPeshawar434SarimSohail436.Nadir42Nasir448.KamalLahorea) Select * from Items i, Bill b, Sales s, Customer c where c.City='Peshawar'b) Select c.Name from Customer c inner join Sales s on s.CID=c.CID inner joinBill b on s.SID=b.SIDc) (Select * from Customer) Except (Select c.* from Customer c inner join Saless on c.CID=s.CIID)d) Select * from Customer where City='Sahiwal' or City='Peshawar'e) Select I_Name from Items I, Bill b where ID in(1,4,2)

Required : SQL query to relational algebra query Note : As per guidelines of company, we are…

Answered: Using the Schema - data/statistics.…

Engineering

Computer Science

Using the Schema - data/statistics. Transform following SQL queries into Relational Algebraic queries.

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: Compare two versions of SQL to which you have access, such as Microsoft Access and Oracle SQL*Plus.…

A: Dissimilairities: MySQL: MySQL is an open-source relational database management system. Just like…

Q: Create the following SQL queries using the university schema as a point of reference. Find the…

A: SQL stands for the structure query language. SQL manipulates, stores, and retrieves data from the…

Q: WHY DO I get this error:SELECT TOP(3) p.name FROM publisher p ERROR at line 5: ORA-00923: FROM…

A: TOP command does not work in Oracle.

Q: Read about PL/SQL, Explain it with an example - one page

A: Given:

Q: Answer the given question with a proper explanation and step-by-step solution. Using SQL Server…

A: In this question we have to write a SQL Based Query using SQL server and the AdventureWorks2012…

Q: True or False? SQL stands for Structured Questioning Language

A: The answer is false.

Q: In SQL: Explicit Cursors also have Attributes. Name one of the four explicit cursor attributes and…

A: Indeed, Explicit cursors in database systems have attributes that will describe the behavior of the…

Q: Formulate the following SQL query as a relational algebra expression. SELECT pno AS Projektnummer,…

A: SELECT pno AS Projektnummer, SUM(salary) AS Projektkosten FROM department, project WHERE pno =…

Q: Consider the following schema: Publisher (name, phone, city), PK: name. Book (ISBN, title, year,…

A: select b.title from Book b inner join (select e.bISBN from Edit e group by e.eSSN having count(*)…

Q: List and explain 3 types of Joins in T-SQL.

A: As per the given question we have to list and explain 3 types of Joins in T-SQL.

Q: Write down the different methods used to send SQL command to the database.

A: SQL Commands: SQL is Structured Query Language It is domain-specific language for querying data in…

Q: Write an appropriate SQL query to list the lecturers that teach more than one module.

A: We need to write a SQL query for the given scenario.

Q: a) name of the advisor of the student who takes highest number of courses?

A: According to the question we have to find the student id who takes the highest no of courses: SELECT…

Q: 7. What is the difference between CHAR and VARCHAR2 datatype in SQL?

A: In SQL the CHAR and VARCHAR2 datatypes are mainly used to store data containing characters. we will…

Q: Write SQL server query to retrieve all the students who have grade A and are in class 12 Student…

A: SELECT * FROM STUDENT WHERE GRADE = 'A' AND CLASS = 12;

Q: I need help with the SQL query for the following question: 1. Get the total number of reviews of…

A: The details about the table are given with table name and different entities. Here the table name is…

Q: Write single-table queries using SQL commands.

A: Steps to write single query: SELECT col1, col2, ... FROM table_name; SELECT * FROM table_name;

Q: Region, MaxCapacity) ate, CodH, Dose num, Colla L language:

A: Example of the customer, truck, city and shipment Creating table create table customer(cust_id…

Q: What is the best way to utilise one in a SQL query?

A: Asked: What is the best way to utilise one in a SQL query

Q: the HR department needs the department name, manager first name, manager last name, and job title.…

A: SQL: SQL stands for Structuref Query Language. It is used to access and manipulate the database…

Q: query in relational algebra to find the ID and the brand of those trucks whose type is S.

A: It is procedural query language. It collects instance of relation as input and fives occurrences of…

Q: Vhich of the following statements is correct? In a SELECT statement with WHERE and GROUP BY, groups…

A: SQL is structured query language which follows a set of rules before execution of query. It's…

Q: get PL/SQL language to operate correctly in MySQL

A: get PL/SQL language to operate correctly in MySQL

Q: Show the total number of reviews of most liked product per retailer in every city Here is the…

A: The details about the table are given with table name and different entities. Here the table name is…

Q: I need help with the SQL query for the following question: 1. Get show the total number of customers…

A: CREATE TABLE Reviews( Product_ModelName text, Product_Category text, Product_Price…

Q: Please give a detailed answer and code examples for all the questions. What are the types of SQL…

A: What is a SQL join A SQL Join is a special form of generating a meaningful data by combining…

Q: Table Name Column Names REGIONS REGION_ID, REGION_NAME COUNTRIES COUNTRY_ID, COUNTRY_NAME, REGION_ID…

A: Given: To find out each manager's work address. Note that a manager's work address is the same as…

Q: Given the following relational tables Patient (SSN, Name, Surname, DateOfBirth, Gender) Vaccine…

A: Let's understand step by step : 1. Given 4 tables : 1. Patient ( SSN , Name , Surname ,…

Q: What is the correct SQL statement to perform a query to find the names of all instructors excluding…

A: Query to exclude duplicates The duplicates can be excluded by using the Distinct keyword. The…

Q: In SQL, create Object-Identity and Reference Types

A: Introduction: Use REF(type-name) in a SQL query, where type-name denotes the referenced type. In…

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

Using the Schema - data/statistics. Transform following SQL queries into
Relational Algebraic queries.
Items
Sales
ID
|_Name
Price
Supplier
S Date
SID
1
CID
Ketchup
50
Block Factory
2012-5-23
1
2012-5-24
2016-4-23
2016-2-12
2016-1-10
2
2
2
Salt
40
Unique
Manufacturer
S&s
4
5
3
6
4
Soap
30
1
International
4
Toothpaste
33
Brothers
Enterprise
General
Sugar
20
Bill
Traders
6
Detergent
34
Alibaba
SID
1
ID
1
Express
1
2
3
1
Customer
4
CID
Name
City
1
Aqib
Lahore
2
2.
Suleman
Peshawar
2
3
3
Nadeem
Sahiwal
2
Peshawar
Peshawar
Okara
Peshawar
4
3
4
Sarim
Sohail
4
3
6.
Nadir
4
2
Nasir
4
4
8.
Kamal
Lahore
a) Select * from Items i, Bill b, Sales s, Customer c where c.City='Peshawar'
b) Select c.Name from Customer c inner join Sales s on s.CID=c.CID inner join
Bill b on s.SID=b.SID
c) (Select * from Customer) Except (Select c.* from Customer c inner join Sales
s on c.CID=s.CIID)
d) Select * from Customer where City='Sahiwal' or City='Peshawar'
e) Select I_Name from Items I, Bill b where ID in(1,4,2)

Expert Solution

This question has been solved!

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

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2 : Relational algebra query symbols

VIEW

Step 3 : a,b,c

VIEW

Step by step

Solved in 3 steps with 1 images

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

Explain Common Java-to-SQL Mappings?
Define “correlated subqueries”.
Table Schema: Amazon_Item (P#, P_NAME, SELL_PRICE, QTY) Amazon_Supply (S#*, P#*, SUP_PRICE) Amazon_Supplier (S#, S_NAME, CITY) Consider the above schema and develop a SQL query for the below given scenario: b) Find the product name, selling-price, and supplier-price offered by amazon_supplier in the city of 'Amsterdam'.
Compare two SQL versions that you have access to, such as Microsoft Access and Oracle SQL*Plus. Find at least five similarities and three differences between the SQL code from these two SQL systems. Do the differences lead the findings to differ?
using APEX - SQL Using HR Schema, write a query to find first name, last name and department ids for employees in departments in which they have a colleague whose first name is 'John'
Define NULL,BLANK AND zero in sql.
1. Find out each manager's work address. Note that a manager's work address is the same as the address of the department which s/he manages. • Address Format: Street_AddressPostal_Code CityCountry_Name • Write query in oracle sql.
QI/ Using the following schema, answer the following SQL queries: Product(P_code,P_name, P_price, P_quantity, vend_name) Vender(vend code, vend fname, vend_areacode, vend salary, vend_nationality) find the names of products that owned by vender "smith" and not owend by vender "dan." 1- find the name, price and quantity of product that has code 34657 and owned by spanish venders. 2- 3- Find the name of iraqi venders who has salary less than the average salary of venders. Find the prodect name that their quantity greater than 17 and oreder them by vender name. 4- 5-add new column to the product table called p_company.
True or false. Is it possible use two columns as primary key is SQL?
Explain DDL, DML SQL command with example.