oracle建立学生，课程以及选课表并进行插入查询操作

--建立学生表

CREATE TABLE students(

id NUMBER(10) ,

name VARCHAR2(20) CONSTRAINT students_name_nn NOT NULL,

gender VARCHAR2(4) NOT NULL,

birthday DATE CONSTRAINT students_birthday_nn NOT NULL,

political VARCHAR2(20),

CONSTRAINT students_id_pk PRIMARY KEY(id),

CONSTRAINT students_gender_ck CHECK(gender IN('男','女'))

);

 

--建立课程表

CREATE TABLE course(

id NUMBER(10),

name VARCHAR2(20)  NOT NULL,

credit NUMBER CONSTRAINT course_credit_nn NOT NULL,

studyhours NUMBER CONSTRAINT course_studyhours_nn NOT NULL, 

semester VARCHAR2(20)CONSTRAINT course_semester_nn NOT NULL,

CONSTRAINT course_id_pk PRIMARY KEY(id),

CONSTRAINT course_name_uk UNIQUE(name)

);

 

--建立选课表

CREATE TABLE elective(

student_id NUMBER NOT NULL,

course_id NUMBER NOT NULL,

score NUMBER CONSTRAINT elective_score_nn NOT NULL,

CONSTRAINT elective_sid_fk FOREIGN KEY(student_id) REFERENCES students(id) on delete cascade,

CONSTRAINT elective_cid_fk FOREIGN KEY(course_id) REFERENCES course(id) on delete cascade

);

 

--建立学生id序列

create sequence students_id

increment by 1

start with 100000

maxvalue 99999999

minvalue 1

 

--建立课程id序列

create s