中南大学数据库课程的设计之冰箱荐购课程的设计.docx

中南大学数据库课程设计课程设计题目冰箱购买系统设计 指 导 老 师 张祖平，么旭君 专 业 班 级 电子信息1002 姓 名 学 号 实 验 日 期2013年7月 目 录前言····································································31.面向对象·······························································32.课程设计目的···························································33.课程设计总体要求·······················································34.课程设计要求···························································35.开发工具·······························································36.开发任务概述····························································3后台程序设计·························································41.系统E-R表构建·························································42.SQL表格部分截图························································7前台程序设计·······················································91.实验设计总体框架······················································102.功能模块分析··························································103.业务流程······························································104.实验设计截图··························································10四．实验心得····························································28前 言一．面向对象中南大学2010级信息科学与工程学院电子信息工程专业1001-1004班学生课程设计目的培养学生熟练掌握一种大型数据库系统的开发环境如ORACLE9i/10g/11g(或更高版本)或SQL SERVER2005/2008/2010(或更高版本)，对其底层的数据库触发器与程序过程有深入的了解，了解并基本掌握面向数据库的C/S模式的通用开发工具如VB、PB或DELPHI或直接用语言C#或Java开发C/S模式的系统;或者采用ASP、JSP、PHP等开发技术来开发B/S模式的系统，熟悉开发一个小型应用系统的过程及主要技术。其中基于.Net平台与J2EE平台工具套件中同时支持B/S模式与C/S模式的开发。三．课程设计总体要求 1．完成设计、程序编制、调试与检查验收 2．书写完整的课程设计报告（至少20页），需求分析（要做什么事情如功能需求、信息需求、做到什么程度如性能需求、有哪些难点或关键技术），系统设计（功能模型、信息模型、数据库设计、典型处理流程或算法、典型的后台处理如触发器或过程所涉及到的逻辑等）、系统实现及关键技术、总结与展望等章节。 3.数据库与大型程序的对象命名规则一定为XXX_班号(+)学号尾4位例如car_master_10104即表示车辆主要信息表，为1班，学号尾数是0104设计的表结构，cloth_Detail_42309即表示衣服信息明细表，为4班，学号尾数是2309设计的表结构，对象（包括大的程序对象及程序名等）如果不能体现班级及学号等信息，则视为程序不合要求，程序部分成绩可能不合格。课程设计要求（1）提出技术方案，主要包括开发与运行模式选择、开发工具、数据库管理系统及其主要的特性保证。（课