AI

ACE AI SW Startup Training

Day 3 AI Lecture Classroom

Day 3 Data Normalization & ERD Design with Codex AI Videos + AI chatbot learning

Data Normalization & ERD Design with a Codex AI Learning Helper

This is the detailed Day 3 learning page. Learn the key Day 3 content from the videos above, and ask the Codex AI chatbot on the right about data normalization, standard term dictionaries, ERD design, schema change impact analysis and finding Edge Cases.

For: students who finished screen planning and data sequence design
Bring: laptop, an ERD tool (Mermaid JS, etc.), Codex Client Workspace
Format: 2h theory / 3h lab / 1h sharing
πŸ“– Go to Session 3 guide

Key Summary Notes

Day 3 Summary

Today's key goals

On Day 3 you align data structures between planning and dev (Task 01), build a standard term dictionary (Task 02), trace schema change impact (Task 03), record design decisions (Mission 01) and find potential Edge Cases (Mission 02).

  • Align data structures (Task 01): pull key entities and cardinality relationships from meeting notes and visualize an ERD
  • Standardize terms (Task 02): create one standard term dictionary for domain words scattered across planning, API and DB column names
  • Share change impact (Task 03): work backward to list API specs and UI components that need fixing when the DB schema changes
  • Record design decisions (Mission 01): log the reasons for database architecture decisions and why alternatives were rejected
  • Find exception scenarios (Mission 02): safe exception design against concurrency errors and broken referential integrity
Learning tip: ask the AI chatbot on the right questions like "What's the difference between 1NF, 2NF and 3NF?" or "How do I prevent referential integrity errors that break foreign key constraints?"

πŸš€ Day 3 Lab MVP Tasks Roadmap

Go to full Task board β†’
TASK 1
AI Agent Task 1

Task 1. Resolve Data Structure Misunderstandings Lab

Turn meeting notes into a data structure and organize key entities and relationships (Mermaid ERD).

Enter lab
TASK 2
AI Agent Task 2

Task 2. Term Standardization Lab

Analyze every mixed term across the project and build a dictionary mapping standard English names and DB column names.

Enter lab
TASK 3
AI Agent Task 3

Task 3. Share Change Impact Lab

When design specs like the DB schema change, work backward to find API spec and UI impact that must be synced.

Enter lab
SKILL 1
Skill Task 1

Derive Entities and States from Sequences

Use changes in Sequence messages to derive key Entities like User, Video and Campaign, and their states.

Enter lab
SKILL 2
Skill Task 2

Design Relationships, Normalization and Data Ownership

Set FKs, Cardinality, 3NF normalization constraints and the source data owner (Owner) for each Domain.

Enter lab
SKILL 3
Skill Task 3

Domain–Flow–ERD Consistency Audit

Audit whether the CRUD data in Sequences exists in the ERD schema and within Domain responsibility boundaries.

Enter lab
MISSION 1
Mission 1

[Assignment] Record Design Decisions

Write a Decision Log with the results (Why) of key design agreements like DB normalization and why reviewed alternatives were rejected.

Enter assignment room
MISSION 2
Mission 2

[Assignment] Find Exception Scenarios

Analyze all potential concurrency and referential integrity risks in the designed schema and work out improvements.

Enter assignment room
MISSION 3
Mission 3

[Assignment] Large-Scale Commerce Order ERD

Design third normal form (3NF) models and an ERD for large e-commerce order, payment and coupon data.

Enter assignment room
MISSION 4
Mission 4

[Assignment] Logistics Delivery Data Audit

Audit Domain ownership and Flow-ERD consistency for global logistics shipping and history data.

Enter assignment room

Day 3 Lecture Videos

Recommended YouTube lectures
A list of recommended YouTube lectures on the key Day 3 topics (database normalization, standard term dictionaries, ERD design, schema change impact, exception design). (All are free lecture videos that allow embedding and playback.)
πŸ“š All lectures (5)
  • β–Ά
    1. Lab: coding ERD data diagrams with Mermaid JS
    11:20
  • β–Ά
    2. Key concepts and design basics of relational databases (RDB)
    11:45
  • β–Ά
    3. Database normalization (1NF, 2NF, 3NF) summary
    6:12
  • β–Ά
    4. Data standardization and building a standard term dictionary
    15:30
  • β–Ά
    5. Impact analysis and exception design for DB schema changes
    30:15