134.    Create table Student. Also very simple: Major can be undeclared

 

create table student

( studentID char(9),

  studentname char(30) not null,

  major integer,

  constraint student_studentID_PK primary key (studentID),

  constraint student_major_FK Foreign Key (major) references major(majorID));