实验七：数据库综合实验.docVIP

实验七：数据库综合实验 [实验内容及要求] 本次实验是一次综合实验，共需5周时间/20课时完成。实验内容为选择下面的四个案例之一，分析并设计数据库，开发PHP应用系统。每班选择一个案例，各班不能重复，每组1-3人。前两周进行数据库设计、后两周进行PHP应用设计，最后一周检查评审。 数据库设计要求： 1、实体关系模型 2、表实例图 3、建表语句 4、样例数据入库（insert语句） 5、业务逻辑实现（select语句） PHP开发要求： 参照案例的内容，自主设计应用页面，要求界面友好，能够满足案例中的基本业务需求，对相关数据进行增删改查。 综合实验最终提交文档： ＣＤＭ、ＰＤＭ文件，ＳＱＬ代码，关键抽取文档，数据库设计说明书文档，以及PHP应用程序。 Case A - Information Management in Wellmeadows Hospital B.3 The Wellmeadows Hospital Case Study This case study describes a small hospital called Wellmeadows, which is located in Edinburgh. The Wellmeadows Hospital specializes in the provision of health care for elderly people. Listed below is a description of the data recorded, Maintained, and accessed by the hospital staff to support the management and day-to-day operations of the Wellmeadows Hospital. B.3.1 Data Requirements Wards The Wellmeadows Hospital has 17 wards with a total of 240 beds available for short-and long-stay patients, and an out-patient clinic. Each ward is uniquely identified by a number (for example, ward 11) and also a ward name (for example, Orthopaedic), location (for example, E Block), total number of beds, and telephone extension number (for example, Extn 7711). Staff The Wellmeadows Hospital has a Medical Director, who has overall responsibility for the management of the hospital. The Medical Director maintains control over the use of the hospital resources (including staff, beds, and supplies) in the provision of cost-effective treatment for all patients. The Wellmeadows Hospital has a Personnel Officer who is responsible for ensuring that the appropriate number and type of staff are allocated to each ward and the out-patient clinic. The information stored on each member of staff includes a staff number, name(first and last),full address, telephone number, date of birth, sex, National Insurance number(NIN), position held, current salary, and salary scale. It also includes each member’s qualifications (which includes date of qualification, type, name of in