The Schema of the relational data base, PUF, is: U UN, Uname, City) P (PN, Pname

Question

The Schema of the relational data base, PUF, is: U UN, Uname, City) P (PN, Pname, Color, Weight) F (FN, Fname, Status, City) PUF (PN, UN, FN, Quantity) describing the following facts: U: is a factory described by its UN number, its Uname name, the city City in which it is situated; P: is a product described by its PN number, its Pname name, its Color, and its Weight. F: is a supplier described by his FN number, his Fname name, his Status (subcontractor supplier, exclusive supplier, the City where he is situated; PUF: is the product of PN number that has been delivered to the factory of UN number by the supplier of number FN for a giving

Explanation / Answer

1)
SELECT FN,FNAME,CITY
FROM F
WHERE CITY = 'LONDON';
2)
SELECT PNAME,COLOR
FROM P,F,PUF
WHERE ((P.PN = PUF.PN) AND
   (F.FN = PUF.FN) AND
   (F.FN = 1));
3)
SELECT F.FN
FROM P,U,F,PUF
WHERE ((P.PN = PUF.PN) AND
   (F.FN = PUF.FN) AND
   (U.UN = PUF.UN) AND
   (P.COLOR = 'RED') AND
   (U.UN = 1));
4)
SELECT P.PN
FROM P,U,F,PUF
WHERE ((P.PN = PUF.PN) AND
   (F.FN = PUF.FN) AND
   (U.UN = PUF.UN) AND
   (U.CITY = 'LONDON') AND
   (F.CITY = 'LONDON'));

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.