PowerDesigner数据建模1实验报告要点 - 图文 下载本文

接下来,在数据库里(开始菜单-?程序-? microsoft SQL server-?查询分析器),数据库——系统数据库——master——表——右键,刷新, 就出来了新建的表。如下图。 四.实验结果 CDM图(ER图):

PDM图:

SQL代码: if exists (select 1 from sysobjects where id = object_id('Library') and type = 'U') drop table Library go if exists (select 1 from sysobjects where id = object_id('Unit') and type = 'U') drop table Unit go if exists (select 1 from sysobjects where id = object_id('book') and type = 'U') drop table book go if exists (select 1 from sysobjects where id = object_id('reader') and type = 'U') drop table reader go if exists (select 1 from sysobjects where id = object_id('\ and type = 'U') drop table \go /*==============================================================*/ /* Table: Library */ /*==============================================================*/ create table Library ( Library_No char(20) not null, Library_Address varchar(38) not null, constraint PK_LIBRARY primary key nonclustered (Library_No) )