Course Outline

Introduction to Relational Databases
Learn how to properly design a relational database as you take on the role of a Database Design Architect. Focus on the principles of good database design as you sketch out plans for a useful relational database. 6 hours
Database Terms
  • Tables
  • Primary keys

Relational Database Design

  • Relational Database model
  • Joins and the relational model

Planning a Database

  • Define the purpose
  • Entities and attributes
  • Documenting entities and attributes
    • Identify the tables
  • Domains
    • Define the fields
    • Identify the relationships
    • Test the design
  • Relationships
    • Primary and foreign keys
  • Relational approach
  • Conceptual models
  • R-tables
  • Base tables
  • Derived tables
  • Normalization
Normal Forms
  • Ideal field and table
  • Normalization
    • Eliminate repeating groups
    • Eliminate partial dependencies
    • Eliminate transitive relationships
  • 1st Normal Form
  • 2nd Normal Form
  • 3rd Normal Form

Designing your Database

  • Tasks you want your database to do
  • Collecting information about each task

Common Field Sizes and Types

Building Monsters: Design Philosophy

  • A monster table with all fields

 
Prerequisites:  Microsoft Access or FileMakerPro Level 1 or equivalent experience.
Revised 9/3/08
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600