数据库原理及设计课程设计实验报告册

数据库原理及设计课程设计实验报告册 内江师范学院 数据库原理及应用课程设计 编制 刘 芳 审定 刘好斌 专业: 信息与计算科学 班级: 2012 级 6 班 学号: 姓名: 数学与信息科学学院 2014年2月 实验成绩 准 备 阶 段 实验阶段 资料准备 资料整理 实验设计 出勤 态度 实验报告 实验成绩 5% 5% 20% 10% 10% 50% 说明: 1. 学生在做实验之前必须要准备实验，主要包括预习与本次实验相关的理论知识，熟练 与本次实验相关的软件操作，做实验设计，提出实验的方案，收集整理相关的实验参 考资料，要求学生在做实验时能带上充足的参考资料;若准备不充分，则学生不得参 加本次实验，不得书写实验报告; 2. 要求学生要认真做实验，主要是指不得迟到、早退和旷课，在做实验过程中要严格遵 守实验室 规章制度 食品安全规章制度下载关于安全生产规章制度关于行政管理规章制度保证食品安全的规章制度范本关于公司规章制度 ，认真完成实验内容，极积主动地向实验教师提问等;若学生无故 旷课，则本次实验计为0分; 3. 学生要认真工整地书写实验报告，实验报告的内容要紧扣实验的要求和目的，不得抄 袭他人的实验报告; 4. 实验成绩从以上表格中的六项来进行考核。 1 实验名称: 图书销售管理系统的数据库设计与实现 指导教师: 刘 芳 实验时数: 34 实验设备: 安装了SQL Server 2005软件的计算机 实验日期: 2014 年 3 — 6 月 实验地点: 教学五楼北802 实验目的: 1. 掌握数据库概念模型的建立过程; 2. 掌握数据库逻辑模型的建立过程; 3. 掌握数据库物理模型的建立过程。 实验准备: 1. 在开始本实验之前，请回顾教科书的相关内容; 2. 需要一台安装Windows XP Professional操作系统和装有SQL Server 2005的计算机。 实验内容及要求 图书销售系统主要包括进货、退货、统计、销售功能，详细描述如下。 1. 进货:根据某种书籍的库存量及销售情况确定进货数量，根据供应商报价选择供应商。输出一份 进货单并自动修改库存量，把本次进货的信息添加到进货库中。 2. 退货:顾客把己买的书籍退还给书店。输出一份退货单并自动修改库存量，把本次退货的信息添 加到退货库中。 3. 统计:根据销售情况输出统计的报表。一般内容为每月的销售总额、销售总量及排行榜。 4. 销售:输入顾客要买书籍的信息，自动显示此书的库存量，如果可以销售，打印销售单并修改库 存，同时把此次销售的有关信息添加到日销售库中。 根据以上对图书销售的业务描述实现以下要求: 1. 画出数据库ER图; 2. 将ER模型转换为关系数据库表; 3. 在表中添加数据，并用T_SQL语句实现进货、退货、统计和销售的功能。 实验过程: with General surgical common diseases, especially acute peritonitis, obstructive cholangitis and acute Necrotizing pancreatitis of pathophysiological changes, surgical treatment and postoperative complications. Understanding the etiology and pathogenesis of general surgical common diseases. 2. basic requirements (1) learning disease species and the cases number requirements: disease species cases number (?) gastrointestinal surgical disease 5 thyroid, and breast surgical disease 6 Hepatobiliary pancreatic surgical disease 5 (2) basic skills (surgery) requirements: operation technology name cases times (?) management beds 3 Zhang full records writing 5 copies operation Qian check work and surgery pre nuclear book 5 copies abdominal puncture 5 cases participate in general surgical surgery 15 Taiwan difficult medical records or death medical records discussion 5 times (3) language, and teaching, and research, capacity of requirements: familiar general surgical professional medical vocabulary and can Reading English books to guide interns work in general surgery; understanding of professional clinical research methods in general surgery. (B) the Neurology 1. purpose Web master: Mastering the physical examination of the nervous system and neural damage detection, early diagnosis and treatment of intracranial hypertension, Neurology, clinical manifestations, diagnosis, and treatment of common diseases. Be familiar with: the special examination of the nervous system, including EEG, EMG and Transcranial Doppler analysis of operations and report. Understanding the etiology and pathogenesis of neurological diseases. 2. basic 3 实验总结(由学生填写): 教师对学生做实验的评价(下面的表格由教师填写): 评价细目 定性评价 实验准备 充分? 基本充分? 实验态度 认真? 比较认真? 不认真? 实验报告书写 规范? 基本规范? 不规范? 实验报告内容 符合实验要求? 基本符合实验要求? 不符合实验要求? 实验结论 达到实验目的? 基本达到实验目的? 没有达到实验目的? 实验报告成绩: with General surgical common diseases, especially acute peritonitis, obstructive cholangitis and acute Necrotizing pancreatitis of pathophysiological changes, surgical treatment and postoperative complications. Understanding the etiology and pathogenesis of general surgical common diseases. 2. basic requirements (1) learning disease species and the cases number requirements: disease species cases number (?) gastrointestinal surgical disease 5 thyroid, and breast surgical disease 6 Hepatobiliary pancreatic surgical disease 5 (2) basic skills (surgery) requirements: operation technology name cases times (?) management beds 3 Zhang full records writing 5 copies operation Qian check work and surgery pre nuclear book 5 copies abdominal puncture 5 cases participate in general surgical surgery 15 Taiwan difficult medical records or death medical records discussion 5 times (3) language, and teaching, and research, capacity of requirements: familiar general surgical professional medical vocabulary and can Reading English books to guide interns work in general surgery; understanding of professional clinical research methods in general surgery. (B) the Neurology 1. purpose Web master: Mastering the physical examination of the nervous system and neural damage detection, early diagnosis and treatment of intracranial hypertension, Neurology, clinical manifestations, diagnosis, and treatment of common diseases. Be familiar with: the special examination of the nervous system, including EEG, EMG and Transcranial Doppler analysis of operations and report. Understanding the etiology and pathogenesis of neurological diseases. 2. basic