Database Reference
In-Depth Information
body_shape
column, use the text I have just shown, or reword it if you want.
For now, skip the third column,
body_example
.
2. You were asked also in the exercises at the end of
Chapter4
to create another
table for identifying birds, called
birds_wing_shapes
. This describes the
shapes of bird wings. Here's an initial list of names for general wing shapes:
Broad
Rounded
Pointed
Tapered
Long
Very Long
Construct an
INSERT
statement to insert these items into the
birds_wing_shapes
table using the emphatic syntax — the method that in-
cludes the
SET
clause. Set the
wing_id
to a two-letter code. You decide these
values, as you did earlier for
body_id
. For the
wing_shape
column, use the
text just shown. Don't enter a value for the
wing_example
column yet.
3. The last bird identification table in which to enter data is
birds_bill_shapes
. Use the
INSERT
statement to insert data into this
table, but whichever multiple-row method you prefer. You determine the two-let-
ter values for
bill_id
. Don't enter values for
bill_example
. Use the fol-
lowing list of bill shapes for the value of
bill_shape
:
All Purpose
Cone
Curved
Dagger
Hooked
Hooked Seabird
Needle
Spatulate
Specialized
4. Execute a
SELECT
statement to view the row from the
birds_body_shapes
table where the value of the
body_shape
column is
Woodland Fowl
. Then re-