UML建模实例详解(对具体的开发实例进行详细讲解)

数据库（原书中没有，新增）： USE master GO CREATE DATABASE OasData ON PRIMARY (NAME =Oas, FILENAME = 'c:\OasData\Data\Oas_Data.mdf', SIZE =50MB, MAXSIZE =100, FILEGROWTH =10) LOG ON (NAME =OasLog, FILENAME ='c:\OasData\Data\Oas_Log.ldf', SIZE =50MB, MAXSIZE =100, FILEGROWTH =10) GO 表T_SFile和T_EnreSFile（原书P264）： CREATE TABLE T_SFile( draftNo char(14) PRIMARY KEY REFERENCES T_Pending(submitter), draftDate smalldatetime, submitDate smalldatetime, fileCaption char(100), keyWord char(80), affixCaption char(100), mainTo char(30), CC char(150), confidential char(8), express char(6), fileNo char(14), copies tinyint, closingDate smalldatetime, fileContent text, affixContent text, state tinyint NOT NULL, draftsman_s char(10) NOT NULL, auditor_s char(10), auditing char(200), checkingMan char(10), checking char(200), signatory char(10), signing char(200), distributor char(10), distributing char(200) ) GO CREATE TABLE T_EnreSFile( fileNo char(14) PRIMARY KEY , draftNo char(14) REFERENCES T_SFile(draftNo), fileCaption char(100), keyWord char(80), sendDate smalldatetime, receiverOrgan char(30), haveAffix bit, confidential char(8), express char(6), copies tinyint ) GO 表T_RFile和T_EnreRFile（原书P266）： CREATE TABLE T_RFile( fileNo char(14) PRIMARY KEY REFERENCES T_EnreRFile(fileNo), fileCaption char(100), keyWord char(80), affixCaption char(100), mainTo char(30), CC char(150), confidential char(8), express char(6), fileContent text, affixContent text ) GO CREATE TABLE T_EnreRFile( fileNo char(14) PRIMARY KEY REFERENCES T_Pending(submitter), receiveDate smalldatetime, senderOrgan char(30), fileCaption char(100), keyWord char(80), haveAffix bit, confidential char(8), express char(6), copies tinyint, receiver char(10), state tinyint NOT NULL, recorder char(10), auditor_r char(10), auditing char(200), draftsman_r char(10), drafting char(200), authorizeMan char(10), authorizing char(200), user char(10), transacting char(200), remark char(100) ) GO 表T_User、T_Attendee、T_Meeting和T_Minute（原书P270）： CREATE TABLE T_User( account char(10) PRIMARY KEY, name char(8), department char(20), occupation char(10), accessAuthority char(1) NOT NULL, password char(6) NOT NULL ) GO CREATE TABLE T_Attendee( meetingSerialNo char(14) NOT NULL REFERENCES T_Meeting(meetingSerialNo), account char(10) NOT NULL REFERENCES T_User(account), department char(20), occupation char(10), name char(8), informationOrNot bit, PRIMARY KEY(meetingSerialNo, account) ) GO CREATE TABLE T_Meeting( meetingSerialNo char(14) PRIMARY KEY REFERENCES T_Pending(submitter), meetingName char(100), topic char(100), organizer char(10), chiefOrganizer char(10), spokesman char(10), meetingLocus char(100), startTime smalldatetime, endTime smalldatetime, applicator char(10) NOT NULL, auditor_m char(10), auditing char(200), informer char(10), MinuteRecorder char(10), state tinyint NOT NULL ) GO CREATE TABLE T_Minute( meetingSerialNo char(14) PRIMARY KEY REFERENCES T_Meeting(meetingSerialNo), meetingName char(100), fileNo char(14), fileCaption char(100), keyWord char(80), chiefOrganizer char(10), meetingLocus char(100), startTime smalldatetime, endTime smalldatetime, attendee char(300), topicAndArgumentation text ) GO 表T_Borrowing（原书P271）： CREATE TABLE T_Borrowing( borrowingNo char(14) PRIMARY KEY REFERENCES T_Pending(submitter), archiveNo char(8), borrower char(10), fileNo char(14) NOT NULL, borrowingPeriod tinyint, applicationTime smalldatetime, approvedTime smalldatetime, returningTime smalldatetime, state tinyint NOT NULL ) 表T_Pending和T_Notice（P.272）： CREATE TABLE T_Pending( submitter char(14) PRIMARY KEY, user char(10) NOT NULL, submitTime smalldatetime, topic char(30), content char(100) ) GO CREATE TABLE T_Notice( noticeNo char(14) PRIMARY KEY REFERENCES T_Pending(submitter), publishingMaker char(10) NOT NULL, department char(20), topic char(50), content char(1000), publishingTime smalldatetime ) GO 表T_Borrowing和T_Archive（原书P274）： CREATE TABLE T_Borrowing( borrowingNo char(14) PRIMARY KEY REFERENCES T_Pending(submitter), archiveNo char(8) REFERENCES T_Archive(archiveNo), borrower char(10), fileNo char(14) NOT NULL, borrowingPeriod tinyint, applicationTime smalldatetime, approvedTime smalldatetime, returningTime smalldatetime, state tinyint NOT NULL ) GO CREATE TABLE T_Archive( archiveNo char(8) PRIMARY KEY, ArchiveName char(50), storagePeriod tinyint, copies tinyint, closeOrNot bit, fileNo char(14) NOT NULL, fileCaption char(100), keyWord char(80), affixCaption char(100), mainTo char(30), CC char(150), confidential char(8), express char(6), closingDate smalldatetime, fileContent text, affixContent text, draftsman_s char(10), meetingSerialNo char(14), meetingName char(100), chiefOrganizer char(10), meetingLocus char(100), startTime smalldatetime, endTime smalldatetime, attendee char(300), topicAndArgumentation text ) GO