SQL question

Associate
Joined
4 Mar 2007
Posts
315
Location
United Kingdom
I keep getting an error: error, relation: tutor does not exist.

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)
)
 
Back
Top Bottom