create table assignments(loginid varchar2(6),comments varchar2(20), status char(1), given_by varchar2(6),courseanddept varchar2(15),adate date default sysdate, foreign key(loginid) references login(loginid));