数据库设计与开发

数据库设计与开发
作 者: 弗罗斯特
出版社: 清华大学出版社
丛编项:
版权说明: 本书为公共版权或经版权方授权,请支持正版图书
标 签: 数据库理论
ISBN 出版时间 包装 开本 页数 字数
未知 暂无 暂无 未知 0 暂无

作者简介

暂缺《数据库设计与开发》作者简介

内容简介

你将开始数据库课程的学习。对于这门课程,许多书都提供了不同的学习方法,如何进行选择呢?不当的书会使本课程变得令人头脑麻木。你需要一本理论上通俗易懂,开发方法上简单直接的书;你需要一本使用实际商业例子的书,你更需要一本有趣又吸引人的书。《数据库设计与开发(影印版)》正是如此。《数据库设计与开发(影印版)》以循序渐进的方式,由浅入深地介绍了关系数据库的理论和设计方法,并结合商业开发上的技术和经验,选取不同平台上具有代表性的范例,介绍了在Oracle、MS Access和MS SQL Server中使用SQL进行数据库设计和开发的方法。 《数据库设计与开发(影印版)》内容全面、技术实用且先进、叙述深入浅出,语言生动有趣,图文并茂,使其跳脱了技术类书籍的枯燥烦闷,其内容、讲授方法、选用的示例以及课后练习别具特色,是一本很好的数据库教材。

图书目录

Chapter 1: The Role of Databases in Electronic Business

 Learning Objectives

 Introduction

 Components of an Organizational System

Network

Hardware

Software

Content

 What Is a Database?

 Why Are Databases Important to Business?

General Business Example

E-business Example

 Organization of the Text

 Summary

 Key Terms

 Exercises

Review

Discuss

Practice

Chapter 2: Relational Theory

 Learning Objectives

 Introduction

 Relational Model

Relational Databa.se Management System (RDBMS)

Database Administrator (DBA)

Entity Relationship Diagrams

Primary Keys

Creating Relationships: Foreign Keys

Data Integrity

First Normal Form

Types of Database Systems

Relational Advantages

Logical Rather Than Physical Links

Fourth-Generation Language (4GL)

Data Independence

Summary

Key Terms

Exercises

Review

Discuss

Practice

References

Chapter 3:Conceptual Design

Learning Objectives

Introduction

Step 1:Represent Entities as Tables

Step 2:Determine Relationships

Step 3:Lisl Fields

step 4:Identify Keys

Step 5:Determining Data mypes

Designing a Single—Table Database

Problem Statemenl

Process

Designing a Database with a One-to-Many Relationstip

Problem Statemenl

Process

Database with Many-to-Many Relationships

Problem Statement

Other Multitable Database Examples

The HospitaI Database

The ACME Database

The Amazon Database

Summary

KeyTerms

Exercises

Review

Discuss

Practice

Chapter 4:Normalization

Learning Objectives

Introduction

NormaI Forms

Denormalized Designs

Normalizing the Arcade Database

Update Problem

lnsert Problem

The Normal Forms

First NormaI Form 1 NF)

Determinants

Second Normal Form(2NF)

Third NormaI Form f3NF)

Boyce-Codd NormaI Form(BCNF)

Fourth NormaI Form(4NF)

Detecting Normaiization Violations

Summary

……

Chapter 5:Advanced Database Designs

Chapter 6:Creating Databased with Oracle Using SQL

Chapter 7:Retrieving Data with Oracle

Chapter 8:Creating Databases with Microsoft Acccess

Chapter 9:Retrieving Data with Microsoft Access

Chapter 10:Creating Databases with Microsoft SQL Server

Chapter 11:Retrieving Data with SQL Server

Chapter 12:Accessing Databases from Web Applecetions with Microsoft AST.NET

Chapter 13:Maintaining Databases from Web Applections with Microsoft ASP.NET