医院管理系统数据库原理与应用

《医院管理系统数据库原理与应用》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、《数据库原理与应用》课程设计—医院管理系统班级：计算机11-2学号：11041214姓名：张福良成绩：theprovisionsofelectricpowerconstructionengineeringqualitysupervisionandquality...2.4.1.1theunitworksacceptancerateof100%,thequalityevaluationofatotalscoreof95orabove;2.4.1.2regulatedWeldingNDTinspection100%,regulat

2、edweldingapassingrateof>99%,andweldbeadappearance;2.4.1.3boilerhydraulic数据库名称:SM1说明：（1）数据库中包含的数据表的个数及名称。数据库中包含了4个表如下：Sickroom(病房表)Doctor(医生表)Office(科室表)Patient(病人表)（2）数据表结构设计需填写下表。sickroom(病房表)字段名称数据类型是否允许空值约束说明Bnumbervarchar(50)主键病房号Bednumbervarchar(50)主键病床号Knameva

3、rchar(50)科室名Doctor(医生表)字段名称数据类型是否允许空值约束说明Dnamechar(10)是医生姓名Dtitleschar(20)是职称Knamevarchar(50)是科室名DworknumberChar(20)主键工作编号theprovisionsofelectricpowerconstructionengineeringqualitysupervisionandquality...2.4.1.1theunitworksacceptancerateof100%,thequalityevaluationof

4、atotalscoreof95orabove;2.4.1.2regulatedWeldingNDTinspection100%,regulatedweldingapassingrateof>99%,andweldbeadappearance;2.4.1.3boilerhydraulicOffice（科室表）字段名数据类型是否允许空值约束说明Knamevarchar(50)×主键科室名Kaddressvarchar(50)科室地址Knumbervarchar(50)科室号Dnamevarchar(50)医生姓名Patient（病

5、人表）字段名称数据类型是否允许空值约束说明Pcnumberchar(10)×主键病历号Pnamechar(10)病人姓名Psexchar(2)性别BednumberVarchar（50）外键病床号IntimeDatetime(8)入院时间OuttimeDatetime(8)出院时间PhoneVarchar（50）联系电话Knamevarchar（50）科室名Psymptomsvarchar（50）症状Dnamechar（10）×医生姓名theprovisionsofelectricpowerconstructionengine

6、eringqualitysupervisionandquality...2.4.1.1theunitworksacceptancerateof100%,thequalityevaluationofatotalscoreof95orabove;2.4.1.2regulatedWeldingNDTinspection100%,regulatedweldingapassingrateof>99%,andweldbeadappearance;2.4.1.3boilerhydraulic（1）数据表记录需用图说明。sickroom(病房

7、表)theprovisionsofelectricpowerconstructionengineeringqualitysupervisionandquality...2.4.1.1theunitworksacceptancerateof100%,thequalityevaluationofatotalscoreof95orabove;2.4.1.2regulatedWeldingNDTinspection100%,regulatedweldingapassingrateof>99%,andweldbeadappearance

8、;2.4.1.3boilerhydraulicDoctor(医生表)Office（科室表）theprovisionsofelectricpowerconstructionengineeringqualitysupervisionandquality...2.4.1.1theu