DATABASE ASSIGNEMNT 1

[vinthony]

5.2

8.1

FALSE

8.2

SELECT  ENAME, PNAME
FROM   EMP, ASG, PROJ
WHERE  
(DUR>12
AND    EMP.ENO=ASG.ENO
AND    ASG.PNO=PROJ.PNO
AND    TITLE=”Elect.Eng.”)
OR 
(DUR>12
AND    EMP.ENO=ASG.ENO
AND    ASG.PNO=PROJ.PNO
ASG.PNO<”P3”)

8.6

SELECT BUDGET
FROM ASG,PROJ
WHERE ASG.PNO = PROJ.PNO
AND EMP.ENO = ASG.ENO
AND ASG.PNO > “P2”
AND ASG.PNO = “P4”

8.7

SELECT RESP,BUDGET
FROM ASG,PROJ
WHERE ASG.PNO = PROJ.PNO
AND PNAME = “CAD/CAM”
AND (ASG.PNO<=”P2” OR (ASG.PNO>”P2” AND ASG.PNO<=”P3”) OR ASG.PNO>”P3”)