|
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:
- 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
This course is geared towards:
- 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)
- Introduction to Data Modeling
- The Entity Relationship Model
- Introduction to LDM Methodology
DM-05-02 Determining Requirements (35 min)
- Determine Scope and Purpose
- Define Business Subject Areas
- Identify Business Functions
- Identify Data Requirements
DM-05-03 Modeling Entities & Relationships (36 min)
- Modeling Entities
- Modeling Relationships
DM-05-04 Modeling Attributes & Keys (60 min)
- Modeling Attributes
- Modeling Keys
DM-05-05 Professional Data Modeling (67 min)
- 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
|
Additional Information
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. Course
exams count towards eLC certification programs. Visit our Certification page for more information about our various programs.
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.
|
|
Course Review 
Course Review 