create database dormitory;
use dormitory;
create table studdent//ѧ.
(studentid int not null primary key,//ѧID
 studentname varchar(10) not null, //ѧ
 buildingid int,//¥
 dormitoryid int,//
 bedid int,//̺
 studentsex char(2) not null,//ѧԱ
 studentage int,//ѧ
 stayingtime char(10),//
 classid char(10),//༶
 major char(10),//
 telephone int,//ѧ绰
 intime datetime//סʱ
);
create table class//༶
(classid int not null primary key,//༶
 classname varchar(10) not null,//༶
 studentamount int,//ѧĿ
 classmoniter char(10),//೤
 instructor char(10),//Ա
 major char(10)//רҵ
 );
 create table dormitory//()
 (dormitoryid int not null primary key,ID
  buildingid int not null,//¥ID
  kindid int,//ȼ
  telephonenum int,//绰
  dormitorysex char(2),//Ա
  stayingamount int//ס
 );
create table dormitorykind//ȼ
(kindid int not null primary key,//ȼID
 standardamount char(10),//׼
 standardfee int//
);
create table building//¥
(buildingid int not null primary key,//¥ID
 administrator varchar(10),//¥¥
 flooramount char(80),//¥
 areaamount int,//¥
 buildingsex char(2)//Ա
);
create table building_dormikind//¥-ȼ
(buildingid int not null ,
kindid int not null ,
primary key (buildingid,kindid ),
dormitoryamount int//
);
create table dormitory_class//-༶
(dormitoryid int not null primary key,
 classid int not null primary key,
 thisclassstuamount char(10)//ĳ
);
<connectionStrings>
  <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\WebCashs.mdf;Integrated Security=True;User Instance=True"
   providerName="System.Data.SqlClient" />
</connectionStrings>