SQLize Online / PHPize Online  /  SQLtest Online

create table course( course_name varchar (50), course_number varchar (50), credit_hrs int(2), department varchar (10) ); create table section( section_id int(10), course_number varchar (50), semester varchar (10), year int(10), instructor varchar(50) ); create table grade_report( srudent_number int(10), section_identifire int(10), grade varchar(50) ); create table prerequisite( course_number varchar(50), prerequisite_number varchar(50) ); select * from course; insert into course values ("Introduction to computer science", "cs1310",4, "cs"); select * from course; insert into course values ("data structures", "cs3320",4, "cs"); select * from course; insert into course values ("discrete mathematics", "MATH2410",3, "MATH"); select * from course; insert into course values ("database","cs3380",3,"cs"); select * from section; insert into section values (85, "math2410", "fall", 04, "king"); select * from grade_report; insert into grade_report values (17, 112, 'b'); select * from prerequisite; insert into prerequisite values ('ccs3380', 'cs3320');