Bibliographic record and links to related information available from the Library of Congress catalog.
Note: Contents data are machine generated based on pre-publication provided by the publisher. Contents may have variations from the printed book or be incomplete or contain other coding.
Contents Preface Part One; Relational Database Theory 1. Basic Concepts What is a Database? Database Tools The Relational Model Relational Terminology The Data Model Summary 2. Database Structure Eliminating Redundancy Ensuring Flexibility Basic Principles First Normal Form Second Normal Form Third Normal Form Further Normalization Summary 3. Relationships Terminology Modeling Relationships One-to-One Relationships One-to-Many Relationships Many-to-Many Relationships Unary Relationships Ternary Relationships Relationships of Known Cardinality Summary 4. Data Integrity Integrity Constraints Implementing Data Integrity Summary 5. Relational Algebra Nulls and Three-Valued Logic (One More Time) Relational Operators Set Operators Special Relational Operators Summary Part Two; Dimensional Database Theory 6. Basic Dimensional Concepts The Dimensional Database Model Terminology A Potted History of Business Intelligence Summary 7. Fact Tables The Structure of a Fact Table The Characteristics of a Fact Table Summary 8. Dimension Tables The Structure of a Dimension Table Snowflaking Changing Dimensions Summary Part Three; Designing Database Systems 9. The Design Process Life Cycle Models The Database Design Process A Note on Design Methodologies and Standards Summary 10. Defining the System Parameters Determining the System Goals Determining the Design Criteria Determining the System Scope Summary 11. Defining the Work Processes Determining the Current Work Processes Analyzing the Work Processes Documenting the Work Processes User Scenarios Summary 12. The Conceptual Data Model Identifying the Data Objects Defining Relationships Reviewing Entities Domain Analysis Normalization Summary 13. The Database Schema Systems Architectures Database Schema Components Security Summary 14. Communicating the Design Audience and Purpose Document Structure Executive Summary System Overview Work Processes Conceptual Data Model Database Schema User Interface Change Management Summary Part Four; Designing the User Interface 15. The Interface as Mediator Effective Interfaces Interface Models User Levels Putting Users in Charge Minimizing the Memory Load Being Consistent Summary 16. User Interface Architectures Supporting the Work Processes Document Architectures Summary 17. Representing Entities in Form Design Simple Entities One-to-One Relationships One-to-Many Relationships Hierarchies Many-to-Many Relationships Summary 18. Choosing Form Controls Representing Logical Values Representing Sets of Values Representing Numbers and Dates Representing Text Values Summary 19. Maintaining Database Integrity Classes of Integrity Constraints Intrinsic Constraints Business Constraints Summary 20. Reporting Sorting, Searching, and Filtering Data Producing Standard Reports Producing Ad Hoc Reports Summary 21. User Assistance User Levels Passive Assistance Mechanisms Reactive Assistance Mechanisms Proactive Assistance User Training Summary Glossary Bibliography
Library of Congress Subject Headings for this publication: