2. Part 2 nsider the following database with the below relations: customer-id customer-name 192-83-7465 Johnson 019-28-3746 Smith 677-89-9011 182-73-6091 321-12-3123 Jones 336-66-9999 Lindsay 019-28-3746 Smith Hayes Turner (a) The customer table account-number balance A-101 500 A-215 700 A-102 400 A-305 350 A-201 900 A-217 750 A-222 700 (b) The account table customer-street 12 Alma St. 4 North St. 3 Main St. 123 Putnam Ave. 100 Main St. 175 Park Ave. 72 North St. 34 customer-city Palo Alto Rye Harrison Stamford 336-66-9999 019-28-3746 Harrison Pittsfield Rye customer-id account-number 192-83-7465 A-101 192-83-7465 A-201 019-28-3746 A-215 677-89-9011 A-102 182-73-6091 A-305 321-12-3123 A-217 A-222 A-201 (c) The depositor table What is the difference between SQL and relational algebra? In SQL Environment, what is the difference between DDL and DML Write the Relational algebra expressions (using the relational algebra operators: p, a. ,X) for each of the following queries' a. List the id and name of all customers p. List all information about customers from Harrison C. List the customer_id, account_number and balance for all account.

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
icon
Related questions
Question
2. Part 2
Consider the following database with the below relations:
customer-street
12 Alma St.
4 North St.
3 Main St.
123 Putnam Ave.
100 Main St.
175 Park Ave.
72 North St.
(a) The customer table
customer-id customer-name
Johnson
192-83-7465
019-28-3746 Smith
677-89-9011
Hayes
Turner
182-73-6091
321-12-3123
Jones
336-66-9999 Lindsay
019-28-3746
Smith
account-number balance
A-101
500
A-215
700
A-102
400
A-305
350
A-201
900
A-217
750
A-222
700
(b) The account table
34
customer-city
Palo Alto
Rye
Harrison
Stamford
677-89-9011
182-73-6091
321-12-3123
336-66-9999
019-28-3746
Harrison
Pittsfield
Rye
customer-id account-number
192-83-7465
A-101
192-83-7465
A-201
019-28-3746
A-215
A-102
A-305
A-217
A-222
A-201
(c) The depositor table
What is the difference between SQL and relational algebra?
In SQL Environment, what is the difference between DDL and DML
Write the Relational algebra expressions (using the relational algebra operators: P, σ, π,
▷, X) for each of the following queries '
a. List the id and name of all customers
b. List all information about customers from Harrison
c. List the customer_id, account_number and balance for all account.
Transcribed Image Text:2. Part 2 Consider the following database with the below relations: customer-street 12 Alma St. 4 North St. 3 Main St. 123 Putnam Ave. 100 Main St. 175 Park Ave. 72 North St. (a) The customer table customer-id customer-name Johnson 192-83-7465 019-28-3746 Smith 677-89-9011 Hayes Turner 182-73-6091 321-12-3123 Jones 336-66-9999 Lindsay 019-28-3746 Smith account-number balance A-101 500 A-215 700 A-102 400 A-305 350 A-201 900 A-217 750 A-222 700 (b) The account table 34 customer-city Palo Alto Rye Harrison Stamford 677-89-9011 182-73-6091 321-12-3123 336-66-9999 019-28-3746 Harrison Pittsfield Rye customer-id account-number 192-83-7465 A-101 192-83-7465 A-201 019-28-3746 A-215 A-102 A-305 A-217 A-222 A-201 (c) The depositor table What is the difference between SQL and relational algebra? In SQL Environment, what is the difference between DDL and DML Write the Relational algebra expressions (using the relational algebra operators: P, σ, π, ▷, X) for each of the following queries ' a. List the id and name of all customers b. List all information about customers from Harrison c. List the customer_id, account_number and balance for all account.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Dataset
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
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education