--学生表(students)
sql
CREATE TABLE students (
student_id NUMBER PRIMARY KEY,
name VARCHAR2(50),
age NUMBER,
gender VARCHAR2(10),
major VARCHAR2(50)
);
INSERT INTO students (student_id, name, age, gender, major)
VALUES (1, '李明', 20, '男', '计算机科学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (2, '张三', 21, '女', '文学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (3, '王五', 22, '男', '历史');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (4, '刘七', 23, '女', '数学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (5, '李华', 24, '男', '物理');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (6, '赵六', 25, '女', '心理学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (7, '陈九', 26, '男', '政治学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (8, '张思', 27, '女', '经济学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (9, '王琳', 28, '男', '人口学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (10, '李芳', 29, '女', '社会学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (11, '张二', 30, '男', '医学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (12, '王三', 31, '女', '生物学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (13, '刘四', 32, '男', '心理学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (14, '李五', 33, '女', '教育学');
INSERT INTO students (student_id, name, age, gender, major)
VALUES (15, '赵六', 34, '男', '计算机科学');
--教师表(teachers)
sql
CREATE TABLE teachers (
teacher_id NUMBER PRIMARY KEY,
name VARCHAR2(50),
age NUMBER,
gender VARCHAR2(10),
department VARCHAR2(50)
);
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (1, '李老师', 35, '男', '计算机科学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (2, '张老师', 40, '女', '文学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (3, '王老师', 45, '男', '历史');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (4, '刘老师', 50, '女', '数学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (5, '李老师', 55, '男', '物理');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (6, '赵老师', 60, '女', '心理学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (7, '陈老师', 65, '男', '政治学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (8, '张老师', 70, '女', '经济学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (9, '王老师', 75, '男', '人口学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (10, '李老师', 80, '女', '社会学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (11, '张老师', 85, '男', '医学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (12, '王老师', 90, '女', '生物学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (13, '刘老师', 95, '男', '心理学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (14, '李老师', 100, '女', '教育学');
INSERT INTO teachers (teacher_id, name, age, gender, department)
VALUES (15, '赵老师', 105, '男', '计算机科学');
--课程表(courses)
sql
CREATE TABLE courses (
course_id NUMBER PRIMARY KEY,
name VARCHAR2(50),
teacher_id NUMBER,
credit NUMBER
);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (101, '数据库管理', 1, 4);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (102, '英语写作', 2, 3);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (103, '中国古代史', 3, 3);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (104, '高等数学', 4, 5);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (105, '量子力学', 5, 4);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (106, '社会心理学', 6, 3);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (107, '政治哲学', 7, 4);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (108, '国际贸易', 8, 3);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (109, '人口发展', 9, 3);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (110, '社会学基础', 10, 5);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (111, '临床医学', 11, 4);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (112, '生态学', 12, 3);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (113, '心理健康教育', 13, 2);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (114, '初等教育学', 14, 3);
INSERT INTO courses (course_id, name, teacher_id, credit)
VALUES (115, 'Web开发', 15, 4);
--成绩表(grades)
sql
CREATE TABLE grades (
id NUMBER PRIMARY KEY,
student_id NUMBER,
course_id NUMBER,
grade NUMBER
);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (1, 1, 101, 90);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (2, 2, 102, 80);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (3, 3, 103, 88);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (4, 4, 104, 92);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (5, 5, 105, 85);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (6, 6, 106, 78);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (7, 7, 107, 90);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (8, 8, 108, 80);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (9, 9, 109, 88);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (10, 10, 110, 92);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (11, 11, 111, 85);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (12, 12, 112, 78);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (13, 13, 113, 90);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (14, 14, 114, 80);
INSERT INTO grades (id, student_id, course_id, grade)
VALUES (15, 15, 115, 88);
-- 添加更多的成绩数据
Oracle数据库可以直接拿来用的测试(学习)代码
最新推荐文章于 2024-08-12 13:39:03 发布