6.   Show the CREATE command necessary for the physician Table:

 

      PHYSICIAN(physid, name, address, specialty, age)

 

      Where the primary key is physid, name must not be blank, address is the composite key consisting of street, city, state (assume that, by default, all physicians live in Texas (TX)), and zipcode. Assume that no twp physicians can have the same specialty.  Age is the physician’s present age, in whole numbers, as of their last birthday (to avoid the possibility of entry error, let’s assume that a physician must be between the ages of 21 and 90 (Doogie Howser not withstanding)).

 

CREATE TABLE physician

   

  ( physid           CHAR(9),                              

     name             CHAR(30)  NOT NULL,

  street           CHAR(20),

  city             CHAR(20),

  state            CHAR(2),  DEFAULT ‘TX’,

  zipcode          CHAR(5),

  specialty        CHAR(15),

  age              INTEGER,

  PRIMARY KEY (physid),

  UNIQUE (specialty),

  CHECK (age BETWEEN 21 AND 90)  );