normalize a small 3x5 flat table to the highest form

Question

Hi All,

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

---

BI Analyst

Answer 1

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).

David

---

David http://blogs.msdn.com/b/dbrowne/

Answer 2

Thanks, David!

---

BI Analyst

Answer 3

Have 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

Answer 4

No.  It is probably too deep for me to understand.

---

BI Analyst