导师

show databases;
create database TutorDualSelectionSystem;

use TutorDualSelectionSystem;
create table Student
(
    Student_No char(12) primary key,
    Student_Name varchar(8),
    Student_Sex char(2),
    Student_Email varchar(15),
    Student_Telephone varchar(13)
    );
    
create table Teacher
( 
    Teacher_No char(5) primary key,
    Teacher_Name varchar(8),
    Teacher_Sex char(2),
    Teacher_Email varchar(15),
    Teacher_Telephone varchar(13),
    Teacher_Domain varchar(60),
    Teacher_LeadNumbers int
    );
    
create table SelectTutor
( 
    SelectTutor_StudentNo char(12),
    SelectTutor_TeacherNo char(5),
    SelectTutor_Resulted char(8),
    primary key(SelectTutor_StudentNo,SelectTutor_TeacherNo),
    foreign key(SelectTutor_StudentNO) references Student(Student_No),
    foreign key(SelectTutor_TeacherNo) references Teacher(Teacher_No)
    );
    
create table Admin
(
    Admin_Account char(12) primary key,
    Admin_Password varchar(13)
    );
    
    show tables;