Question 1

Question 2.

Question 3 (A).

1. SELECT * FROM Item WHERE Item Description = Widgets GIVING Temp 1
2. JOIN Temp 1AND Vendor CatalogOVER Item No.GIVING Temp 2
3. SELECT * FROM Temp 2 WHERE Catalog Price < £ 50 GIVING Temp 3
4. JOIN Temp 3 AND Purchase Order OVER Vendor No. GIVING Temp 4
5. JOIN Temp 4 AND Purchase Order Line OVER P.O. Number GIVING Temp 5
6. JOIN Temp 5 AND Vendor No. GIVING Temp 6
7. PROJECT Temp 6OVER Vendor Name, Vendor Address GIVING Result

Question 3 (B).

1. SELECT * FROM Item WHERE Item Description = Widgets GIVING Temp 1
2. JOIN Temp 1 AND Purchase Order Line OVER Item No. GIVING Temp 2
3. SELECT * FROM Temp 2 WHERE Quantity > 100 GIVING Temp 3
4. JOIN Temp 3 AND Purchase Order OVER P.O. Number GIVING Temp 4
5. JOIN Temp 4 AND Vendor OVER Vendor No. GIVING Temp 5
6. PROJECT Temp 5 OVER Vendor Name GIVING Result

Question 4.

1. C
2. C
3. D
4. B
5. C