Goals

  • Describe the goals of the database design process
  • Describe the five phases of the design process
  • Gather information about a business using interviews and other techniques
  • Read a data flow diagram
  • Understand the relationship between data flow and business function
  • Define the key terms of data modeling
  • Distinguish among dependent, recursive, and subordinate relationships
  • Read an entity-relationship diagram
  • Complete a conceptual model of a database
  • Define primary keys, foreign keys and artificial keys
  • Learn the rules of data normalization and the five normal forms

Audience

  • Database Designers
  • Application Developers
  • Database Administrators

Prerequisites

Essential

  • None

Recommended

  • None

Content

  • Distinguishing logical database design from physical database design, using PowerDesigner to examine data models, entities, attributes, and relationships, derived and subtype entities, dependent entities, diagramming a conceptual model, converting the conceptual model to a logical model, converting many-to-many, n-ary, and recursive relationships, normalization and the relational data model, normal forms (first, second, third, Boyce-Codd, higher), when to de-normalize, and the next step – where the logical design goes from here.