Day 3 AI Classroom | ACE AI Startup Bootcamp

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

Data normalization & ERD design and Codex AI learning assistant

This page is a detailed page for Day 3 study. Learn the key contents of day 3 through the video above, You can ask the Codex AI chatbot on the right about data normalization, standard terminology dictionary, ERD design, schema change impact analysis, and edge case discovery.

Target: Students who have completed screen planning and data sequence design

Required materials: Laptop, ERD design tool (Mermaid JS, etc.), Codex Client Workspace

Composition: 2 hours theory / 3 hours practice / 1 hour sharing

📖 Go to Session 3 teaching plan

Key takeaway notes

Day 3 Summary

Today's Key Goals

Day 3 includes aligning data structures between planning and development (Task 01), building a terminology standardization dictionary (Task 02), tracking the impact of schema changes (Task 03), recording design decisions (Mission 01), and Perform Edge Case Excavation (Mission 02).

Sorting data structures (Task 01): Visualize ERD by extracting key entities and cardinality relationships based on meeting minutes
Terminology standardization (Task 02): Creation of an integrated standard term dictionary of domain vocabulary with fragmented planning, API, and DB column names
Share the impact of change (Task 03): Reverse inference on the list of API specifications and UI components that require modification when DB schema changes
Design Decision Record (Mission 01): Database architecture Logging of decision background and alternative rejection arguments
Excavating Exception Scenarios (Mission 02): Safe exception design that responds to concurrency errors and referential integrity collapse

Study Tip: Get the Right AI Chatbot “What is the difference between 1NF, 2NF, and 3NF?” or “How do I prevent referential integrity errors that break foreign key constraints?” Ask the same question.

🚀 Day 3 Practice MVP Tasks Roadmap

Go to the entire Task board →

🚀

Interactive Board

Practice Task Checklist

Record progress on essential tasks Check out the detailed practice guidelines.

👉 Move to detailed task board

TASK 1

Data Design

Task 1. Practice resolving gaps in data structure understanding

Convert meeting minutes into a data structure and organize key entities and relationships (Mermaid ERD).

Task 1 Entry to the lab

TASK 2

Standardization

Task 2. Terminology standardization practice

We analyze all mixed terms throughout the project and build a dictionary mapping standard English names and DB column names.

Task 2 Entry to the lab

TASK 3

Impact Analysis

Task 3. Practice sharing change impact

When design specifications such as DB schema change, we reverse-analyze the API specifications and UI impact that need to be synchronized.

Task 3 Entry to the lab

MISSION 1

Decision Log

Mission 1. Design decision recording practice

Create a decision log containing the main design agreement results (why), such as DB normalization, and arguments for rejecting the reviewed alternatives.

Mission 1 Lab Entry

MISSION 2

Edge Case

Mission 2. Exception scenario discovery practice

Based on the designed schema, potential concurrency and referential integrity collapse risks are analyzed to derive improvement measures.

Mission 2 Lab Entry

Day 3 lecture video

YouTube Recommended Lectures

This is a list of recommended YouTube lectures corresponding to the core topics of the Day 3 curriculum (database normalization, standard terminology dictionary, ERD design, schema change impact, exception design). (External embedding and playback permitted) It consists of free lecture videos.)

📚 Full list of lectures (5)

▶

1. ERD data diagram coding practice using Mermaid JS

11:20
▶

2. Relational database (RDB) core concepts and design fundamentals

11:45
▶

3. Database Normalization (1NF, 2NF, 3NF) Key Summary

6:12
▶

4. How to standardize data and build a dictionary of standard terms

15:30
▶

5. Impact analysis and exception design when changing DB schema

30:15