Saturday, March 02, 2013 7:45 PM
How can I normalize this flat table to the highest form? How many tables would I end up?
Column1 Column2 Column3 b x s b x t c x s c y s c y t
Saturday, March 02, 2013 7:57 PM
Since there are no duplicate rows and no functional dependencies described, the only thing we can tell you is that that table is fully normalized table with key (Column1, Column2, Column3).
- Marked As Answer by BIAnalyst Saturday, March 02, 2013 8:10 PM
Sunday, March 03, 2013 8:57 PM
Monday, March 04, 2013 12:06 AMHave read Chris Date's new book on normalization?
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL
- Marked As Answer by BIAnalyst Monday, March 04, 2013 1:19 AM
Monday, March 04, 2013 1:19 AM
No. It is probably too deep for me to understand.