-
Make the (slight) changes to the above diagram that
are sufficient to do the two
selects shown in #3, and #4. Submit the diagram as a
png file (
b.png).
-
Create and populate a database with testdata sufficient
to do the two selects shown below.
Submit the sql declarations as an sql text file
(
b.sql).
-
Retrieve a list of the colors that exists in both
paper and plastic. Add the necessary declaration(s)
to
b.sql.
-
A list of the colors that only exists in paper.
Add the necessary declaration(s)
to
b.sql.