SAP - Course Details

LDD(SY144e-E) Logical Database Design (SY144e-E)

SAP Course Description:
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
SAP Course Duration:
Self Placed
SAP Course Target Audience:
Database Designers,Application Developers,Database Administrators
SAP Course Prerequisite:
NONE
Course 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.