欢迎来到天天文库
浏览记录
ID:18491966
大小:74.00 KB
页数:10页
时间:2018-09-18
《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点),若有同学晚于关门时间回宿舍,需通知宿舍楼管理员,同时应登记晚归
此文档下载收益归作者所有