ADV database

CREATE TABLE person(

PersonID char(5),

Last_Name varchar(20),

First_Name varchar(20),

Hire_Date datetime(),

Enrollment_Date datetime(),

primary key(PersonID));

CREATE TABLE Course(

CourseID char(5),

title varchar(20),

credits char(1),

location varchar(50),

days char(3),

time varchar(50),

DepartmentID char(5),

primary key(CourseID),

foreign key(DepartmentID) references Department);

CREATE TABLE Department(

DepartmentID char(5),

Name varchar(20),

Budget numeric(8,2),

Administrator varchar(50),

primary key(DepartmentID));