create table assignments (
 coursenumber varchar2(6),
 description varchar2(30),
 complete varchar2(1) check(complete='N' or complete='Y'),
 dateassigned varchar2(11),
 datedue varchar2(11),
 hoursworked varchar(4)
);
 
