122.    Create tabe Course. There should be no null values allowed and Course Name shoule be unique.

 

create table course

( CourseID Integer,

  CourseName Char(20) not null,

  depart integer not null,

  primary key (courseID),

  constraint course_depart_FK Foreign Key (depart) references department (deptID),

  unique (coursename));