--建立学生表
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