5作业表homework：用于存储作业信息包括所属课程、作业名称、作业描述等。6考试表exam：用于存储考试信息包括所属课程、考试名称、考试描述等。的代码

CREATE TABLE course ( course_id INT PRIMARY KEY, course_name VARCHAR(50) NOT NULL, course_description TEXT );

CREATE TABLE teacher ( teacher_id INT PRIMARY KEY, teacher_name VARCHAR(50) NOT NULL, teacher_email VARCHAR(50), teacher_phone VARCHAR(20) );

CREATE TABLE student ( student_id INT PRIMARY KEY, student_name VARCHAR(50) NOT NULL, student_email VARCHAR(50), student_phone VARCHAR(20) );

CREATE TABLE homework ( homework_id INT PRIMARY KEY, course_id INT, homework_name VARCHAR(50) NOT NULL, homework_description TEXT, FOREIGN KEY (course_id) REFERENCES course(course_id) );

CREATE TABLE exam ( exam_id INT PRIMARY KEY, course_id INT, exam_name VARCHAR(50) NOT NULL, exam_description TEXT, FOREIGN KEY (course_id) REFERENCES course(course_id) )