This advanced course teaches the student
what the best (and worst) practices in Logical Database Design (covers both ENSCRIBE and NonStop SQL/MP)
Should the data be normalized? Is third normal form enough, or too much?
What are Entity Relationships, and how do I diagram them?
This course is designed for senior Programmers, Analysts, Application Designers,
DBAs, System Managers and those who want to fully understand the thoughts and methods behind proper
entity relationships, logical database design, and how and when to get the User involved.
It will cover Entity Design, Database Normalization, best/worst practices.
This courses is sold individually, or as a part of the three-course bundle.
NonStop Database Best Practices Combined Course )
Online: Self-Paced, includes Instructor Support
On-Site: 1 day
Those senior Programmers, Application Designers, Analysts, DBAs and others
who need to learn about Logical Database Design, Normalization, understanding
using Entity Relationship diagrams, and mapping those diagrams to tables.
- Logical Database Design
- Database Normalization
- Entity Relationship Diagrams, and Relationship Cardinalities
- The Relationships as Tables
- Minimum of 2 years experience on Tandem NonStop systems.
- Minimum 2 years hands-on experience with NonStop Databases (ENSCRIBE and/or NonStop SQL/MP).
- Logical Database Design Module
- Basic Components
- Design Methodologies
- Design Best Practices
- Business Perspectives
- User Involvement
- Design Worst Practices
- Database Normalization Module
- Logical Relational Design
- When to Normalize
- When to De-Normalize
- Steps and examples to Normalization forms
- Normalization up to 5th Normal Form, when should you stop?
- Entity Relationships Module
- Relationship Cardinalities
- ER Diagrams
- Unary, Binary, Tenary and n-ary Relationships
- Unary and Binary Relationships as tables
- Key mapping