Public Class Offerings |
| |
October 14 - 15, 2010 Minneapolis, MN
Schedule a private class at your facility or ours.
Contact us for more information.
|
Overview |
| |
|
This course introduces people to the principles and process of logical data modeling, which is to say translating business data requirements into a graphical representation. It teaches people how to analyze 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 normalize data and handle complex relationships. In short, participants will learn proven, practical skills for analyzing and modeling data requirements, and make them ready to be transformed into a relational database. |
Length |
| |
 |
2 days - 14 PDUs - 14 CDUs - 1.4 CEUs* |
Objectives |
| |
- Describe some of the benefits and advantages of performing logical data modeling.
- Explain the distinction between logical data modeling and physical database design.
- Identify the components of a data model, including entities, relationships and attributes.
- Normalize 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. |
Format |
| |
|
To assimilate the tools and techniques learned, there is a mixture of individual and team exercises throughout the course. A lively role play and case study help reinforce concepts learned. Students need to be prepared for a high level of participation.
Data Modeling uses team-based workshops to practice the skills and techniques presented. Participants begin learning the important process of a team approach to gathering requirements and molding them into a data model. The teams also perform a final lab "project" in which they construct a data model from start to finish. |
Content |
| |
- Introduction to Logical Data Modeling
- Definitions
- Benefits of logical data modeling
- Data modeling vs. physical database design
- Roles involved in data modeling
- Steps in the data modeling process
- Example data model
- Entities
- Identifying entities
- Validating entities
- Documenting "instances" of entities
- Distinguishing entities from attributes
- Naming entities
- Starting an Entity/Relationship (E/R) diagram
- Workshop
- Relationships
- Identifying significant relationships
- Determining the "cardinalilty" or "degree" of a relationship
- One-to-One
- One-to-Many
- Many-to-Many
- Determining whether a relationship is optional or mandatory
- Giving a relationship a name
- Documenting the relationships in the E/R diagram
- Walking people through an E/R diagram
- Workshop
- Resolving Many-to-Many Relationships
- Real-world examples of many-to-many relationships
- Why many-to-many relationships are broken down into simpler relationships
- Identifying "association" or "intersection" entities
- Documenting the new relationships in the E/R diagram
- Workshop
- Attributes and Normalization
- Defining and categorizing attributes
- Domains and integrity rules
- Unique identifiers/primary keys
- Foreign keys
- Occurrence population
- Normalization: validating the placement of each attribute
- Attribute does not repeat (first normal form)
- Attribute is dependent on its entire UID (second normal form)
- Attribute is dependent only on its UID (third normal form)
- Workshop
- Subtypes and Supertypes
- Identifying subtypes: real-world examples of subtypes and supertypes
- Determining when entities are similar
- UIDs
- Attributes
- One-to-one relationships
- Creating subtypes and supertypes
- “Type” entities
- Using subtypes to apply fourth normal form
- Establishing the relationships of the sub- and super-entities to other entities
- Mutually exclusive vs. non-mutually exclusive subtypes
- “Role” entities
- Workshop
- Recursive Relationships
- Real-world examples of recursive relationships
- Discovering recursive relationships
- Determining whether the relationships are optional or mandatory
- Documenting the new relationships in the E/R diagram
- Hierarchical vs. Network recursive relationships
- “Structure” or ”Bill of Materials” entities: fifth normal form
- Workshop
- Appendix: Implementing a Relational Database
- Relational database objects: tables, views, indexes, etc.
- Mapping logical objects to physical objects
- Denormalization
- Distributing databases
- Referential integrity
|
Pre-requisites |
| |
|
A general understanding of information technology and database concepts is required. |
Public Class Tuition |
| |
|
$1395.00
Contact us for private class pricing.
* Students may earn 1.4 CEUs from Auburn University for this course. An additional charge applies. |
Skill
Level |
| |
|
Basic |
PMBOK® Guide Knowledge Areas |
| |
|
Project Scope Management
Project Quality Management |
BABOK® Knowledge Areas |
| |
|
Requirements Analysis |
Related Courses |
| |
|
