Normalization Applied-Review the TEB Database and Refine the Design 84 Identifying New Columns and Tables 85 Reviewing the TEB Model 91 What You Have Learnedĥ Using Access to Build the Time Entry and Billing Database 95 Automatically Generate the Database from the TEB Model 96 Implement Row-Level Rules 143 Row-Level Properties 143 What You Have Learnedħ The Basics of Referential Integrity What Is Referential Integrity? Third Normal Form: Eliminating Columns Not Dependent on Keys 79 Fourth and Fifth Normal Forms 81 Normalization: Some Final Thoughts 83 Denormalize Data-When Does It Make Sense to Break the Rules? 83 The Sample Northwind Traders Database The Database’s Relationships 22 Overview of the Database’s Components 26 What You Have Learnedĭetermine the Requirements of the Database 47 Interviews 47 Business Forms and Documents 48 Existing Systems 49Ĥ Database Design Continued: An Introduction to Normalization 69 What Does It Mean to Normalize a Database? 70 22 Steps to Normalize Your Data Model 71 First Normal Form: Eliminating Repeating Groups 72 Second Normal Form: Eliminating Redundant Data 73 Model the Time Entry and Billing Database 62 Editing the Text 63 Refining the Design 63 What You Have Learned The Relational Database Model: An Overview 13 Database-Related Careers 17 Database Administrator 17 Database Applications Programmer Database Analyst 18 What You Have Learned Introduction to Database Modeling 50 What Does a Database Model Look Like? 51 Creating Your First Model 52 Creating a Physical Database from the Logical Database Model 60 Creating a Logical Database Model from a Physical Database 61 Typical Database Management Systems Used Today 10 Key Database Terminology 11 Database 12 Tables and Entities 12 Fields, Columns, and Attributes Normalization 12 Rows and Records 12 Primary Key 13 Your Project: A Time Entry and Billing Database 46 II Designing and Building Your First Databaseġ An Introduction to Databases What Is a Database? The Structure of the TEB Database, 277 TEB Referential Integrity Rules, 283 Glossary, 285 Database-Oriented Periodicals, 295 Web-Based Resources, 297 Index, 299 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
SQL Basics, 159 SQL-Going Beyond the Basics, 187 Making SQL Queries a Part of Your Database, 217 Using Your Database to Provide Information-An Introduction to SQL, 157 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.Īn Introduction to Databases, 7 The Anatomy of a Real Database, 19ĭesigning and Building Your First Database, 43Īn 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 The information provided is on an “as is” basis. 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. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark. Que cannot attest to the accuracy of this information. Trademarks All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Library of Congress Catalog Card Number: 2001098154
International Standard Book Number: 0-7897-2569-X Nor is any liability assumed for damages resulting from 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.
No patent liability is assumed with respect to the use of the information contained herein.
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. Databases 201 West 103rd Street, Indianapolis, Indiana 46290Īll rights reserved.
0 kommentar(er)
