2011《数据库实训》指导书

《2011《数据库实训》指导书》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、河北工程技术高等专科学校《数据库实训》指导书主撰人：崔凌云计算机系2011年12月7前言本指导书是根据数据库课程设计教学大纲编写的。本书的编写以培养学生分析解决实际问题的能力为主线，引导学生综合应用所学过的程序设计和数据库系统原理的知识，进行一个简单的数据库应用系统的设计，以训练学生的设计能力，培养其创新思维，并使学生进行课程设计时有所依据。7目录一、课程设计的性质与目的····································································

2、·························1二、课程设计的时间分配·································································································1三、课程设计地点选择·····································································································1四、课程设计内容

3、安排与要求·························································································1五、注意事项·····················································································································3六、实习报告要求····························

4、···············································································3七、成绩评定···················································································································5附1、封面················································

5、·········································································6附2、格式示例··················································································································77一、课程设计的性质与目的“数据库实训”是数据库系统原理及程序设计等课程的后续实践性课程，是一门独立开设的实践性课程，

6、也是毕业设计等后续课程的基础。“数据库课程设计”对于巩固数据库知识，加强学生的实际动手能力和提高学生综合素质十分必要。“数据库实训”的主要目标是：1、加深对数据库系统原理及程序设计的理论知识的理解和应用。2、通过设计实际的数据库系统课题，进一步熟悉数据库管理系统的操作技术，提高动手能力，提高分析问题和解决问题的能力。3、学习基本的数据库编程方法。二、课程设计的时间分配序号工作内容时间教学工作目标、要求1布置任务及准备0.5天做好课程设计准备。2数据库分析和设计按数据库设计方法和规范化理论，得出符合3NF的

7、数据模型。3数据库实施1天定义数据库、基本表、视图、和安全性、完整性要求。4数据库程序实施1天设计并编写函数、存储过程、触发器。5撰写设计报告1天按要求撰写并打印设计报告。6验收和答辩0.5天上机演示系统并进行答辩。合　　计三、课程设计地点选择计算机系机房。四、课程设计内容安排与要求学生宿舍管理信息系统：1、背景资料：1)7入校时，每位同学都有唯一的学号，并被分配到指定的宿舍楼和指定的宿舍，也会有一个宿舍号，其入校时间就是他的入住时间。2)每间宿舍都有唯一的宿舍号，入校时，宿舍会装公用电话机，相应地就有宿

8、舍电话号码。3)每个宿舍的财产属于学校，比如电灯，床铺，柜子，桌椅等，为了对不同的财产进行区分，可以为每种财产分配不同的财产号。这样有利于财产的报修和管理。4)宿舍楼中经常出现财产的损坏，比如灯泡坏了这时，同学们需要将财产损坏情况报告给宿舍楼管理员，以便学校派人进行维修。当财产不能维修时，应该记录报废信息，并更换新财产。5)宿舍楼在指定的时间关门（比如晚上12点），若有同学晚于关门时间回宿舍，需通知宿舍楼管理员，同时应登记晚归