Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   Database Normalization (http://www.go4expert.com/forums/database-normalization-t22291/)

zero3ree 2Jun2010 07:19

Database Normalization
 
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 2Jun2010 07:21

Re: Database Normalization
 
My Table didnt layout correctly sorry


All times are GMT +5.5. The time now is 13:42.