11. Doogie Howser has appeared. So has a Tibetan Monk, who is also a physician and is 122 years old. You need to change the restrictions on the physician table. A physician’s still must be 16 or greater (State law), but given increases in longevity, can be anywhere up to 200 years old (A soon to be passed State law). Show the commands necessary.

 

ALTER TABLE physician

  DROP CONSTRAINT

  CHECK (age BETWEEN 21 AND 90);

ALTER TABLE physician

  ADD CONSTRAINT

  CHECK (age BETWEEN 16 AND 200);