Transform the query into a query on fragments

Assignment Help Basic Computer Science

Reference no: EM13283355

Transform the query into a query on fragments.

Fragmentation

PROJ1 = SEL(LOC = "New York") PROJ
PROJ2 = SEL(LOC != "New York") PROJ
ASG1 = ASG SEMIJOIN PROJ1 (PNO)
ASG2 = ASG SEMIJOIN PROJ2 (PNO)
EMP1 = SEL(TITLE = "Elect. Eng." OR "Syst. Anal.") EMP
EMP2 = SEL(TITLE = "Mech. Eng." OR "Programmer") EMP

SELECT ENAME, TITLE
FROM ASG, EMP, PROJ
WHERE EMP.ENO = ASG.ENO
AND ASG.PNO = PROJ.PNO
AND BUDGET > 200000
AND (RESP = "Manager" OR RESP = "Consultant")

Reference no: EM13283355

Questions Cloud

The enourmous amounts of money : Enthusiastic speakers spoke to us about the enourmous amounts of money

What is gained by increasing the rotation speed of a disk : 1. What is gained by increasing the rotation speed of a disk or a CD?

Electronic communications privacy act ecpa : Electronic Communications Privacy Act (ECPA)

How the different tasks will play a part in future career. : How the different tasks will play a part in your current position or future career.

Transform the query into a query on fragments : Transform the query into a query on fragments.

Create a local area network : Create a local area network (LAN) design diagram of the current network that describes the hardware and software resources that Matt described.

Wireless access points in your company''s warehouse : As the Project Manager, you have been assigned a project to deploy ten (10) wireless access points in your company's warehouse and break room within the next ninety (90) days. You are free to make assumptions that satisfy the scope of the proje..

To ensure the security of the files used by the new web site : To ensure the security of the files used by the new Web site, files need to access controls that limit which users can view and execute them. To further your understanding of file permissions, describe in detail these 5 file listings, explain a..

From the analog to the digital age : From the Analog to the Digital Age

User Account

All Pages