St Xaviers College Database Concept Questions

User Generated

zvpunrynyyra

Computer Science

ST Xaviers College

Description

Unformatted Attachment Preview

HW #2 Select two tables (not from the textbook) to demonstrate the following queries. (Query 1) – (Query5): Relational Algebra (Query 6) – (Query 7): Relational Calculus (QUERY 1) Build a query consisting SELECT (sigma) operation(s) and show the result set. (QUERY 2) Build a query consisting PROJECT (pi) operation(s) and show the result set. (QUERY 3) Build a query consisting union operation and show the result set. (QUERY 4) Build a query consisting intersection operation and show the result set. (QUERY 5) Select two tables and build a query consisting division operation. Show the result set. (QUERY 6) Rewrite (Query 1) using Tuple Relational Calculus. (QUERY 7) Rewrite (Query 2) using Domain Relational Calculus.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi ;). Here is your assignment :). Let me know if you need more help ;)

1

HW #2
Chosen table
Employee_ID
00001
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015

name
Lee
Chiu
Careen
Kim
Ben
Kyle
James
Anna
Gem
Ken
Lim
Coe
Mathew
Rose
Kyla

dept_name
Accounting
Music
Marketing
Shipping
Executive
IT
Contracting
Operations
Payroll
Operations
Accounting
Finance
Operations
Benefits
Operations

wage
66,000
65000
70000...

Similar Content

Related Tags