How to specify person type in table creation

[djspang]

Hi - Newbie here - I'm a bit stuck on the part of the question below, where in create table I must specify person type. How would I do that please? Many Thanks

Question: - Create a table called "Bakers" containing the following information:

full name, person type, location name, involvement status; where

· full name is a first and last name

* person type is either 'baker' or 'driver' as appropriate *

[r035198x]

What have you tried so far?

[amitpatel66]

Try using CHECK constraint on the column person_Type

[samir pradhan]

what u want to do ?

u have already created a table having a person column of person_type and u want to insert some data in it
or u want to create a table having a person column of person_type ?

plz clarify.