构建数字化校园的技术实践与对话

        
          -- 创建学生表
          CREATE TABLE Students (
            StudentID INT PRIMARY KEY AUTO_INCREMENT,
            Name VARCHAR(50),
            Age INT,
            Major VARCHAR(50)
          );

          -- 创建课程表
          CREATE TABLE Courses (
            CourseID INT PRIMARY KEY AUTO_INCREMENT,
            Title VARCHAR(100),
            Credit INT,
            InstructorID INT,
            FOREIGN KEY (InstructorID) REFERENCES Teachers(TeacherID)
          );