Absolute Beginner s Guide to Databases.pdf

(11987 KB) Pobierz
TE
Team-Fly
®
AM
FL
Y
Databases
201 West 103rd Street,
Indianapolis, Indiana 46290
Absolute Beginner’s Guide to Databases
Copyright ©2002 by Que
All rights reserved. No part of this book shall be reproduced, stored in a
retrieval system, or transmitted by any means, electronic, mechanical,
photocopying, recording, or otherwise, without written permission from
the publisher. No patent liability is assumed with respect to the use of the
information contained herein. Although every precaution has been taken
in the preparation of this book, the publisher and author assume no
responsibility for errors or omissions. Nor is any liability assumed for
damages resulting from the use of the information contained herein.
International Standard Book Number: 0-7897-2569-X
Library of Congress Catalog Card Number: 2001098154
Printed in the United States of America
First Printing: March 2002
05
04
03
02
4
3
2
1
Associate Publisher
Dean Miller
Acquisitions Editor
Jenny Watson
Development
Editor
Maureen A. McDaniel
Technical Editor
Jim Booth
Managing Editor
Thomas F. Hayes
Project Editor
Tricia Liebig
Production Editor
Trademarks
All terms mentioned in this book that are known to be trademarks or
service marks have been appropriately capitalized. Que cannot attest to
the accuracy of this information. Use of a term in this book should not be
regarded as affecting the validity of any trademark or service mark.
Maribeth Echard
Indexer
Ken Johnson
Proofreaders
Juli Cook
Bob LaRoche
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate
as possible, but no warranty or fitness is implied. The information provided
is on an “as is” basis. The author and the publisher shall have neither
liability nor responsibility to any person or entity with respect to any loss
or damages arising from the information contained in this book.
Team Coordinator
Cindy Teeters
Interior Designer
Kevin Spear
Cover Designer
Trina Wurst
Page Layout
Michelle Mitchell
Contents at a Glance
Introduction, 1
Part I
1
2
Database Basics, 5
An Introduction to Databases, 7
The Anatomy of a Real
Database, 19
Designing and Building Your
First Database, 43
An Introduction to Database
Design, 45
Database Design Continued: An
Introduction to Normalization, 69
Using Access to Build the Time
Entry and Billing Database, 95
Maintaining Your Database—
An Introduction to Database
Integrity, 119
Maintaining Integrity Through
Data Validation Rules, 121
The Basics of Referential
Integrity, 147
Using Your Database to Provide
Information—An Introduction
to SQL, 157
SQL Basics, 159
SQL—Going Beyond the
Basics, 187
Making SQL Queries a Part of Your
Database, 217
Putting Your Database to
Work—Building a Simple Access
Database Application, 235
Building the User Interface
Components, 237
Providing Useful Output: An
Introduction to Creating and
Designing Reports, 263
Appendixes
A
B
C
D
E
The Structure of the TEB
Database, 277
TEB Referential Integrity Rules, 283
Glossary, 285
Database-Oriented Periodicals, 295
Web-Based Resources, 297
Index, 299
Part II
3
4
5
Part III
6
7
Part IV
8
9
10
Part V
11
12

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin