Needs repairNot in 3NF: 2 transitive dependencies
Candidate key{order_id, sku}
Tables out4
Chaselossless
| Table | Key | Rows | Status |
|---|---|---|---|
| orders | order_id | 1,204 | 3NF |
| customers | customer_id | 311 | 3NF |
| order_lines | order_id, sku | 4,870 | 3NF |
| legacy_view | (none) | 88 | Refused |
Status chips: ok needs repair refused insufficient
git clone https://github.com/dbccpage/simplex-normal-forms.git pip install -e . pytest