Preface.About the Author.Chapter 1. Data: The New Corporate Resource.The History of Data.The Origins of Data.Data Through the Ages.Early Data Problems Spawn Calculating Devices.
Swamped with Data.Modern Data Storage Media.Data in Today''s Information Systems Environment.Using Data for Competitive Advantage.Problems in Storing and Accessing Data.Data as a Corporate Resource.The Database Environment.Chapter 2.
Simple File Storage and Retrieval.What Is Data?Important Objects and Facts.Records and Files.Basic Concepts in Storing and Retrieving Data.Retrieving and Manipulating Data.Disk Storage.The Need for Disk Storage.How Disk Storage Works,File Organizations and Access Methods.
The Goal: Locating a Record.The Index.Hashed Files.Chapter 3. Data Modeling.Introduction.Binary Relationships.What Is a Binary Relationship?Cardinality.
Modality.More About Many-to-Many Relationships.Unary Relationships.One-to-One Unary Relationship.One-to-Many Unary Relationship.Many-to-Many Unary Relationship.Ternary Relationships.Examples.
The General Hardware Company.Good Reading Bookstores.World Music Association.Lucky Rent-A-Car.Chapter 4. The Database Management System Concept.The Database Concept.Data as a Manageable Resource.
Data Integration and Data Redundancy.Multiple Relationships.Data Control Issues.Data Independence.DBMS Approaches.Chapter 5. The Relational Database Model: Introduction.The Relational Database Concept.
Relational Terminology.Primary and Candidate Keys.Foreign Keys and Binary Relationships.Data Retrieval from a Relational Database.Extracting Data from a Relation.The Relational Select Operator.The Relational Project Operator.Combination of the Relational Select and Project Operators.
Extracting Data Across Multiple Relations: Data Integration.Example: Good Reading Bookstores.Example: World Music Association.Example: Lucky Rent-A-Car.Chapter 6. The Relational Database Model: Additional Concepts.Relational Structures for Unary and Ternary Relationships.Unary One-to-Many Relationships.
Unary Many-to-Many Relationships.Ternary Relationships.Referential Integrity.The Referential Integrity Concept.Three Delete Rules.Chapter 7. Logical Database Design.Converting E-R Diagrams into Relational Tables.
Introduction.Converting a Simple Entity.Converting Entities in Binary Relationships.Converting Entities in Unary Relationships.Converting Entities in Ternary Relationships.Designing the General Hardware Company Database.Designing the Good Reading Bookstores Database.Designing the World Music Association Database.
Designing the Lucky Rent-A-Car Database.The Data Normalization Process.Introduction to the Data Normalization Technique.Steps in the Data Normalization Process.General Hardware Company Example.Good Reading Bookstores Example.World Music Association Example.Lucky Rent-A-Car Example.
Testing Tables Converted from E-R Diagrams with Data Normalization.Chapter 8. Physical Database Design.Inputs to Physical Database Design.The Tables Produced by the Logical Database Design Process.Business Environment Requirements.Data Characteristics.Application Characteristics.
Operational Requirements: Data Security, Backup and Recovery.Hardware and Software Characteristics.Physical Database Design Techniques.Adding External Features.Reorganizing Stored Data.Splitting a Table into Multiple Tables.Changing Attributes in a Table.Adding Attributes to a Table.
Combining Tables.Adding New Tables.Example: Good Reading Bookstores.Example: World Music Association.Example: Lucky Rent-A-Car.Chapter 9. Relational Data Retrieval: SQL.SQL Commands.
Building the Data Structure.Data Manipulation Operations.Data Retrieval with the SQL SELECT Command.Introduction to the SQL SELECT Command.Basic Functions.Built-In Functions.Grouping Rows.The Join.
Subqueries.A Strategy for Writing SQL SELECT Commands.Example: Good Reading Bookstores.Example: World Music Association.Example: Lucky Rent-A-Car.Relational Query Optimizer.Relational DBMS Performance.Relational Query Optimizer Concepts.
Cha.