Fundamentals of Relational Databases

副标题:无

作   者:(美)Ramon A.Mata-Toledo,(美)Pauline K.Cushman著

分类号:

ISBN:9787111104162

微信扫一扫,移动浏览光盘

简介

   Schaum's Outlines give you the information your teachers expect you to know in a handy and succinct format--without ovetwhelming you with unnecessary jargon. You get a complete overview of the subject.Plus, you get plenty of practice exercises to test your skill. Compatible with any classroom text, Schaum's let you study at your own pace and remind you of all the important facts you need to remember--fast! And Schaum's are so complete, they're perfect for preparing for graduate or professional exams.    Inside, you will find:    ' Full coverage of the database system used by most manufacturers including Microsoft and Oracle    ' Complete scripts to create and populate all databases used in the book    ' Labs and practice tests similar to tests currently used in certification exams    ' Language features that are applicable across platforms If you want top grades and a thorough understanding of the fundamentals of relational databases, this powerful study tool is the best tutor you can have!   

目录

CHAPTER 1 An Overview of DBMS and DB Systems Architecture


1.1 Introduction to Database Management Systems

1.2 Data Models

1.3 Database System Architecture


CHAPTER 2 Relational Database Concepts


2.1 Relational Database Management Systems

2.2 Mathematical Definition of a Relation

2.3 Candidate Key and Primary Key of Relation

2.4 Foreign Keys

2.5 Relational Operators

2.6 Set Operations on Relations

2.7 Insertion,Deletion and Update Operations on Relations

2.8 Attribute Domains and Their Implementations


CHAPTER 3 An Introduction to SQL


3.1 Introduction to SQL Language

3.2 Table Creation

3.3 Selections,Projections and Joins using SQL


CHAPTER 4 Functional Dependencies


4.1 Introduction

4.2 Definition of Functional Dependencies

4.3 Functional Dependencies and Keys

4.4 Inference Axioms for Functional Dependencies

4.5 Redundant Functional Dependencies

4.6 Closures,Cover and Equivalence of Functional Dependencies


CHAPTER 5 The Normatization Process


5.1 Introduction

5.2 First Normal Form

5.3 Data Anomalies in INF Relations

5.4 Partial Dependencies

5.5 Second Normal Form

5.6 Data Anomalies in 2NF Relations

5.7 Transitive Dependencies

5.8 Third Normal Form

5.9 Data anomalies in 3NF Relations

5.10 Boyce-Codd Normal Form

5.11 Lossless or Lossy Decompositions

5.12 Preserving Functional Dependencies


CHAPTER 6 Basic Security Issues


6.1 The Need for Security

6.2 Physical and Logical Security

6.3 Design Issues

6.4 Maintenance Issues

6.5 Operating System Issues and Availability

6.6 Accountability

6.7 Integrity


CHAPTER 7 The Entity-Relationship Model


7.1 The Entity-Relationship Model

7.2 Entities and Attributes

7.3 Relationships

7.4 One-to-One Relationships

7.5 Many-to-One and Many-to Many Relationships

7.6 Normalizing the Model

7.7 Table Instance Charts


INDEX

已确认勘误

次印刷

页码 勘误内容 提交人 修订印次

Fundamentals of Relational Databases
    • 名称
    • 类型
    • 大小

    光盘服务联系方式: 020-38250260    客服QQ:4006604884

    意见反馈

    14:15

    关闭

    云图客服:

    尊敬的用户,您好!您有任何提议或者建议都可以在此提出来,我们会谦虚地接受任何意见。

    或者您是想咨询:

    用户发送的提问,这种方式就需要有位在线客服来回答用户的问题,这种 就属于对话式的,问题是这种提问是否需要用户登录才能提问

    Video Player
    ×
    Audio Player
    ×
    pdf Player
    ×
    Current View

    看过该图书的还喜欢

    some pictures

    解忧杂货店

    东野圭吾 (作者), 李盈春 (译者)

    loading icon