130     Create table Major. Very simple: No null values, unique Major Name

 

create table major

( majorID integer,

  majorname char(20) not null,

  dept integer not null,

  constraint major_majorID_PK primary key (majorID),

  constraint major_Dept_FK Foreign Key (dept) references department (deptID),

  unique (majorname));