I am trying to learn how to Normalize databases. I understand the initial concept but am having a lot of trouble figuring out dependencies. For instance I have this table that had some blank attributes and I have filled them in to make it 1NF I think. But Im not sure what comes next. It seems to me that this table can be broke into three tables and it will be in 3NF as PAT_NUM>RM_NUM , ORDER>COST , PHYSICIAN>OFF_NUM. They seemed to be the only dependents in this table. Am I on the right track? Thanks for any help. Patient Number Room Number Order Cost Physician Office Number 1120 312 Blood Test 45.00 Gray 124 1120 312 X-ray 30.00 Green 112 1320 414 Upper GI 250.00 Brown 213 2143 520 NMRI 2400.00 Gray 124 2143 520 Blood Test 45.00 Gray 124 1432 360 X-Ray 30.00 White 321 1294 420 Blood Test 45.00 Black 104
