The Following Tables Form Part of a Database Held in a Relational

Question

Examlex · Accepted Answer

The Answer is (a)
(1)SELECT pubName
FROM Publisher
ORDER BY pubName;

(2)SELECT jobID
FROM BookJob b, Publisher p
WHERE b.pubID = p.pubID AND pubName = 'Gold Press';

(3) SELECT pubName, telNo
FROM BookJob b, Publisher p
WHERE b.pubID = p.pubID AND jobType = 'R';

(4)SELECT poID, poDate
FROM PurchaseOrder po, BookJob b, Publisher p
WHERE po.jobID = b.jobID AND b.pubID = p.pubID AND
pubName = 'Gold Press';

(5)SELECT creditCode, COUNT(*)
FROM Publisher
GROUP BY creditCode;

(6)SELECT jobType, COUNT(*)
FROM BookJob
GROUP BY jobType
HAVING COUNT(*) >= 3;

(7) SELECT AVG(price)
FROM Item;

(8)SELECT *
FROM Item
WHERE price < (SELECT AVG(price) FROM Item);

(b) CREATE VIEW PB (pubID, pubName, street, city, postcode, telNo)
AS SELECT p.pubID, pubName, street, city, postcode, telNo
FROM BookJob b, Publisher p
WHERE b.pubID = p.pubID AND jobType = 'R';

The Following Tables Form Part of a Database Held in a Relational

Essay

Correct Answer:
Verified

The Following Tables Form Part of a Database Held in a Relational

Essay

Correct Answer:VerifiedShow Answer

Correct Answer:
Verified