104.    Show the SQL commands necessary to create table Building. Show all Primary and Foreign Keys. Assume that no two buildings can have the same name, and must be included in the record. Also assume that most of the most of the classes are held in the ‘Classroom Building’.

 

create table building

( buildID integer,

  buildname char(20) not null default ‘Classroom Building’,

  primary key (buildID),

  unique (buildname));