Principles of Data Design, Modeling and Management

Catalog Home Business Analysis, Agile/Scrum & DevOps Data Modeling

This course introduces the student to the principles and process of data modeling through the modeling cycle from modeling business object, through logical modeling and into the specific features of relational data modeling. The course presents topics such as the techniques of logical and business data modeling, how to incorporate business requirements into a logical data model, how to diagram the data models using ER diagrams and UML, how to normalize data and handle complex relationships within a relational model and some considerations for transforming the logical design into a physical design.

Students must have a general understanding of information technology and database concepts.

3 Days/Lecture & Lab

This course is designed for Business Analysts, Application Developers/Analysts, Business Analysts, Project Leaders and Data/Database Administrators.

  • Introduction to logical data modeling
  • Business requirements
  • Entities
  • Relationships
  • Attributes and normalization
  • Resolving many-to-many relationships
  • Subtypes and supertypes
  • Recursive relationships
  • Appendix implementing a relational database
  • Putting it all together




< >

Copyright © 2018 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media