Course Highlights
  • Create Entity Relationship Diagrams by identifying entities, attributes, relationships and constraints from a set of requirements
  • Normalize the Entity Relationship Diagram to third Normal form
  • Develop sound database designs by applying proven data modeling techniques
  • Engineer/Re-engineer the data Models into and from relational database designs
  • Optimize the Relational Database Design for various functional/non functional requirements
  • Work with database change requests and maintain existing databases with the help of tools.
  • Develop data models using ERwin Data Modeler
Curriculum

5 Topics
What is data modeling?
Entity Relationship Model
Notation - Information Engineering(IE) basic symbols
Download and Install ERwin software
ERwin workspace - Model Subject Areas and Diagrams

4 Topics
Relationships - Identifying and Non Identifying
Relationships - Recursive relationships
Relationships - Super types and Sub types
Relationships - Sub types transformations

1 Topic
Data Modeling Exercise - Retail banking system

10 Topics
Diagrams - How to create diagrams with different display elements
Domain Dictionary - How to use domain objects in model
Bulk Editor - How to edit definition of all entities/tables
Forward Engineering - How to generate database schema from model
Reverse Engineering - Creating a data model from database
Naming Standards - Name settings and attaching business glossary
Complete Compare - Compare models and import/export differences
Reporting and Publishing - How to export diagram images
Reporting and Publishing - Entity report using Report Designer
Reporting and Publishing - HTML and PDF export with diagrams

4 Topics
What is dimensional modeling
Creating a star schema - retail sales
Documenting Source to Target mappings and ETL rules
Publishing Source to Target mappings and ETL Rules

6 Topics
Normalization - Introduction
Normalization - First Normal Form Part1
Normalization - First Normal Form Part2
Normalization - Second Normal Form
Normalization - Third Normal Form
Normalization - BCNF

4 Topics
Logical data modeling practice - Public Library
Public Library : Solution
Logical data modeling practice - Transportation services
Transportation Services : Solution

  Write a Review

Data Modeling and Relational Database Design using ERwin

Go to Paid Course