《第三章 关系数据库标准语言SQL》由会员分享，可在线阅读，更多相关《第三章 关系数据库标准语言SQL（88页珍藏版）》请在金锄头文库上搜索。
1、第三章 关系数据库标准语言SQL3.1 SQL概述 3.2 学生课程数据库 3.3 数据定义 3.4 数据查询 3.5 数据更新 3.6 视图 3.8 小结Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose
2、Pty Ltd.Date13.1 SQL概述pSQL的特点n1. 综合统一n2. 高度非过程化n3. 面向集合的操作方式n4. 以同一种语法结构提供两种使用方法n5. 语言简洁，易学易用Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 20
3、04-2011 Aspose Pty Ltd.Date25. 语言简捷，易学易用Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date3SQL视图1视图2基本表1基本表2基本表3基本表4
4、存储文件1存储文件2外模式模式内模式SQL语言支持的关系数据库的三级逻辑结构 基本表（Base Table）和视图（View） SQL语言支持数据库的三级模式结构3.1.2 SQL语言的基本概念Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyrigh
5、t 2004-2011 Aspose Pty Ltd.Date4第三章 关系数据库标准语言SQLp3.1 SQL概述p3.2 学生课程数据库 p3.3 数据定义p3.4 数据查询p3.5 数据更新p3.6 视图p3.8 小结Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose P
6、ty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date53.2 学生课程数据库-学生学 号 Sno姓 名 Sname性 别 Ssex年 龄 Sage所 在 系 Sdept2002151 21李勇男20CS2002151 22刘晨女19IS2002151 23王敏女18MA2002151 25张立男19IS(a)StudentEvaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Sl
7、ides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date63.2 学生课程数据库-课程(b)Course课程号课程名先行课学分CnoCnameCpnoCcredit1数据库542数学23信息系统144操作系统635数据结构746数据处理27PASCAL语言64Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Pr
8、ofile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date73.2 学生课程数据库-选课(c)SC学 号课 程 号成 绩SnoCnoGrade200215121192200215121285200215121388200215122290200215122380Evaluation only.Evaluation only. Created with
9、Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date8第三章 关系数据库标准语言SQLp3.1 SQL概述p3.2 学生课程数据库 p3.3 数据定义p3.4 数据查询p3.5 数据更新p3.6 视图p3.8 小结Evaluation only.Evaluation only
10、. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date93.3 数 据 定 义Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profi
11、le 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date103.3.1 模式的定义与删除一 定义模式 CREATE SCHEMA AUTHORIZATION 二 删除模式 DROP SCHEMA Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client P
12、rofile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date11创建、修改、删除数据库创建数据库 CREATE DATABASE 删除数据库 DROP DATABASE Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.
13、0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date123.3.2 基本表的定义、删除与修改 一、定义基本表 CREATE TABLE （ ， ， ）；n：所要定义的基本表的名字n：组成该表的各个属性（列）n：涉及相应属性列的完 整性约束条件n：涉及一个或多个属性 列的完整性约束条件 详细Evaluation only.Evaluation only. Create
14、d with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date13定义基本表（续）p常用完整性约束n主码约束： PRIMARY KEYn唯一性约束：UNIQUEn非空值约束：NOT NULLn参照完整性约束PRIMARY KEY与 UNIQUE的区别？Evaluation
15、 only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date14例题 例5 建立一个“学生”表Student，它由学号 Sno、姓名Sname、性别Ssex、年龄Sage、 所在系Sdept五个属性组成。其中学号
16、不能为 空，值是唯一的，并且姓名取值也唯一。CREATE TABLE Student(Sno CHAR(5) NOT NULL UNIQUE， Sname CHAR(20) UNIQUE， Ssex CHAR(1) ，Sage INT，Sdept CHAR(15)； Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.Date15例题 （续）p例7 建立一个“学生选课”表SC，它由学号S
