Database Normalization

zero3ree's Avatar, Join Date: Jun 2010
Newbie Member
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
zero3ree's Avatar, Join Date: Jun 2010
Newbie Member
My Table didnt layout correctly sorry