-- 向 department5217 表插入3条记录
INSERT INTO department5217 (dno, dept_name, header) VALUES
('D001', 'Computer Science', 'John Doe'),
('D002', 'Physics', 'Jane Smith'),
('D003', 'Mathematics', 'Bob Johnson');

-- 向 speciality5217 表插入3条记录
INSERT INTO speciality5217 (spno, dno, spname) VALUES
('SP001', 'D001', 'Computer Engineering'),
('SP002', 'D002', 'Quantum Physics'),
('SP003', 'D003', 'Applied Mathematics');

-- 向 class5217 表插入3条记录
INSERT INTO class5217 (spno, class_no, header) VALUES
('SP001', 'C001', 'Alice Brown'),
('SP002', 'C002', 'Charlie Davis'),
('SP003', 'C003', 'Eva White');

-- 向 Course5217 表插入3条记录
INSERT INTO Course5217 (cno, cname, spno, ctno, lecture, experiment, semester, credit) VALUES
('C001', '数据库原理', 'SP001', 1, 3, 2, 1, 4),
('C002', 'Quantum Mechanics', 'SP002', 2, 4, 2, 2, 5),
('C003', 'Linear Algebra', 'SP003', 1, 3, 1, 1, 3);

-- 向 teacher5217 表插入3条记录
INSERT INTO teacher5217 (t_no, t_name, t_sex, t_birthday, dno, tech_title) VALUES
('T001', 'Professor Smith', 'M', '1980-05-15', 'D001', 'Full Professor'),
('T002', 'Dr. Johnson', 'M', '1985-08-20', 'D002', 'Associate Professor'),
('T003', 'Ms. White', 'F', '1990-03-10', 'D003', 'Assistant Professor');

-- 向 student5217 表插入3条记录
INSERT INTO student5217 (s_no, sname, sex, sbirthday, dno, spno, class_no) VALUES
('S001', 'Alice Johnson', 'F', '2000-01-10', 'D001', 'SP001', 'C001'),
('S002', 'Bob Smith', 'M', '2001-04-22', 'D002', 'SP002', 'C002'),
('S003', 'Charlie Davis', 'M', '1999-11-05', 'D003', 'SP003', 'C003');

-- 向 student_course5217 表插入3条记录
INSERT INTO student_course5217 (s_no, tcid, score) VALUES
('S001', 1, 90),
('S002', 2, 85),
('S003', 3, 92);

-- 向 teacher_course5217 表插入3条记录
INSERT INTO teacher_course5217 (tcid, t_no, spno, class_no, cno, semester, schoolyear) VALUES
(1, 'T001', 'SP001', 'C001', 'C001', 'Fall', '2022'),
(2, 'T002', 'SP002', 'C002', 'C002', 'Spring', '2023'),
(3, 'T003', 'SP003', 'C003', 'C003', 'Fall', '2022');