test1

create database StuDB
use STuDB

create table ClassInfo(
ClassID int identity primary key,
ClassName varchar(50) not null
)

create table StudentInfo(
ID int identity primary key,
Name varchar(50) not null,
Sex char(2) default('男') not null,
Age int check(Age<=100) not null,
Hobby varchar(255) not null,
Moblie varchar(255) not null,
ClassID int references ClassInfo(ClassID)
)

insert into ClassesInfo values('物联网111班')
insert into ClassesInfo values('物联网111班')

insert into StudentInfo values('张三','男',18,'唱歌,跳舞','3446546','1')