Logical Data Modeling also known as Entity/Relationship (E-R) Modeling is a key method for getting a handle on the data requirements of an organization. Logical data models provide a database independent solution to data requirements which then can be driven forward to become effective database designs.
This online training course covers the concepts and notation of logical data modeling and shows the steps needed to create and extend logical data models. Many exercises and examples are included to enhance learning.
In addition, the course goes beyond these fundamentals. The situation where a new data model must be created from scratch is one of many situations, so this course shows how to handle other situations such as: building from industry or canonical data models; extending legacy data models; and extending software package data models. In addition, data model patterns will be introduced such as: history and audit modeling, multi-business unit modeling, codes and reference data, and user defined attributes. Understanding these situations and patterns, is critical to success in data modeling.
You will learn to:
This course is geared towards:
- Create, extend and apply logical data models
- Use data modeling to meet business and performance requirements
- Lead your team through the data modeling process
- Avoid data modeling traps, problems, and time wasters
- Make databases more robust through data modeling
- Effectively communicate data models and database designs to others
- Anyone who will be using or creating data models.
- Business analysts and architects
- Database administrators and analysts
- Data administrators and data modelers
- Information technology managers, project managers
- Application development project team members
Logical Data Modeling Course Outline
DM-05-00 About the Course (7 min)|
DM-05-01 Introduction (54 min)
DM-05-02 Determining Requirements (35 min)
- Introduction to Data Modeling
- The Entity Relationship Model
- Introduction to LDM Methodology
DM-05-03 Modeling Entities & Relationships (36 min)
- Determine Scope and Purpose
- Define Business Subject Areas
- Identify Business Functions
- Identify Data Requirements
DM-05-04 Modeling Attributes & Keys (60 min)
- Modeling Entities
- Modeling Relationships
DM-05-05 Professional Data Modeling (67 min)
- Modeling Attributes
- Modeling Keys
- Rationalizing the Model
- Data Modeling Situations
- Data Modeling Deliverables
- In Conclusion
Click - here - to download a more detailed outline of this course.
This exam tests knowledge and understanding of logical data modeling techniques.
You will be tested in these areas:
- Purpose and benefits of logical data modeling
- Basic concepts and terminology of entity-relationship (E-R) modeling
- Understanding the process of determining requirements
- Understanding and modeling entities
- Understanding and modeling relationships
- Understanding and modeling attributes
- Understanding and modeling keys
- Understanding various advanced logical data modeling situations and patterns
Number of Questions: 25
Time Limit: 50 Minutes
Passing Score: 70%
Once you pass the exam, you will receive a Certificate of Education documenting that you have demonstrated mastery of the topic. Further, the exam counts towards Certified Information Management Professional (CIMP) designation in the Metadata Management track.
We recommend that you take detailed notes and review the course material multiple times before taking this exam. Click here to learn more about CIMP exams.