Question: Give SQL solutions to Exercises 1 - 16.
Exercises 1 - 16
1 The only legal cities are London, Paris, Rome, Athens, Oslo, Stockholm, Madrid, and Amsterdam.
2 AU red parts weigh less than 50 pounds.
3 No two projects can be located in the same city.
4 At most one supplier can be located in Athens at any one time.
5 No shipment can have a quantity more than double the average of all such quantities.
6 The highest-status supplier must not be located in the same city as the lowest-status supplier.
7 Every project must be located in a city in which there is at least one supplier.
8 Every project must be located in a city in which there is at least onesupplier of that project.
9 There must exist at least one red part.
10 The average supplier status must be greater than 15.
11 Every London supplier must supply part P2.
12 At least one rod part weighs less than 50 pounds.
13 No shipment quantity can be reduced (in a single update) to less than half its current value.
14 Suppliers in London supply more different kinds of part than suppliers in Paris.
15 Suppliers in London supply more parts in total than suppliers in Paris.
16 Suppliers in Athens can move only to London or Paris, and suppliers in London can move only to Paris.