Logical Data Modelling

Course Duration: 3 Days (8:30am-5:00pm)

Professional Development Units (PDU): 21

Continuous Professional Development Points (CPD): 10

Learn How To

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 Synopsis

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.

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.

You'll leave this course ready to communicate business and project requirements to project stakeholders using conceptual and logical data models. In short, you'll be able to integrate multiple business units so that you understand the big picture of your organization.

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.

Course Topics

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
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
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
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
The Transition to OO/UML
Understanding the Unified Modeling Language (UML)
Applying use case, class state and activity diagrams
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

Course Schedule and Fees

Prices below are indicative of Public Courses Only. Discounts apply for groups and on site training. Please call ESI to discuss.

Logical Data Modelling
Date	City
May 21-23 2008	Melbourne	Register
December 1-3 2008	Sydney	Register