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 11 results
              1995.00 (CAD)
              Detailed Schedule Information Jul 10 - 12, 2012 Public Classroom Ottawa Canada
              1995.00 (CAD)
              Detailed Schedule Information Jul 31 - Aug 02, 2012 Public Classroom Toronto Canada
              1995.00 (CAD)
              Detailed Schedule Information Jul 31 - Aug 02, 2012 Public Classroom Vancouver Canada
              $1995.00 (USD)
              Detailed Schedule Information Sep 17 - 19, 2012 Public Classroom Dallas, TX
              $1995.00 (USD)
              Detailed Schedule Information Sep 17 - 19, 2012 Public Classroom Seattle, WA
              1995.00 (CAD)
              Detailed Schedule Information Sep 18 - 20, 2012 Public Classroom Ottawa Canada
              1995.00 (CAD)
              Detailed Schedule Information Sep 25 - 27, 2012 Public Classroom Victoria Canada
              $1995.00 (USD)
              Detailed Schedule Information Oct 10 - 12, 2012 Public Classroom Washington, DC
              1995.00 (CAD)
              Detailed Schedule Information Nov 13 - 15, 2012 Public Classroom Ottawa Canada
              $1995.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.
              First   |    Previous   |    1 2 of 2   |    Next   |    Last