Question: Finish the following SQL that creates the table creatures. A creature can be either a 'HUMAN', 'ANIMAL', or 'INSECT'. Make sure that only these classifications

Finish the following SQL that creates the table creatures. A creature can be either a 'HUMAN', 'ANIMAL', or 'INSECT'. Make sure that only these classifications can be entered into the table.
CREATE TABLE creatures (
creature_id varchar(20),
description varchar(100),
classification varchar(6),
BLANK #1(
classification BLANK #2('HUMAN', 'ANIMAL', 'INSECT')
)
);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!