数据库原理实验报告.doc

数据库原理实验报告
actively carry out the law on civil air defense education, drawn out of the air defense in Pingliang er knots of up to 500,000 yuan fee collection tasks. 5, further standardize internal management, improve staff quality. Adhere to the
actively carry out the law on civil air defense education, drawn out of the air defense in Pingliang city Building under easy fare, daily special inspection and regulation, overfulfilled the province upper and lower knots of up to 500,000 yuan fee collection tasks. 5, further standardize internal management, improve staff quality. Adhere to the- 25 -
actively carry out the law on civil air defense education, drawn out of the air defense in Pingliang city Building under easy fare, daily special inspection and regulation, overfulfilled the province upper and lower knots of up to 500,000 yuan fee collection tasks. 5, further standardize internal management, improve staff quality. Adhere to the
Cname
字符型，长度20
非空
课程名
Credit
短整型
学分
property
字符型，长度为10
课程性质
表名： shouke
列名
数据类型
说明
描述
Tno
字符型，长度7
主键
教师号
Cno
字符型，长度10
主键
课程名
Hours
整数
课时

drop database JSSK
create database JSSK
create table teacher
(
Tno char(7) primary key,
Tname char(10) not null,
Tsex char(2) default '男' unique,
Birthday smalldatetime,
Dept varchar(20),
Tid char(18) not null
)
create table lessons
(
Cno char(10) primary key,
Cname char(20) not null,
Credit tinyint not null,
property varchar(10) not null
)
create table shouke
(
Tno char(7),
actively carry out the law on civil air defense education, drawn out of the air defense in Pingliang city Building under easy fare, daily special inspection and regulation, overfulfilled the province upper and lower knots of up to 500,000 yuan fee collection tasks. 5, further standardize internal management, improve staff quality. Adhere to the
actively carry out the law on civil air defense education, drawn out of the air d