Database Design

Additionally, topics such as change control, business rule integration, database security implementation, and legacy database redesign are covered in detail. Examples of SQIL code are shown to portray implementation tasks of a relational database. Examples are compliant with the ANSI standard.

LEARN THE CONCEPTS AND
TECHNIQUES OF DESIGNING
A DATABASE

Create effective entity relationship diagrains
(ERDs) and process models
Integrate business rules and data integrity
Model data and processes to ensure completeness and accuracy
Build tables, the primary RDBMS storage
object
Design views for partitioning, data summarization, security, and performance
Normalize and secure the data
Cover legacy database redesigr
Learn about long-term database management using change control

Contents

• Introduction
  
• Part I Overview of Database Design
  
• Understanding Database Fundamentals
  
• Exploration of Database Models
  
• Database Design Planning
  
• The Database Design Life Cycle
  
• Part II Analyzing and Modeling Business Requirements
  
• Gathering Business and System Requirements
  
• Establishing a Business Model
  
• Understanding Entites and Relationships
  
• Normalization : Eliminating Redundant Data
  
• Entity Relationship Modeling
  
• Modeling Business Processes
  
• Part III Designing Database
  
• Designing Tables
  
• Intergrating Business Rules and Data Integrity
  
• Designing Views
  
• Applying Database Design Concepts
  
• Part IV Life After Design
  
• Implementing Database Security
  
• Change Control
  
• Analysing Legacy Database for Redesign
  
• Appendixes
  
• Sample Physical Database Implementation
  
• Popular Database DesignTools
  
• Database Design Checklists
  
• Sample Database Designs
  
• Sample Table Sizing Worksheet
  
• Glossary
  
• Index