导师

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;

 

转载于:https://www.cnblogs.com/King-boy/p/10989552.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值