画鸵萌宠网
所在学院________________班 学 姓
级________________号________________名________________
批阅教师________________
时间：2008.9—2008.12
play levels cadres in enterprise development in the of backbone backbone role; to full strengthening members youth work, full play youth employees in company development in the of force role; to improve independent Commission against corruption work level, strengthening on enterprise business key link of effectiveness monitored. , And maintain stability. To further strengthen publicity and education, improve the overall legal system. We must strengthen safety management, establish and improve the education, supervision, and evaluation as one of the traffic safety management mechanism. To conscientiously sum up the Olympic security controls, promoting integrated management to a higher level, higher standards, a higher level of development. Employees, today is lunar calendar on December 24, the ox Bell is about to ring, at this time of year, we clearly feel the pulse of the XX power generation company to flourish, to more clearly hear XX power generation companies mature and symmetry breathing. Recalling past one another across a railing, we are enthusiastic and full of confidence. Future development opportunities, we more exciting fight more spirited. Employees, let us together across 2013 full of challenges and opportunities, to create a green, low-cost operation, full of humane care of a world-class power generation company and work hard! The occasion of the Spring Festival, my sincere wish that you and the families of the staff in the new year, good health, happy, happy!We will continue to improve the company's internal control system, and steady improvement in ability to manage and control, optimize business processes, to ensure smooth processes, responsibilities in place; to further strengthen internal controls, play a control post independent oversight role of evaluation complying with third-party responsibility; to actively make use of internal audit tools detect potential management, streamline, standardize related transactions, strengthening operations in accordance with law. Deepening the information management to ensure full communication \"zero resistance\". To constantly perfect ERP, and BFS++, and PI, and MIS, and SCM, information system based construction, full integration information system, achieved information resources shared; to expand Portal system application of breadth and depth, play information system on enterprise of Assistant role; to perfect daily run maintenance operation of records, promote problem reasons analysis and system handover; to strengthening BFS++, and ERP, and SCM, technology application of training, improve employees application information system of capacity and level. Humanistic care to ensure \"zero.\" To strengthening Humanities care, continues to foster company wind clear, and gas are, and heart Shun of culture atmosphere; strengthening love helped trapped, care difficult employees; carried out style activities, rich employees life; strengthening health and labour protection, organization career health medical, control career against; continues to implementation psychological warning prevention system, training employees health of character, and stable of mood and enterprising of attitude, created friendly fraternity of Humanities environment. To strengthen risk management, ensure that the business of \"zero risk\". To strengthened business plans management, will business business plans cover to all level, ensure the business can control in control; to close concern financial, and coal electric linkage, and energy-saving scheduling, national policy trends, strengthening track, active should; to implementation State-owned assets method, further specification business financial management; to perfect risk tube control system, achieved risk recognition, and measure, and assessment, and report, and control feedback of closed ring management, improve risk prevention capacity. To further standardize trading, and strive to achieve \"according to law, standardize and fair.\" Innovation of performance management, to ensure that potential employees \"zero fly\". To strengthen performance management, process control, enhance employee evaluation and levels of effective communication to improve performance management. To further quantify and refine employee standards ... Work, full play party, and branch, and members in \"five type Enterprise\" construction in the of core role, and fighting fortress role and pioneer model role; to continues to strengthening \"four good\" leadership construction实 验 一
实验名称数据库的规范化设计实验要求实验设备实验内容：
1.使用SQL语句写出根据下列表格创建Access数据库并输入数据操作内容；
学号
姓名
性别女女女女女女女女女女女女女女女女
出生年月
联系电话
课程号
课程名
成绩675676786585607860608075607580
20000101沈吉洁20000101沈吉洁20000102丁爽20000102丁爽20010101李颖20010101李颖20010101李颖20010101李颖20010101李颖20010101李颖20010102王玉华20010102王玉华20010102王玉华20010102王玉华20010102王玉华20010102王玉华
1982-10-16021-681203041982-10-16021-681203041981-11-15021-324501201981-11-15021-324501201982-9-240771-567036301982-9-240771-567036301982-9-240771-567036301982-9-240771-567036301982-9-240771-567036301982-9-240771-567036301982-10-2021-614242291982-10-2021-614242291982-10-2021-614242291982-10-2021-614242291982-10-2021-614242291982-10-2021-61424229
得分
1．熟悉ACCESS数据库的建库过程
2．理解数据库规范化设计的基本内容
3．根据给定的数据表作出分解，达到规范化的要求
实验地点
000006C语言程序设计000007数据库原理000006C语言程序设计000007数据库原理000001高等数学000003毛泽东思想000005计算机专业英语000006C语言程序设计000007数据库原理000010大学体育000001高等数学000003毛泽东思想000005计算机专业英语000006C语言程序设计000007数据库原理000010大学体育
play levels cadres in enterprise development in the of backbone backbone role; to full strengthening members youth work, full play youth employees in company development in the of force role; to improve independent Commission against corruption work level, strengthening on enterprise business key link of effectiveness monitored. , And maintain stability. To further strengthen publicity and education, improve the overall legal system. We must strengthen safety management, establish and improve the education, supervision, and evaluation as one of the traffic safety management mechanism. To conscientiously sum up the Olympic security controls, promoting integrated management to a higher level, higher standards, a higher level of development. Employees, today is lunar calendar on December 24, the ox Bell is about to ring, at this time of year, we clearly feel the pulse of the XX power generation company to flourish, to more clearly hear XX power generation companies mature and symmetry breathing. Recalling past one another across a railing, we are enthusiastic and full of confidence. Future development opportunities, we more exciting fight more spirited. Employees, let us together across 2013 full of challenges and opportunities, to create a green, low-cost operation, full of humane care of a world-class power generation company and work hard! The occasion of the Spring Festival, my sincere wish that you and the families of the staff in the new year, good health, happy, happy!We will continue to improve the company's internal control system, and steady improvement in ability to manage and control, optimize business processes, to ensure smooth processes, responsibilities in place; to further strengthen internal controls, play a control post independent oversight role of evaluation complying with third-party responsibility; to actively make use of internal audit tools detect potential management, streamline, standardize related transactions, strengthening operations in accordance with law. Deepening the information management to ensure full communication \"zero resistance\". To constantly perfect ERP, and BFS++, and PI, and MIS, and SCM, information system based construction, full integration information system, achieved information resources shared; to expand Portal system application of breadth and depth, play information system on enterprise of Assistant role; to perfect daily run maintenance operation of records, promote problem reasons analysis and system handover; to strengthening BFS++, and ERP, and SCM, technology application of training, improve employees application information system of capacity and level. Humanistic care to ensure \"zero.\" To strengthening Humanities care, continues to foster company wind clear, and gas are, and heart Shun of culture atmosphere; strengthening love helped trapped, care difficult employees; carried out style activities, rich employees life; strengthening health and labour protection, organization career health medical, control career against; continues to implementation psychological warning prevention system, training employees health of character, and stable of mood and enterprising of attitude, created friendly fraternity of Humanities environment. To strengthen risk management, ensure that the business of \"zero risk\". To strengthened business plans management, will business business plans cover to all level, ensure the business can control in control; to close concern financial, and coal electric linkage, and energy-saving scheduling, national policy trends, strengthening track, active should; to implementation State-owned assets method, further specification business financial management; to perfect risk tube control system, achieved risk recognition, and measure, and assessment, and report, and control feedback of closed ring management, improve risk prevention capacity. To further standardize trading, and strive to achieve \"according to law, standardize and fair.\" Innovation of performance management, to ensure that potential employees \"zero fly\". To strengthen performance management, process control, enhance employee evaluation and levels of effective communication to improve performance management. To further quantify and refine employee standards ... Work, full play party, and branch, and members in \"five type Enterprise\" construction in the of core role, and fighting fortress role and pioneer model role; to continues to strengthening \"four good\" leadership construction计算机软件技术课群——数据库技术与应用实验报告
2．指出该表格有哪些不合理的地方（主键、冗余、传递等问题）？
你是如何加以解决的（如何分解，分解的依据）？
分解后如何保持表格的完整性（建立了哪些关系，画图说明）？
实验收获：
play levels cadres in enterprise development in the of backbone backbone role; to full strengthening members youth work, full play youth employees in company development in the of force role; to improve independent Commission against corruption work level, strengthening on enterprise business key link of effectiveness monitored. , And maintain stability. To further strengthen publicity and education, improve the overall legal system. We must strengthen safety management, establish and improve the education, supervision, and evaluation as one of the traffic safety management mechanism. To conscientiously sum up the Olympic security controls, promoting integrated management to a higher level, higher standards, a higher level of development. Employees, today is lunar calendar on December 24, the ox Bell is about to ring, at this time of year, we clearly feel the pulse of the XX power generation company to flourish, to more clearly hear XX power generation companies mature and symmetry breathing. Recalling past one another across a railing, we are enthusiastic and full of confidence. Future development opportunities, we more exciting fight more spirited. Employees, let us together across 2013 full of challenges and opportunities, to create a green, low-cost operation, full of humane care of a world-class power generation company and work hard! The occasion of the Spring Festival, my sincere wish that you and the families of the staff in the new year, good health, happy, happy!We will continue to improve the company's internal control system, and steady improvement in ability to manage and control, optimize business processes, to ensure smooth processes, responsibilities in place; to further strengthen internal controls, play a control post independent oversight role of evaluation complying with third-party responsibility; to actively make use of internal audit tools detect potential management, streamline, standardize related transactions, strengthening operations in accordance with law. Deepening the information management to ensure full communication \"zero resistance\". To constantly perfect ERP, and BFS++, and PI, and MIS, and SCM, information system based construction, full integration information system, achieved information resources shared; to expand Portal system application of breadth and depth, play information system on enterprise of Assistant role; to perfect daily run maintenance operation of records, promote problem reasons analysis and system handover; to strengthening BFS++, and ERP, and SCM, technology application of training, improve employees application information system of capacity and level. Humanistic care to ensure \"zero.\" To strengthening Humanities care, continues to foster company wind clear, and gas are, and heart Shun of culture atmosphere; strengthening love helped trapped, care difficult employees; carried out style activities, rich employees life; strengthening health and labour protection, organization career health medical, control career against; continues to implementation psychological warning prevention system, training employees health of character, and stable of mood and enterprising of attitude, created friendly fraternity of Humanities environment. To strengthen risk management, ensure that the business of \"zero risk\". To strengthened business plans management, will business business plans cover to all level, ensure the business can control in control; to close concern financial, and coal electric linkage, and energy-saving scheduling, national policy trends, strengthening track, active should; to implementation State-owned assets method, further specification business financial management; to perfect risk tube control system, achieved risk recognition, and measure, and assessment, and report, and control feedback of closed ring management, improve risk prevention capacity. To further standardize trading, and strive to achieve \"according to law, standardize and fair.\" Innovation of performance management, to ensure that potential employees \"zero fly\". To strengthen performance management, process control, enhance employee evaluation and levels of effective communication to improve performance management. To further quantify and refine employee standards ... Work, full play party, and branch, and members in \"five type Enterprise\" construction in the of core role, and fighting fortress role and pioneer model role; to continues to strengthening \"four good\" leadership construction实 验 二
实验名称网络数据库应用的设计与实践实验要求
得分
1．熟悉SQL SERVER的环境与设置
2．了解SQL Server数据库与其他数据库数据导入导出操作3．了解SQL Server数据库备份操作4. 会使用系统存储过程查看数据库信息
实验设备实验地点
play levels cadres in enterprise development in the of backbone backbone role; to full strengthening members youth work, full play youth employees in company development in the of force role; to improve independent Commission against corruption work level, strengthening on enterprise business key link of effectiveness monitored. , And maintain stability. To further strengthen publicity and education, improve the overall legal system. We must strengthen safety management, establish and improve the education, supervision, and evaluation as one of the traffic safety management mechanism. To conscientiously sum up the Olympic security controls, promoting integrated management to a higher level, higher standards, a higher level of development. Employees, today is lunar calendar on December 24, the ox Bell is about to ring, at this time of year, we clearly feel the pulse of the XX power generation company to flourish, to more clearly hear XX power generation companies mature and symmetry breathing. Recalling past one another across a railing, we are enthusiastic and full of confidence. Future development opportunities, we more exciting fight more spirited. Employees, let us together across 2013 full of challenges and opportunities, to create a green, low-cost operation, full of humane care of a world-class power generation company and work hard! The occasion of the Spring Festival, my sincere wish that you and the families of the staff in the new year, good health, happy, happy!We will continue to improve the company's internal control system, and steady improvement in ability to manage and control, optimize business processes, to ensure smooth processes, responsibilities in place; to further strengthen internal controls, play a control post independent oversight role of evaluation complying with third-party responsibility; to actively make use of internal audit tools detect potential management, streamline, standardize related transactions, strengthening operations in accordance with law. Deepening the information management to ensure full communication \"zero resistance\". To constantly perfect ERP, and BFS++, and PI, and MIS, and SCM, information system based construction, full integration information system, achieved information resources shared; to expand Portal system application of breadth and depth, play information system on enterprise of Assistant role; to perfect daily run maintenance operation of records, promote problem reasons analysis and system handover; to strengthening BFS++, and ERP, and SCM, technology application of training, improve employees application information system of capacity and level. Humanistic care to ensure \"zero.\" To strengthening Humanities care, continues to foster company wind clear, and gas are, and heart Shun of culture atmosphere; strengthening love helped trapped, care difficult employees; carried out style activities, rich employees life; strengthening health and labour protection, organization career health medical, control career against; continues to implementation psychological warning prevention system, training employees health of character, and stable of mood and enterprising of attitude, created friendly fraternity of Humanities environment. To strengthen risk management, ensure that the business of \"zero risk\". To strengthened business plans management, will business business plans cover to all level, ensure the business can control in control; to close concern financial, and coal electric linkage, and energy-saving scheduling, national policy trends, strengthening track, active should; to implementation State-owned assets method, further specification business financial management; to perfect risk tube control system, achieved risk recognition, and measure, and assessment, and report, and control feedback of closed ring management, improve risk prevention capacity. To further standardize trading, and strive to achieve \"according to law, standardize and fair.\" Innovation of performance management, to ensure that potential employees \"zero fly\". To strengthen performance management, process control, enhance employee evaluation and levels of effective communication to improve performance management. To further quantify and refine employee standards ... Work, full play party, and branch, and members in \"five type Enterprise\" construction in the of core role, and fighting fortress role and pioneer model role; to continues to strengthening \"four good\" leadership construction实验内容：
1．在Windows 2000 Server环境中使用SQL Server，并将上个实验报告建立的Access数据
库导入到SQL Server实例中，写出具体的操作步骤。
2．把导入到SQL Server实例中数据库进行备份，并使用sp_helpdb系统存储过程查看该
数据库信息，写出具体操作过程。
play levels cadres in enterprise development in the of backbone backbone role; to full strengthening members youth work, full play youth employees in company development in the of force role; to improve independent Commission against corruption work level, strengthening on enterprise business key link of effectiveness monitored. , And maintain stability. To further strengthen publicity and education, improve the overall legal system. We must strengthen safety management, establish and improve the education, supervision, and evaluation as one of the traffic safety management mechanism. To conscientiously sum up the Olympic security controls, promoting integrated management to a higher level, higher standards, a higher level of development. Employees, today is lunar calendar on December 24, the ox Bell is about to ring, at this time of year, we clearly feel the pulse of the XX power generation company to flourish, to more clearly hear XX power generation companies mature and symmetry breathing. Recalling past one another across a railing, we are enthusiastic and full of confidence. Future development opportunities, we more exciting fight more spirited. Employees, let us together across 2013 full of challenges and opportunities, to create a green, low-cost operation, full of humane care of a world-class power generation company and work hard! The occasion of the Spring Festival, my sincere wish that you and the families of the staff in the new year, good health, happy, happy!We will continue to improve the company's internal control system, and steady improvement in ability to manage and control, optimize business processes, to ensure smooth processes, responsibilities in place; to further strengthen internal controls, play a control post independent oversight role of evaluation complying with third-party responsibility; to actively make use of internal audit tools detect potential management, streamline, standardize related transactions, strengthening operations in accordance with law. Deepening the information management to ensure full communication \"zero resistance\". To constantly perfect ERP, and BFS++, and PI, and MIS, and SCM, information system based construction, full integration information system, achieved information resources shared; to expand Portal system application of breadth and depth, play information system on enterprise of Assistant role; to perfect daily run maintenance operation of records, promote problem reasons analysis and system handover; to strengthening BFS++, and ERP, and SCM, technology application of training, improve employees application information system of capacity and level. Humanistic care to ensure \"zero.\" To strengthening Humanities care, continues to foster company wind clear, and gas are, and heart Shun of culture atmosphere; strengthening love helped trapped, care difficult employees; carried out style activities, rich employees life; strengthening health and labour protection, organization career health medical, control career against; continues to implementation psychological warning prevention system, training employees health of character, and stable of mood and enterprising of attitude, created friendly fraternity of Humanities environment. To strengthen risk management, ensure that the business of \"zero risk\". To strengthened business plans management, will business business plans cover to all level, ensure the business can control in control; to close concern financial, and coal electric linkage, and energy-saving scheduling, national policy trends, strengthening track, active should; to implementation State-owned assets method, further specification business financial management; to perfect risk tube control system, achieved risk recognition, and measure, and assessment, and report, and control feedback of closed ring management, improve risk prevention capacity. To further standardize trading, and strive to achieve \"according to law, standardize and fair.\" Innovation of performance management, to ensure that potential employees \"zero fly\". To strengthen performance management, process control, enhance employee evaluation and levels of effective communication to improve performance management. To further quantify and refine employee standards ... Work, full play party, and branch, and members in \"five type Enterprise\" construction in the of core role, and fighting fortress role and pioneer model role; to continues to strengthening \"four good\" leadership construction计算机软件技术课群——数据库技术与应用实验报告
实验收获：
play levels cadres in enterprise development in the of backbone backbone role; to full strengthening members youth work, full play youth employees in company development in the of force role; to improve independent Commission against corruption work level, strengthening on enterprise business key link of effectiveness monitored. , And maintain stability. To further strengthen publicity and education, improve the overall legal system. We must strengthen safety management, establish and improve the education, supervision, and evaluation as one of the traffic safety management mechanism. To conscientiously sum up the Olympic security controls, promoting integrated management to a higher level, higher standards, a higher level of development. Employees, today is lunar calendar on December 24, the ox Bell is about to ring, at this time of year, we clearly feel the pulse of the XX power generation company to flourish, to more clearly hear XX power generation companies mature and symmetry breathing. Recalling past one another across a railing, we are enthusiastic and full of confidence. Future development opportunities, we more exciting fight more spirited. Employees, let us together across 2013 full of challenges and opportunities, to create a green, low-cost operation, full of humane care of a world-class power generation company and work hard! The occasion of the Spring Festival, my sincere wish that you and the families of the staff in the new year, good health, happy, happy!We will continue to improve the company's internal control system, and steady improvement in ability to manage and control, optimize business processes, to ensure smooth processes, responsibilities in place; to further strengthen internal controls, play a control post independent oversight role of evaluation complying with third-party responsibility; to actively make use of internal audit tools detect potential management, streamline, standardize related transactions, strengthening operations in accordance with law. Deepening the information management to ensure full communication \"zero resistance\". To constantly perfect ERP, and BFS++, and PI, and MIS, and SCM, information system based construction, full integration information system, achieved information resources shared; to expand Portal system application of breadth and depth, play information system on enterprise of Assistant role; to perfect daily run maintenance operation of records, promote problem reasons analysis and system handover; to strengthening BFS++, and ERP, and SCM, technology application of training, improve employees application information system of capacity and level. Humanistic care to ensure \"zero.\" To strengthening Humanities care, continues to foster company wind clear, and gas are, and heart Shun of culture atmosphere; strengthening love helped trapped, care difficult employees; carried out style activities, rich employees life; strengthening health and labour protection, organization career health medical, control career against; continues to implementation psychological warning prevention system, training employees health of character, and stable of mood and enterprising of attitude, created friendly fraternity of Humanities environment. To strengthen risk management, ensure that the business of \"zero risk\". To strengthened business plans management, will business business plans cover to all level, ensure the business can control in control; to close concern financial, and coal electric linkage, and energy-saving scheduling, national policy trends, strengthening track, active should; to implementation State-owned assets method, further specification business financial management; to perfect risk tube control system, achieved risk recognition, and measure, and assessment, and report, and control feedback of closed ring management, improve risk prevention capacity. To further standardize trading, and strive to achieve \"according to law, standardize and fair.\" Innovation of performance management, to ensure that potential employees \"zero fly\". To strengthen performance management, process control, enhance employee evaluation and levels of effective communication to improve performance management. To further quantify and refine employee standards ... Work, full play party, and branch, and members in \"five type Enterprise\" construction in the of core role, and fighting fortress role and pioneer model role; to continues to strengthening \"four good\" leadership construction数据库实验报告一答案
第一题：
第一步，使用Jet SQL的数据定义语言CREATE TABLE为学生信息管理数据库建立三个表
成绩表设计语言
CREATE TABLE 成绩表(学号 char(8), 课程号 char(6), 成绩 char(4), PRIMARY KEY(学号,课程号));课程表设计语言
CREATE TABLE 课程表(课程号 char (6), 课程名 char(10), PRIMARY KEY(课程号));学生表设计语言
CREATE TABLE 学生表(学号 char(8), 姓名 char(6), 性别 char(2), 出生年月 datetime NOT NULL, 联系电话 char(12), PRIMARY KEY(学号));
第二步、在定义了表的结构之后，在刚刚建立的学生信息管理Access数据库各个表的数据录入窗口中分别输入数据即可。
第二题
首先说一下该表格中的一些不合理的地方。从表格整体来看，其主键一定是“学号”和“课程号”，因为只有这两个属性的组合才能唯一确定该表格中的每一个元组。并且不难看出，属性“姓名”、“性别”、“出生年月”、“联系电话”与主键“学号”是部分函数依赖关系，属性“课程名”与主键“课程号”是函数部分依赖关系，而属性“成绩”则是由两个主键“学号”、“课程号”同时才能确定的，因此，属性“成绩”与主键之间是函数完全依赖关系。分析可知，该表格中多个属性值重复出现，往往表格中一个数据出现错误时，要修改的数据却不只一处且不能有任何遗漏，否则会造成数据的不一致，这就造成了该表格冗余度过大，不易维护。另外，由于表格中完全函数关系的存在，在做插入和删除数据的操作时又会产生异常。
分解方法：将原来的表格分解为三个表格：学生表，由属性“学号”、“姓名”、“性别”、“出生年月”、“联系电话”组成，“学号”为主键；课程表，由属性“课程号”，“课程名”组成，“课程号”为主键；成绩表，由属性“学号”、“课程号”、“成绩”组成，“学号”、“课程号”为主键。分解的依据：在不损失信息的前提下，将一个大的复杂的关系分解为几个小的简单的关系，消除非主属性与主属性之间的部分函数依赖关系。分解后表格完整性的保持：关系图如下
姓名性别学号出生年月课程号联系电话学号成绩课程号课程名play levels cadres in enterprise development in the of backbone backbone role; to full strengthening members youth work, full play youth employees in company development in the of force role; to improve independent Commission against corruption work level, strengthening on enterprise business key link of effectiveness monitored. , And maintain stability. To further strengthen publicity and education, improve the overall legal system. We must strengthen safety management, establish and improve the education, supervision, and evaluation as one of the traffic safety management mechanism. To conscientiously sum up the Olympic security controls, promoting integrated management to a higher level, higher standards, a higher level of development. Employees, today is lunar calendar on December 24, the ox Bell is about to ring, at this time of year, we clearly feel the pulse of the XX power generation company to flourish, to more clearly hear XX power generation companies mature and symmetry breathing. Recalling past one another across a railing, we are enthusiastic and full of confidence. Future development opportunities, we more exciting fight more spirited. Employees, let us together across 2013 full of challenges and opportunities, to create a green, low-cost operation, full of humane care of a world-class power generation company and work hard! The occasion of the Spring Festival, my sincere wish that you and the families of the staff in the new year, good health, happy, happy!We will continue to improve the company's internal control system, and steady improvement in ability to manage and control, optimize business processes, to ensure smooth processes, responsibilities in place; to further strengthen internal controls, play a control post independent oversight role of evaluation complying with third-party responsibility; to actively make use of internal audit tools detect potential management, streamline, standardize related transactions, strengthening operations in accordance with law. Deepening the information management to ensure full communication \"zero resistance\". To constantly perfect ERP, and BFS++, and PI, and MIS, and SCM, information system based construction, full integration information system, achieved information resources shared; to expand Portal system application of breadth and depth, play information system on enterprise of Assistant role; to perfect daily run maintenance operation of records, promote problem reasons analysis and system handover; to strengthening BFS++, and ERP, and SCM, technology application of training, improve employees application information system of capacity and level. Humanistic care to ensure \"zero.\" To strengthening Humanities care, continues to foster company wind clear, and gas are, and heart Shun of culture atmosphere; strengthening love helped trapped, care difficult employees; carried out style activities, rich employees life; strengthening health and labour protection, organization career health medical, control career against; continues to implementation psychological warning prevention system, training employees health of character, and stable of mood and enterprising of attitude, created friendly fraternity of Humanities environment. To strengthen risk management, ensure that the business of \"zero risk\". To strengthened business plans management, will business business plans cover to all level, ensure the business can control in control; to close concern financial, and coal electric linkage, and energy-saving scheduling, national policy trends, strengthening track, active should; to implementation State-owned assets method, further specification business financial management; to perfect risk tube control system, achieved risk recognition, and measure, and assessment, and report, and control feedback of closed ring management, improve risk prevention capacity. To further standardize trading, and strive to achieve \"according to law, standardize and fair.\" Innovation of performance management, to ensure that potential employees \"zero fly\". To strengthen performance management, process control, enhance employee evaluation and levels of effective communication to improve performance management. To further quantify and refine employee standards ... Work, full play party, and branch, and members in \"five type Enterprise\" construction in the of core role, and fighting fortress role and pioneer model role; to continues to strengthening \"four good\" leadership construction数据库实验报告二答案
第一题
操作步骤如下：
1、打开SQL Server 2000企业管理器，依次打开Microsoft SQL Servers- SQL Server组-（local）（Windows NT）；
2、右击“数据库”标签，在弹出的快捷菜单中选择“所有任务-导入数据”，打开“DTS数
据导入/导出向导”对话框，单击“下一步”；3、在“选择数据源”项中选择“Microsoft Access”，在“文件名”中按照一定路径找到想
要导入的文件“sjk实验报告.mdb”，并打开它，单击“下一步”；
4、在“目的”选择项中选择“用于SQL Server的Microsoft OLE DB提供程序”，在“数据
库”选择项中单击“新建”并输入文件名“sjk实验报告”，单击“下一步”，在打开的对话框中按照默认设置再单击“下一步”；5、在“表和视图”-“源”选项中选择“学生表”、“课程表”、“成绩表”单击下一步，在
打开的对话框中按照默认设置再单击“下一步”，继续在新打开的对话框中单击“完成”；
6、等待数据导入，完成后单击“完成”即可。刷新一下数据管理器即可看到“sjk实验报
告”数据库。第二题
备份数据库，具体操作过程如下：：
1、在企业管理器中依次展开“Microsoft SQL Servers”-“SQL Server组”-“（local）
（Windows NT），并选中“数据库”层次，然后在“工具”选项中选择“向导”命令，打开“选择向导”对话框；
2、单击“管理”命令前的“+”号，双击“备份向导”，打开“创建数据库备份向导-（local）对话框，单击“下一步”；
3、在打开的新对话框中选中“sjk实验报告”数据库，单击“下一步”，在打开的对话框中
再单击“下一步”；
4、在“选择备份类型”时，选定“数据库备份-备份整个数据库”单击“下一步”，在“选
择备份目的和操作”中，选择要备份文件的路径及文件名，单击“下一步”；
5、进入“备份验证和调度”界面，单击“更改”按钮，确认备份计划，单击“下一步”，
在新出现的对话框中单击“完成”，在“向导已完成”对话框单击“确定”即可。按照选定的路径查看一下会找到一个名称为“sjk实验报告 备份.BAK”的文件，这就是备份的文件。
用sp_helpdb系统存储过程查看数据库信息，具体操作如下：
打开查询分析器，在文本框重输入“Exec sp_helpdb sjk实验报告”单击窗口上的运行按钮就可以看到有关数据库“sjk实验报告”的各种相关信息了。
play levels cadres in enterprise development in the of backbone backbone role; to full strengthening members youth work, full play youth employees in company development in the of force role; to improve independent Commission against corruption work level, strengthening on enterprise business key link of effectiveness monitored. , And maintain stability. To further strengthen publicity and education, improve the overall legal system. We must strengthen safety management, establish and improve the education, supervision, and evaluation as one of the traffic safety management mechanism. To conscientiously sum up the Olympic security controls, promoting integrated management to a higher level, higher standards, a higher level of development. Employees, today is lunar calendar on December 24, the ox Bell is about to ring, at this time of year, we clearly feel the pulse of the XX power generation company to flourish, to more clearly hear XX power generation companies mature and symmetry breathing. Recalling past one another across a railing, we are enthusiastic and full of confidence. Future development opportunities, we more exciting fight more spirited. Employees, let us together across 2013 full of challenges and opportunities, to create a green, low-cost operation, full of humane care of a world-class power generation company and work hard! The occasion of the Spring Festival, my sincere wish that you and the families of the staff in the new year, good health, happy, happy!
因篇幅问题不能全部显示，请点此查看更多更全内容