Logical Data Modeling

Send to a Friend

Your Name
Friend's E-mail
Subject
Message
  • Create logical data models to define business and project requirements
  • Explain the purpose, importance, and uses of logical data modeling in the requirements gathering process
  • Describe the elements of data flow diagrams and functional decomposition diagrams and their relationship to logical data models
  • Explain a logical data model to stakeholders
  • Apply logical data modeling to the overall software development life cycle and respond to business management issues
Course Credits
Ace Recommendations
Undergraduate 2 credit hours
Course PDUs
21.0
Course CEUs
2.1
Course CDUs
21 BABOK V2.0 used in the CDU approval of this course

** Important: Credits may vary by delivery method, click here for more information

Logical Data Modeling explores business rules, policies and procedures and how they can be modeled effectively. Participants will learn entity relationship diagramming, super and sub-types, attributive and associative entities, and documenting data constraints. The logical data modeling approaches focus on the important requirements of the business that are discovered through significant user involvement during the analysis phase. You will also learn how to create models without being limited by technology or organizational structure.

The ability to communicate the intersection of business processes and information/data needs is key to the success of any software development project. Understanding and explaining user needs is a major challenge and opportunity for the business analyst. The business analyst who understands structured modeling has a distinct advantage in addressing and communicating requirements. And the use of models can greatly increase all stakeholders’ understanding of the relevancy of business rules and data management requirements to the project at hand.

Reminder: Prior to taking this course, you should have acquired the background as taught in How to Gather and Document User Requirements, Process Modeling Management and Use Case Modeling.

This course is aligned with version 2.0 of the Guide to the Business Analysis Body of Knowledge (BABOK)™.

 

  • Data Flow Diagrams (DFDs) and Functional Decomposition Diagrams (FDDs)
      • Developing DFDs and FDDs
      • Identifying the business area
      • Modeling essential business processes (FDDs)
      • Documenting data use in business processes (DFDs)
      • Understanding their relationship to logical data models
    1. Identifying and Describing the Conceptual Data Model
        • Naming entities, attributes and relationships
        • Discovering and defining entities
        • Analyzing attributes
        • Defining cardinality in relationships
        • Understanding concatenated and surrogate unique identifiers
      1. The Logical Data Model
          • Developing the detailed logical data model
          • Identifying and applying entity types
          • Modeling with subtypes and supertypes
          • Understanding attributive and associative entities
          • Understanding multivalued attributes
          • Documenting the logical data model
          • Analyzing data using the CRUD matrix
        1. Context-Level Data Flow Diagrams
            • Developing diagrams that represent processes, external agents and data flows
            • Defining and naming diagram components
            • Drawing divergent and convergent data flows
            • Leveling the data flow diagram
            • Avoiding common errors in diagramming
          1. The Transition to OO/UML
              • Understanding the Unified Modeling Language (UML)
              • Applying use case, class state and activity diagrams
            1. Other Key Topics
                • Applying normalization rules
                • Understanding the physical data model
                • Describing the functions and benefits of CASE tools
                • Verifying and presenting models to increase project success

               


              "All ESI instructors are highly experienced and very good at applying concepts to real-world examples."

              Tracy Lebean, Business Analyst
              Gtech

              Find a Course

              Geographic Area:
              select
              Location:
              select
              Delivery Method:
              select
              Search Results
              Results per page:
              select
              Sort by:
              select
              Your search provided the following 8 results
              WINTER PROMOTION- 20% off list price & free e-Training course. Price reflects offer.
              1595.00 (CAD)
              Detailed Schedule Information Mar 12 - 14, 2012 Public Classroom Ottawa Canada
              Early Bird Promotion - Limited time offer. Full Price $1995. Price reflects offer.
              $1595.00 (USD)
              Detailed Schedule Information Mar 19 - 21, 2012 Public Classroom San Francisco, CA
              GUARANTEED TO RUN - Early Bird Promotion. Expires 2/29/12. Full Price $1995. Price reflects offer.
              $1595.00 (USD)
              Detailed Schedule Information Apr 23 - 25, 2012 Public Classroom Washington, DC
              1995.00 (CAD)
              Detailed Schedule Information May 23 - 25, 2012 Public Classroom Ottawa Canada
              Early Bird Promotion. Expires 6/30/12. Full Price $1995. Price reflects offer
              $1595.00 (USD)
              Detailed Schedule Information Sep 17 - 19, 2012 Public Classroom Dallas, TX
              Early Bird Promotion. Expires 6/30/12. Full Price $1995. Price reflects offer.
              $1595.00 (USD)
              Detailed Schedule Information Sep 17 - 19, 2012 Public Classroom Seattle, WA
              Early Bird Promotion. Expires 8/31/12. Full Price $1995. Price reflects offer.
              $1595.00 (USD)
              Detailed Schedule Information Oct 10 - 12, 2012 Public Classroom Washington, DC
              Early Bird Promotion. Expires 8/31/12. Full Price $1995. Price reflects offer.
              $1595.00 (USD)
              Detailed Schedule Information Nov 28 - 30, 2012 Public Classroom Morristown, NJ
              ** All times are local to where the class is held unless otherwise noted.