Data Modeling

·Identify entities, relationships and attributes.

·Normalize entities to fifth normal form.

·Handle complex relationships: Many-to-many, Sub-types, Super-types & Recursive

•Document the data model with an Entity/Relationship diagram

Describe some of the benefits and advantages of performing logical data modeling.

Explain the distinction between logical data modeling and physical database design.
Apply a repeatable four-step process for doing logical data modeling
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.

Course Curriculum

Logical Data, Entities and Relationship

Available in days

days after you enroll

Attributes and Normalization

Available in days

days after you enroll

Subtypes and Super Types

Available in days

days after you enroll

sub types and super types (187:54)

Recursive Relationships

Available in days

days after you enroll

Choose a Pricing Option

$399

Data Modeling eLearning

180 Days Access to the e-learning

To provide you the best learning experience, the training is delivered through recorded videos of past training.

You should view these videos as if you are participating in the training. You should think of answers of your own for every discussion question and complete the workshop case study.