Items related to 工业和信息化人...
Synopsis
《工业和信息化人才培养规划教材·高职高专计算机系列：数据库应用技术·SQLServer2008R2（第2版）》首先介绍数据库系统的基本知识、需求分析、概念设计和逻辑设计的方法。其后分别介绍SQLServer2008R2的基本功能、安装与配置，使用SSMS和T-SQL语句创建和管理数据库、表、索引和视图，T-SQL的SELECT数据查询，T-SQL编程基础、创建与管理存储过程、触发器和用户定义函数。最后介绍SQLServer2008R2的数据库安全管理技术、备份与还原技术、导出与导入技术。《工业和信息化人才培养规划教材·高职高专计算机系列：数据库应用技术·SQLServer2008R2（第2版）》浓缩了作者多年来的教学与科研经验，将理论融入数据库系统开发与维护工作过程，以案例和项目任务为载体，按照职业岗位能力要求和行业实用技术编写，体现了高职高专教材应有的特色与品质。本书可作为高职院校计算机类专业和其他本科院校数据库应用技术课程的教材，也可供数据库开发与维护的工程技术人员自学参考。第1章数据库系统认知1.1数据管理技术的产生和发展1.1.1数据处理的基本概念1.1.2数据管理技术的发展1.2数据库系统概述1.2.1数据库系统的构成1.2.2数据库的体系结构1.2.3数据库管理系统的功能1.3数据模型1.3.1数据模型的基本概念1.3.2数据模型的组成要素1.3.3数据模型的结构分类1.4数据库设计基础1.4.1数据库的设计方法1.4.2数据库的设计步骤1.5项目训练——数据库系统认知思考与练习第2章数据库需求分析与概念设计2.1数据库需求分析案例1-2-1教务管理系统需求分析案例2-2-1图书管理系统需求分析2.2数据库概念设计2.2.1概念模型的基本要素2.2.2概念设计的一般步骤2.3ER方法概念设计2.3.1概念模型的ER表示方法2.3.2概念模型的ER设计过程2.3.3使用Visio建立ER概念模型案例1-2-2教务管理数据库概念设计2.4IDEF1X方法概念设计2.4.1实体（Entity，E）2.4.2属性（Attribute，A）2.4.3联系（Relationship，R）2.4.4使用Visio建立IDEF1X概念模型案例2-2-2图书管理数据库概念设计2.5项目训练——人事管理数据库需求分析与概念设计思考与练习第3章关系模型与数据库逻辑设计3.1关系模型概述3.1.1关系模型的组成要素3.1.2关系模型的特点3.2关系数据结构3.2.1关系的定义3.2.2关系的术语3.3关系数据操作3.3.1传统的集合运算3.3.2专门的关系运算3.3.3综合运算3.4关系数据完整性3.4.1实体完整性约束3.4.2域完整性约束3.4.3参照完整性约束3.4.4用户定义完整性约束3.5概念模型到关系模型的转换3.5.1实体（E）转换为关系的方法3.5.2联系（R）转换为关系的方法案例1-3教务管理数据库逻辑设计3.6关系规范化3.6.1第一范式（1NF）3.6.2第二范式（2NF）3.6.3第三范式（3NF）3.6.4BC范式（BCNF）案例2-3图书管理数据库逻辑设计3.7项目训练——人事管理数据库逻辑设计思考与
"synopsis" may belong to another edition of this title.
Search results for 工业和信息化人...
Stock Image
Industry and Information Technology personnel training planning materials and Higher Vocational Computer Series: database application technology SQL Server 2008 R2 (2)(Chinese Edition)
ISBN 10: 7115292450
ISBN 13: 9787115292452
New
paperback
Seller: liu xing, Nanjing, JS, China
Seller rating 5 out of 5 stars
paperback. Condition: New. Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date: 2013 Pages: 298 in Publisher: People's Posts and Telecommunications Press Industry and Information Technology personnel training planning textbook Higher Vocational Computer Series: database application and the SQL Server 2008 R2 (2) First basic knowledge on database systems. requirements analysis. conceptual design and logic design method. Subsequently introduced the basic functions of the SQL Server 2008 R2 installation and configuration. using SSMS and T-SQL statements to create and manage databases. tables. indexes and views. T-SQL's SELECT data queries. T-SQL programming basics. create a management of stored procedures. triggers. and user-defined functions. Finally. SQL Server 2008 R2 database security management technology. backup and restore technology. export and import of technology. Industry and Information Technology personnel training planning textbook Higher Vocational Computer Series: database application technology and SQL Server 2008 R2 (2) concentrated teaching and research experience of many years. the theory into the database system development and maintenance process. case and project tasks as the carrier. prepared in accordance with the practical techniques of the professional positions capacity requirements and industry. and reflects the characteristics and quality of higher vocational teaching materials should. The book can serve as a vocational school computer class professional and other undergraduate colleges Database Technology Course materials are also available for self-study reference database development and maintenance engineering and technical personnel. Contents: Chapter 1 the database system cognition 1.1 generation of data management technology and basic concepts 1.1.2 Development 1.1.1 Data processing Data Management technology 1.2 database system Overview 1.2.1 database systems constitute 1.2.2 database system elements 1.3.3 data model structure of the data model of the basic concept of the 1.3 data model of the functionality of the database management system of Structure 1.2.3 1.3.1 Data Model 1.3.2 Classification 1.4 database design basis 1.4.1 database design method 1.4.2 1.5 Project database design step training - database systems cognitive thinking and practice Chapter 2 database needs analysis 2.1 Database Requirements Analysis Case 1-2-1 Academic Management System Requirements Analysis Case 2-2-1 library management system conceptual design needs ER conceptual model of general steps of analysis 2.2.2 The conceptual design of the basic elements of the 2.2 database concept design 2.2.1 conceptual model 2.3 ER conceptual design 2.3.1 2.3.2 conceptual model the ER design process 2.3.3 using Visio to create 1-2-2 ER conceptual model case the educational management database concept design 2.4 IDEF1X conceptual design 2.4.1 entity (Entity. E) 2.4.2 attributes (Attribute. A) 2.4.3 Contact (Relationship. R) 2.4.4 to use The Visio establish IDEF1X conceptual model case 2-2-2 library management database conceptual design a 2.5 project training - personnel management database requirements analysis model of the relationship between design thinking and practice with the concept of Chapter 3 of the relational model database logic design 3.1 Overview 3.1.1 relationship model the composed elements 3.1.2 relational model features 3.2-relational data definition of the relationship of the structure 3.2.1 3.2.2 relationship the term 3.3 relational data operation 3.3.1. traditional set operations 3.3.2 specifically the relationship between computing 3.3.3-math 3.4 relational data integrity. entity integrity constraints 3.4.2 3.4.1 domain integrity constraints 3.4.3 referential integrity constraints 3.4.4 User-defined integrity constraint 3.5 conceptual model to a relational model conversion 3.5.1 entity (E) is converted to the relationship method 3.5.2 Contact (R) conversion relatio. Seller Inventory # NE044899