107.    Show the SQL commands necessary to create table Classrooms. Show all Primary and Foreign Keys. Assume that no fields can be left empty. Make sure capacity is greater than zero (0).

 

create table classrooms

( classroom integer,

  building integer not null,

  roomnum char(10) not null,

  capacity integer not null,

  primary key (classroom),

  constraint classrooms_building_FK Foreign Key (building) references building (buildID),

  constraint classrooms_capacity_CK check (capacity > 0));