【正文】 StudentIDNoneA1010科目SubjectNoneVA5050密碼PWDNoneA1616姓名NameNoneA1212老師編號(hào)TeacherIDNoneA1010試卷號(hào)PaperIDNoneI. 實(shí)體清單名稱(chēng)代碼父產(chǎn)生管理員AdminConceptual Data Model 39。TRUE老師TeachersConceptual Data Model 39。TRUE學(xué)生StudentsConceptual Data Model 39。TRUE試卷PapersConceptual Data Model 39。TRUE試題QuestionsConceptual Data Model 39。TRUE. 實(shí)體的識(shí)別字清單名稱(chēng)代碼父姓名Key_NameEntity 39。老師編號(hào)PK_TeacherIDEntity 39。學(xué)號(hào)PK_StudentIDEntity 39。流水號(hào)PK_IDEntity 39。問(wèn)題號(hào)PK_QuestionIDEntity 39。. 關(guān)系清單名稱(chēng)代碼父實(shí)體 2實(shí)體 1參加考試TestingConceptual Data Model 39。試卷學(xué)生生成CreateConceptual Data Model 39。試卷老師. 數(shù)據(jù)庫(kù)物理模型（Physical Data Model）. 圖. 物理模型欄位清單名稱(chēng)代碼老師編號(hào)TeacherID姓名Name密碼PWD科目Subject電子郵件Email學(xué)號(hào)StudentID姓名Name年齡Age性別Sex入學(xué)時(shí)間EnterTime密碼PWD電子郵件Email流水號(hào)ID老師編號(hào)TeacherID學(xué)號(hào)StudentID試卷號(hào)PaperID科目Subject成績(jī)Score問(wèn)題號(hào)QuestionID科目Subject問(wèn)題Question選項(xiàng)1Select1選項(xiàng)2Select2選項(xiàng)3Select3選項(xiàng)4Select4答案Answer姓名Name密碼PWD. 表格索引清單名稱(chēng)代碼唯一的群主要的外來(lái)鍵代替鍵表格姓名Index_NameFALSEFALSEFALSEFALSEFALSE老師姓名Index_NameTRUETRUETRUEFALSEFALSE學(xué)生學(xué)號(hào)Index_StudentIDFALSEFALSEFALSETRUEFALSE試卷科目Index_SubjectIDFALSEFALSEFALSEFALSEFALSE試題姓名Index_NameFALSEFALSEFALSEFALSEFALSE管理員. 表格引鍵清單名稱(chēng)代碼表格老師編號(hào)PK_TeacherID老師學(xué)號(hào)PK_StudentID學(xué)生流水號(hào)PK_ID試卷問(wèn)題號(hào)PK_QuestionID試題姓名Key_Name管理員. 參考清單名稱(chēng)代碼父表格子表格參加考試Testing學(xué)生試卷生成Create老師試卷. 表格清單名稱(chēng)代碼老師Teachers學(xué)生Students試卷Papers試題Questions管理員Admin. SQL語(yǔ)句/*==============================================================*//* Database name: NetTest (PDM) *//* DBMS name: Microsoft SQL Server 2000 *//* Created on: 2002611 11:28:20 *//*==============================================================*/alter table drop constraint FK_PAPERS_CREATE_TEACHERSgoalter table drop constraint FK_PAPERS_TESTING_STUDENTSgoif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table go/*==============================================================*//* Table: Admin *//*==============================================================*/create table (Name char(12) not null,PWD char(16) not null,constraint PK_ADMIN primary key (Name))go/*==============================================================*//* Index: Index_Name *//*==============================================================*/create index Index_Name on (Name)go/*==============================================================*//* Table: Papers *//*==============================================================*/create table (ID bigint identity,TeacherID char(10) not null,StudentID char(10) not null,PaperID int not null,Subject varchar(50) not null,Score smallint null constraint CKC_SCORE_PAPERS check (Score is null or (Score = 0 )),constraint PK_PAPERS primary key (ID))go/*==============================================================*//* Index: Index_StudentID *//*==============================================================*/create index Index_StudentID on (StudentID)go/*==============================================================*//* Table: Questions *//*==============================================================*/create table (QuestionID bigint identity,Subject varchar(50) not null,Question varchar(200) not null,Select1 varchar(100) not null,Select2 varchar(100) not null,Select3 varchar(100) not null,Select4 varchar(100) not null,Answer char(1) not null,