实验七：数据库综合实验

《实验七：数据库综合实验》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、实验七：数据库综合实验实验七：数据库综合实验[实验内容及要求]本次实验是一次综合实验，共需5周时间/20课时完成。实验内容为选择下面的四个案例之一，分析并设计数据库，开发PHP应用系统。每班选择一个案例，各班不能重复，每组1-3人。前两周进行数据库设计、后两周进行PHP应用设计，最后一周检查评审。数据库设计要求：1、实体关系模型2、表实例图3、建表语句4、样例数据入库（insert语句）5、业务逻辑实现（select语句）PHP开发要求：参照案例的内容，自主设计应用页面，要求界面友好，能够满足案例中的基本业务需求，对相关数据

2、进行增删改查。综合实验最终提交文档：ＣＤＭ、ＰＤＭ文件，ＳＱＬ代码，关键抽取文档，数据库设计说明书文档，以及PHP应用程序。《数据库设计与应用开发》课程实验　　　　　　　　　　教师：杨金民　　　　　　　　　　13/13实验七：数据库综合实验CaseA-InformationManagementinWellmeadowsHospitalB.3TheWellmeadowsHospitalCaseStudyThiscasestudydescribesasmallhospitalcalledWellmeadows,whichislo

3、catedinEdinburgh.TheWellmeadowsHospitalspecializesintheprovisionofhealthcareforelderlypeople.Listedbelowisadescriptionofthedatarecorded,Maintained,andaccessedbythehospitalstafftosupportthemanagementandday-to-dayoperationsoftheWellmeadowsHospital.B.3.1DataRequiremen

4、tsWardsTheWellmeadowsHospitalhas17wardswithatotalof240bedsavailableforshort-andlong-staypatients,andanout-patientclinic.Eachwardisuniquelyidentifiedbyanumber(forexample,ward11)andalsoawardname(forexample,Orthopaedic),location(forexample,EBlock),totalnumberofbeds,an

5、dtelephoneextensionnumber(forexample,Extn7711).StaffTheWellmeadowsHospitalhasaMedicalDirector,whohasoverallresponsibilityforthemanagementofthehospital.TheMedicalDirectormaintainscontrolovertheuseofthehospitalresources(includingstaff,beds,andsupplies)intheprovisiono

6、fcost-effectivetreatmentforallpatients.TheWellmeadowsHospitalhasaPersonnelOfficerwhoisresponsibleforensuringthattheappropriatenumberandtypeofstaffareallocatedtoeachwardandtheout-patientclinic.Theinformationstoredoneachmemberofstaffincludesastaffnumber,name(firstand

7、last),fulladdress,telephonenumber,dateofbirth,sex,NationalInsurancenumber(NIN),positionheld,currentsalary,andsalaryscale.Italsoincludeseachmember’squalifications(whichincludesdateofqualification,type,nameofinstitution),andworkexperiencedetails(whichincludesthenameo

8、ftheorganization,position,andstartandfinishdates).Thetypeofemploymentcontractforeachmemberofstaffisalsorecorded,includingthenumberofhoursworkedpe