Lab Task Checklist
Track progress on the required tasks and check the detailed lab guidelines.
π Go to detailed Task boardThis 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.
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).
Track progress on the required tasks and check the detailed lab guidelines.
π Go to detailed Task boardTurn meeting notes into a data structure and organize key entities and relationships (Mermaid ERD).
Enter labAnalyze every mixed term across the project and build a dictionary mapping standard English names and DB column names.
Enter labWhen design specs like the DB schema change, work backward to find API spec and UI impact that must be synced.
Enter labUse changes in Sequence messages to derive key Entities like User, Video and Campaign, and their states.
Enter labSet FKs, Cardinality, 3NF normalization constraints and the source data owner (Owner) for each Domain.
Enter labAudit whether the CRUD data in Sequences exists in the ERD schema and within Domain responsibility boundaries.
Enter labWrite a Decision Log with the results (Why) of key design agreements like DB normalization and why reviewed alternatives were rejected.
Enter assignment roomAnalyze all potential concurrency and referential integrity risks in the designed schema and work out improvements.
Enter assignment roomDesign third normal form (3NF) models and an ERD for large e-commerce order, payment and coupon data.
Enter assignment roomAudit Domain ownership and Flow-ERD consistency for global logistics shipping and history data.
Enter assignment room