BeginningDatabaseDesignSolutions资源-CSDN文库

需积分: 9 78 浏览量 2018-12-28 14:16:22 上传评论收藏 5.92MB PDF 举报

资源推荐

资源详情

资源评论

Stephens fﬁrs.tex V3 - 10/03/2008 4:09am Page i

Beginning

Database Design Solutions

Introduction ..................................................................... xxiii

Part I: Introduction to Databases and Database Design 1

Chapter 1: Goals of Effective Database Design ..........................................3

Chapter 2: Database Types

......................................................... 23

Chapter 3: Relational Database Fundamentals

........................................ 49

Part II: Database Design Process and Techniques 63

Chapter 4: Understanding User Needs ............................................... 65

Chapter 5: Translating User Needs into Data Models

.................................. 89

Chapter 6: Extracting Business Rules

............................................... 121

Chapter 7: Normalizing Data

....................................................... 137

Chapter 8: Designing Databases to Support Software Applications

..................... 173

Chapter 9: Common Design Patterns

............................................... 185

Chapter 10: Common Design Pitfalls

................................................ 207

Part III: A Detailed Case Study 225

Chapter 11: User Needs and Requirements .......................................... 227

Chapter 12: Building a Data Model

................................................. 245

Chapter 13: Extracting Business Rules

............................................. 263

Chapter 14: Normalization and Reﬁnement

.......................................... 273

Part IV: Implementing Databases (with Examples in Access

and MySQL) 285

Chapter 15: Microsoft Access ..................................................... 287

Chapter 16: MySQL

............................................................... 313

Part V: Advanced Topics 343

Chapter 17: Introduction to SQL.................................................... 345

Chapter 18: Building Databases with SQL Scripts

.................................... 369

Chapter 19: Database Maintenance

................................................ 379

Chapter 20: Database Security

..................................................... 389

Appendix A: Exercise Solutions

.................................................... 403

Appendix B: Sample Database Designs

............................................. 467

Glossary

......................................................................... 487

Index

........................................................................... 497

Stephens fﬁrs.tex V3 - 10/03/2008 4:09am Page vi

Beginning Database Design Solutions

Published by

Wiley Publishing, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

Published simultaneously in Canada

ISBN: 978-0-470-38549-4

Manufactured in the United States of America

10987654321

Library of Congress Cataloging-in-Publication Data

Stephens, Rod, 1961-

Beginning database design solutions / Rod Stephens.

p. cm.

Includes index.

ISBN 978-0-470-38549-4 (978-0-470-38549-4)

1. Database design. 2. Databases. I. Title.

QA76.9.D26S97 2008

005.74 — dc22

2008037282

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any

means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections

107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or

authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood

Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be

addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317)

572-3447, fax (317) 572-4355, or online at

http://www.wiley.com/go/permissions

Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties

with respect to the accuracy or completeness of the contents of this work and speciﬁcally disclaim all warranties,

including without limitation warranties of ﬁtness for a particular purpose. No warranty may be created or extended

by sales or promotional materials. The advice and strategies contained herein may not be suitable for every

situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting,

or other professional services. If professional assistance is required, the services of a competent professional person

should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an

organization or Web site is referred to in this work as a citation and/or a potential source of further information

does not mean that the author or the publisher endorses the information the organization or Web site may provide

or recommendations it may make. Further, readers should be aware that Internet Web sites listed in this work may

have changed or disappeared between when this work was written and when it is read.

For general information on our other products and services please contact our Customer Care Department within the

United States at (800) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.

Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Wrox Programmer to Programmer, and related trade dress

are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its afﬁliates, in the United States and

other countries, and may not be used without written permission. All other trademarks are the property of their

respective owners. Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be

available in electronic books.

剩余531页未读，继续阅读

评论收藏

内容反馈

Weber.Yao

粉丝: 0
资源: 4

Beginning Database Design Solutions

beginning Database design

Beginning Database Design

[Apress] Beginning Database Design From Novice to Professional

Beginning Database Design 数据库入门

Wrox Beginning - Database Design

beginning database design solutions

[电子书] 数据库设计入门经典 (英文版)

Practical Database Programming with Java

Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Wiley - Wrox Beginning - Database Design

数据库设计入门 Wrox+Beginning+-+Database+Design

Beginning MySQL Database Design and Optimization

Beginning Database Design (2006)

Beginning Database Design (2006).pdf

Beginning WF: Windows Workflow in .NET 4.0

Begining SQL

PostgreSQL.Developers.Guide

Oracle Exadata Recipes英文原版

Apress.Beginning.Database.Design.From.Novice.to.Professional.Jan.2007.pdf

Beginning_MySQL_Database_Design__Optimization

Beginning MySQL Database Design and Optimization.pdf

免费下载Navicat15安装包+工具+教程.zip

cmu 15445 2023spring project0

人大金仓驱动包kingbasejdbc.jar V8.6.0、8.8.0驱动jar包

人大金仓8.6.0、达梦8.1.2.79 连接驱动

全国省市县Excel汇总表（免费下载）.xls

最新资源