Logical Database Design

Product type

Logical Database Design

SAP Training
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

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
  • Non…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: PL/SQL, Microsoft SQL Server, Oracle, SQL & MySQL, and Oracle 11G.

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.

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

There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.