create table student
(
SID char (3)  Not null,
Sname  varchar2 (10) Not Null,
SEX char(1)  check (sex in ('M', 'F')), 
major char(3) check (major in ('ACC', 'FIN', 'MGT', 'MKT')),
GPA NUMERIC (3,2),
Primary key(SID)
);

create table faculty
(
FID char(3) not null,
FNAME char(10) not null, 
EXT  char (3),
DEPT char(3) check (DEPT in ('ACC', 'FIN', 'MGT', 'MKT')),
RANK varchar(4) check (RANK in ('INST', 'ASST', "ASSO", 'FULL')),
SALARY int(0,2),
);

create table COURSE
(
CRSNBR char(6) not null,
CNAME  char(20) not null,
CREDIT char (1),
MAXENRL SMALLINT 
FID  char (3),
);

create table CRSENRL
(
CRSNBR char (6) Not Null,
SID  char(3) not Null, 
GRADE char (1),
);