数据库实验报告-概念模型的建立

drop table shehuiguanxi go

if exists (select 1

from sysobjects where id = object_id('stu') and type = 'U') drop table stu go

if exists (select 1

from sysobjects

where id = object_id('stufencon') and type = 'U') drop table stufencon go

if exists (select 1

from sysobjects

where id = object_id('stuhj') and type = 'U') drop table stuhj go

数据库原理实验报告

- 8 -

数据库原理实验报告

if exists (select 1

from sysobjects

where id = object_id('stutext') and type = 'U') drop table stutext go

if exists (select 1

from sysobjects

where id = object_id('term') and type = 'U') drop table term go

if exists (select 1

from sysobjects

where id = object_id('xueyear') and type = 'U') drop table xueyear go

if exists (select 1

from sysobjects

where id = object_id('xykcgl')

- 9 -

and type = 'U') drop table xykcgl go

/*==============================================================*/ /* Table: cla */

/*==============================================================*/ create table cla (

clano varchar(10) not null, clana varchar(40) not null, constraint PK_CLA primary key nonclustered (clano) ) go

/*==============================================================*/ /* Table: col */

/*==============================================================*/ create table col (

colno varchar(10) not null, colna varchar(40) not null, constraint PK_COL primary key nonclustered (colno) ) go

数据库原理实验报告

- 10 -

/*==============================================================*/ /* Table: jcxm */

/*==============================================================*/ create table jcxm (

jxno varchar(10) not null, jxna varchar(60) not null, constraint PK_JCXM primary key nonclustered (jxno) ) go

/*==============================================================*/ /* Table: ltest */

/*==============================================================*/ create table ltest (

ltestno varchar(10) not null, ltestna varchar(20) not null, testtime float not null, constraint PK_LTEST primary key nonclustered (ltestno) ) go

/*==============================================================*/ /* Table: maj */

/*==============================================================*/

数据库原理实验报告

- 11 -