And more still create table course course id varchar(8), title varchar(50), dept name varchar(20), credits numeric(2,0) primary key (course_id), foreign key(dept name)references department); Database System Concepts-6th Edition 3.9 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 3.9 ©Silberschatz, Korth and Sudarshan th Edition And more still create table course ( course_id varchar(8), title varchar(50), dept_name varchar(20), credits numeric(2,0), primary key (course_id), foreign key (dept_name) references department);