Data Modeling.

Schema design, normalization, and relational patterns. Covers 14 sub-skills.

• Data Modeling · 1 of 3

  Normalization (1NF-3NF, BCNF)

  Which normal form eliminates transitive dependencies?

  ASecond Normal Form (2NF)BBoyce-Codd Normal Form (BCNF)CFirst Normal Form (1NF)DThird Normal Form (3NF)

• Data Modeling · 2 of 3

  Normalization (1NF-3NF, BCNF)

  Given R(A, B, C, D) with FDs {AB → C, C → D, D → A}, what are the candidate keys?

  AAB onlyBAB and CDCABCD is the only candidate keyDAB, BC, and BD

• Data Modeling · 3 of 3

  Denormalization & Read Optimization

  What is the 'real-time materialized view' concept implemented by systems like Materialize and ksqlDB?

  AViews computed when read, which the planner inlines into the query hereBViews held in memory, so a read costs nothing beyond the network hopCViews recomputed on a schedule, so the results lag by a fixed periodDViews kept up to date incrementally, with no refresh command to run