Logical Database Design

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

• None

• 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.

Notes

• Course lenght: 10 hours
• Learn to apply consistent methodology in creating a logical database design that is based on the relational data model and confirms to formal standards of normalization.
• Examine techniques for gathering and analyzing business rules, using entity-relationship diagrams to capture conceptual data designs, and modeling business processes with data flow diagrams.
• Study the theoretical foundations of the relational data model and how to apply its principles to produce a fully normalized logical data model and design.

Popular tags

No tags submitted for this course yet