S Data Modelling and Design

COURSE OUTLINE

MODULE 01 Introduction to Modeling

• Introduction to Modeling
• Why Model?
• Project Phases and Model Transitions
• Function Model Terminology
• Practice 1-1: Identify Key Business Information
• Practice 1-2: Identify Candidate Entities and Attributes

MODULE 02 Create the Entity-Relationship Model

• Create the Entity-Relationship Model
• Identifying Entities
• Identifying Relationships
• Relationship Types
• Uniquely Identifying Entity Instances
• Refactoring Attributes as Entities
• Supertype-Subtype Entities
• Validating Unique Identifiers
• Master-Detail, Classification, and Basket Patterns
• Practice 2-1: Create the Initial ER Model
• Practice 2-2: Verify and Improve the ER Model (Part 01)
• Practice 2-2: Verify and Improve the ER Model (Part 02)

MODULE 03 Normalization

• Normalization
• Relational Database Principles
• ONF to 1NF Transition
• Practices for Lesson 3

MODULE 04 Design and Implement Data Models

• Design and Implement Data Models
• From Analysis to Design to Implementation
• Entity to Table Model Transition
• Single Table Subtype-Supertype Implementation
• Denormalization
• Entity to Unified Modeling Language (UML) Class Model Transition
• Practices for Lesson 4