[LTU]1009資料庫系統5個table

create table STUDENT(
Name varchar(10),
Student_number int(3),
Class int(2),
Major varchar(20));

insert into STUDENT values('Smith',17,1,'CS'),('Brown',8,2,'CS');

create table COURSE(
Course_name varchar(50),
Course_number varchar(10),
Credit_hours int(3),
Department varchar(20));

insert into COURSE values('Intro to Computer Science','CS1310',4,'CS'),('Data Structures','CS3320',4,'CS'),('Discrete Mathematics','MATH2410',3,'MATH'),('Database','CS3380',3,'CS');

create table SECTION(
Section_identifier int(3),
Course_number varchar(10),
Semester varchar(10),
Year varchar(2),
Instructor varchar(20));

insert into SECTION values(85,'MATH2410','Fall','07','King'),(92,'CS1310','Fall','07','Anderson'),(102,'CS3320','Spring','08','Knuth'),(112,'Math2410','Fall','08','Chang'),(119,'CS1310','Fall','08','Anderson'),(135,'CS3380','Fall','08','Stone');

create table GRADE_REPORT(
Student_number int(3),
Section_identifier int(3),
Grade varchar(1));

insert into GRADE_REPORT values(17,112,'B'),(17,119,'C'),(8,85,'A'),(8,92,'A'),(8,102,'B'),(8,135,'A');

create table PREREQUISITE(
Course_number varchar(10),
Prerequisite_number varchar(10));

insert into PREREQUISITE values('CS3380','CS3320'),('CS3380','MATH2410'),('CS3320','CS1310');