1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Database Normalization

Discussion in 'Database' started by zero3ree, Jun 2, 2010.

  1. zero3ree

    zero3ree New Member

    Joined:
    Jun 2, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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​
     
  2. zero3ree

    zero3ree New Member

    Joined:
    Jun 2, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    My Table didnt layout correctly sorry
     

Share This Page