(Ebook) Data Modeling A Beginner Guide 1st Edition by Andy Oppel ISBN 0071623981 9780071623988

(Ebook) Data Modeling A Beginner Guide 1st Edition by Andy Oppel ISBN 0071623981 9780071623988

(Ebook) Data Modeling A Beginner Guide 1st Edition by Andy Oppel - Ebook PDF Instant Download/Delivery: 0071623981, 9780071623988
Full download (Ebook) Data Modeling A Beginner Guide 1st Edition after payment

Product details:

ISBN 10: 0071623981 
ISBN 13: 9780071623988
Author: Andy Oppel

(Ebook) Data Modeling A Beginner Guide 1st Table of contents:

Part I Data Modeling Concepts
1 Introduction to Data Modeling
Data-Centric Design
Anatomy of a Data Model
Layers of Data Abstraction
Types of Data Models
Importance of Data Modeling
Documentation of Business Rules
Visualization
Illustration of Alternatives
Foundation for Future Expansion
Promotion of Common and Standard Structures
Provisions for Automation
Measures of a Good Data Model
Enforcement of Business Rules
Flexible and Adaptable
Easily Understood
Balanced Perspective
Promotion of Data Reusability
Data Integration
How Data Models Fit Into Application Development
Process-Oriented Methodologies
Data-Oriented Methodologies
Hybrid Methodologies
Object-Oriented Methodologies
Prototyping Methodologies
Agile Methodologies
Data Modeling Participants
Try This 1-1: Refining a Conceptual Model
Chapter 1 Self Test

2 Relational Model Components
Conceptual and Logical Model Components
Entities
Attributes
Relationships
Business Rules
Physical Model Components
Tables
Columns and Data Types
Constraints
Integrity Constraints
Views
Try This 2-1: Conceptual Model Modification
Chapter 2 Self Test

3 Data and Process Modeling
Data Model Diagramming Alternatives
ERD Formats
Representing Supertypes and Subtypes
Guidelines for Drawing ERDs
Process Models
The Flowchart
The Function Hierarchy Diagram
The Swim Lane Diagram
The Data Flow Diagram
Unified Modeling Language (UML)
UML Class Diagrams
Other UML Diagrams
Relating Entities and Processes
Try This 3-1: Drawing a Conceptual Model with Nested Subtypes
Chapter 3 Self Test

4 Organizing Database Project Work
The Traditional Life Cycle
Planning
Requirements Gathering
Conceptual Design
Logical Design
Physical Design
Construction
Implementation and Rollout
Ongoing Support
Nontraditional Life Cycles
Prototyping
Rapid Application Development
The Project Triangle
Try This 4-1: Project Database Management Tasks
Chapter 4 Self Test

Part II Data Modeling Details
5 Conceptual Data Modeling
The Conceptual Modeling Process
Preparation
Solution Design
What Differentiates Conceptual Modeling from Logical Modeling?
Creating the Model
Generic Models and Patterns
Roles vs. Subtypes
Dealing with Hierarchies, Networks, and Linked Lists
Bottom Up vs. Top Down Modeling
Subject Areas
Evaluating the Model
What Makes a Good Conceptual Model?
Try This 5-1: Conceptual Model for International Addresses
Chapter 5 Self Test

6 Logical Database Design Using Normalization
The Need for Normalization
Insert Anomaly
Delete Anomaly
Update Anomaly
Applying the Normalization Process
Choosing a Primary Key
First Normal Form: Eliminating Repeating Data
Second Normal Form: Eliminating Partial Dependencies
Third Normal Form: Eliminating Transitive Dependencies
Denormalization
Practice Problems
Try This 6-1: UTLA Academic Tracking
The User Views
Try This 6-2: Computer Books Company
The User Views
Chapter 6 Self Test

7 Beyond Third Normal Form
Advanced Normalization
Boyce-Codd Normal Form
Fourth Normal Form
Fifth Normal Form
Domain-Key Normal Form (DKNF)
Resolving Supertypes and Subtypes
Generalizing Attributes
Alternatives for Reference Data
Common Code Structures
Crosswalk Tables
Language Translation Tables
Try This 7-1: Complex Logical Data Model
Chapter 7 Self Test

8 Physical Database Design
The Physical Design Process
Designing Tables
Try This 8-1: Drawing a Physical Data Model
Implementing Supertypes and Subtypes
Naming Conventions
Integrating Business Rules and Data Integrity
NOT NULL Constraints
Primary Key Constraints
Referential (Foreign Key) Constraints
Unique Constraints
Check Constraints
Data Types, Precision, and Scale
Triggers
Adding Indexes for Performance
Designing Views
Try This 8-2: Mapping a Logical Model to a Physical Database Design
Chapter 8 Self Test

Part III Design Alternatives
9 Alternatives for Incorporating Business Rules
The Anatomy of a Business Rule
The Origin of Business Rules
Implementing Business Rules in Data Models
Implementing Terms
Implementing Facts
Implementing Derivations
Limitations on Implementing Business Rules in Data Models
Implementing Constraints
Constraints That Cannot Be Shown in Entity Relationship Models
Functional Classification of Business Rules
Definitional Rules
Data Validation Rules
Data Derivation Rules
Cardinality Rules
Referential Integrity Rules
Process Rules
Try This 9-1: Modeling Business Rules
Chapter 9 Self Test

10 Alternatives for Handling Temporal Data
Temporal Data Structures
When Does Time Matter?
Adding History to Data Structures
Processing Rules for History
Handling Deletions
Calendar Data Structures
Business Rules for Temporal Data
Try This 10-1: Adding History to Data Structures
Chapter 10 Self Test

11 Modeling for Analytical Databases
Data Warehouses
OLTP Systems Compared with Data Warehouse Systems
Data Warehouse Architecture
Data Marts
Modeling Analytical Data Structures
OLAP Database Requirements
Data Warehouse Modeling
Data Mart Modeling
Loading Data into Analytical Databases
The Extract Process
The Transform Process
The Load Process
Try This 11-1: Design Star Schema Fact and Dimension Tables
Chapter 11 Self Test

12 Enterprise Data Modeling
Enterprise Data Management
The Case for Data Management
Alternatives to Centralized Data Management
The Enterprise Data Model
What Is an Enterprise Data Model?
The Anatomy of an Enterprise Data Model
Building an Enterprise Data Model
Try This 12-1: Enterprise Conceptual Model Development
Chapter 12 Self Test

Part IV Appendixes
Try This 1-1: Refining a Conceptual Model
Try This 2-1: Conceptual Model Modification
Try This 3-1: Drawing a Conceptual Model with Nested Subtypes
Try This 4-1: The Database Life Cycle
Try This 5-1: Conceptual Model for International Addresses
Try This 6-1: UTLA Academic Tracking
Try This 6-2: Computer Books Company
Try This 7-1: Complex Logical Data Model
Try This 8-1: Drawing a Physical Data Model
Try This 8-2: Mapping a Logical Model to a Physical Database Design
Try This 9-1: Modeling Business Rules
Try This 10-1: Adding History to Data Structures
Try This 11-1: Design Star Schema Fact and Dimension Tables
Try This 12-1: Enterprise Conceptual Model Development

People also search for (Ebook) Data Modeling A Beginner Guide 1st:

data modeling, a beginner's guide
    
data modeling a beginner's guide pdf
    
data modeling a beginner's guide by andy oppel pdf
    
data modeling a beginner's guide by andy oppel
    
data modeling a beginner's guide pdf download