I keep getting an error: error, relation: tutor does not exist.
Any clues?
Any clues?
Code:
CREATE TABLE Student (
sid int primary key,
sname varchar(20),
programme varchar(4),
level int,
age int
);
CREATE TABLE Class (
ccode varchar(6) primary key,
cname varchar(25),
week_day varchar(3),
meets_at time,
room varchar(6),
tid int references Tutor(tid)
);
CREATE TABLE Enrolled (
sid int references Student(sid),
ccode varchar(6) references Class(ccode)
);
CREATE TABLE Tutor (
tid int primary key,
tname varchar(20)
)