MySQL数据库应用项目化微课教程
￥55.00定价
作者： 卢扬
出版社：电子工业出版社
江苏省高等学校重点教材
- 电子工业出版社
- 9787121495946
- 1-1
- 540638
- 67256267-5
- 16开
- 计算机类
- 高职
内容简介
本书采用项目引导结合任务驱动的模式进行编写。全书分为两部分：示范篇和实训篇。 示范篇以"学生成绩管理系统”数据库项目为主线，将该数据库项目分解为多个任务，每个任务按照"知识目标”→"能力目标”→"任务情境”→"任务描述”→"任务分析”→"知识导读”→"任务实施”→"任务总结”的形式进行编排，详细讲述了数据库的设计、MySQL 数据库的创建与管理、MySQL数据库表数据的操作、MySQL 数据库数据的程序式处理、MySQL 数据库的运行与维护。 实训篇以"社区书房管理系统”数据库项目为主线，包括数据库的设计、数据库和表的管理、表数据的更新、表数据的查询、索引的应用、视图的应用、存储过程和存储函数的应用、触发器的应用、数据库的安全管理共 9 个实训任务，重点培养学生提出问题、分析问题和解决问题的综合能力。 本书以培养学生的数据库设计、应用和管理能力为目标，内容新颖，通俗易懂，实用性强，可作为高等院校、高等职业院校数据库相关课程的教材，也可作为广大技术人员及自学者参考用书。
目录
第一篇 示范篇——学生成绩 管理系统 __eol__工作任务一 数据库的设计··············································································· 2 __eol__1.1 初识数据库系统················································································· 2 __eol__1.1.1 数据库系统的基本概念 ······························································· 3 __eol__1.1.2 数据库系统的基本特点 ······························································· 6 __eol__1.1.3 数据库系统的内部体系结构 ························································· 6 __eol__1.2 “学生成绩管理系统”数据库设计概述与需求分析··································· 10 __eol__1.2.1 数据库设计概述········································································ 11 __eol__1.2.2 数据抽象过程··········································································· 12 __eol__1.2.3 数据库设计的需求分析 ······························································ 12 __eol__1.3 “学生成绩管理系统”数据库概念设计·················································· 21 __eol__1.3.1 概念模型················································································· 22 __eol__1.3.2 概念模型的表示方法 ································································· 23 __eol__1.3.3 E-R 模型的设计········································································ 24 __eol__1.4 “学生成绩管理系统”数据库逻辑设计·················································· 26 __eol__1.4.1 关系模型的基本术语 ································································· 27 __eol__1.4.2 关系的定义和性质····································································· 28 __eol__1.4.3 关键码···················································································· 29 __eol__1.4.4 E-R 模型到关系模型的转换························································· 29 __eol__1.4.5 关系模式的规范化····································································· 30 __eol__1.5 “学生成绩管理系统”数据库物理设计·················································· 35 __eol__1.5.1 MySQL 简介············································································ 36 __eol__1.5.2 MySQL 系统数据类型································································ 36 __eol__知识巩固 1 ····························································································· 41 __eol__工作任务二 MySQL 数据库的创建与管理··························································44 __eol__2.1 “学生成绩管理系统”数据库创建和管理··············································· 44 __eol__2.1.1 数据库概述·············································································· 45 __eol__2.1.2 使用 Navicat 图形化工具创建数据库·············································· 46 __eol__2.1.3 SQL 简介 ················································································ 48 __eol__2.1.4 使用 CREATE DATABASE 语句创建数据库 ··································· 48 __eol__VI | MySQL 数据库应用项目化微课教程 __eol__2.1.5 使用 ALTER DATABASE 语句修改数据库 ····································· 51 __eol__2.1.6 使用 DROP DATABASE 语句删除数据库 ······································· 51 __eol__2.2 “学生成绩管理系统”数据表创建························································ 52 __eol__2.2.1 数据表的概述··········································································· 53 __eol__2.2.2 数据完整性·············································································· 54 __eol__2.2.3 数据完整性约束········································································ 54 __eol__2.2.4 使用 Navicat 图形化工具创建数据表·············································· 55 __eol__2.2.5 使用 CREATE TABLE 语句创建数据表·········································· 57 __eol__2.2.6 使用 CREATE TABLE…LIKE 语句复制数据表································ 58 __eol__2.3 “学生成绩管理系统”数据表管理························································ 60 __eol__2.3.1 使用 SQL 语句显示表信息 ·························································· 61 __eol__2.3.2 使用 Navicat 图形化工具修改数据表·············································· 62 __eol__2.3.3 使用 ALTER TABLE 语句修改数据表············································ 63 __eol__2.3.4 使用 ALTER TABLE 语句修改表约束············································ 64 __eol__2.3.5 使用 RENAME TABLE 语句修改表名····························
