Course Duration: 2 days
Professional Development Units (PDU’s): 14
Course Description: This course introduces people to the principles and processes of logical data modelling, which is to translate business data requirements into a graphical representation. It teaches people how to analyse business requirements that should be incorporated into a logical data model, how to create the components of a logical data model, how to diagram/explain them, and how to normalise data and handle complex relationships. In short, participants will learn proven, practical skills for analysing and modelling data requirements, and make them ready to be transformed into a relational database.
Key Learning Objectives:
- describe some of the benefits and advantages of performing logical data modelling
- explain the distinction between logical data modelling and physical database design
- identify the components of a data model, including entities, relationships and attributes
- normalise entities to fifth normal form and select proper unique identifiers (primary keys)
- handle complex relationships:
- many-to-many
- sub-types and super-types
- recursive/’bill of materials’
- document the data model with an entity/relationship diagram and walk through portions of a data model with people to validate it
Audience: This seminar is designed for business analysts, application developers/analysts, project leaders and data/database administrators.
Course Prerequisites: A general understanding of information technology and database concepts is required.
Course Price: For on-site courses please contact Mindavation on 1300 947 572 or e-mail info@mindavation.com. For public courses availability and price see Public Course Schedule.
PMBOK® Guide Knowledge Areas:
- Project Scope Management
- Project Quality Management
BABOK® Knowledge Areas:
- Requirements Analysis
Click here to view course content.