Data design -- Normalization

Discussion in 'Database' started by zipwirebe, Mar 16, 2008.

  1. zipwirebe

    zipwirebe New Member

    Joined:
    Mar 16, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Could someone tell me whats wrong with it??


    FIRE_REPORT(FireID,Alarms,Address,FiremanID,FiremanName,FiremanPhone,FiremanHomeStation,StationAddress,StationPhone,TruckID,License,TruckHomeStation)
    TruckID->License,TruckHome
    FireID->Alarms,Address
    FiremanID->
    FiremanName,FiremanPhone,FiremanHomeStaion,StationAddress,StationPhone

    FIRE(FireID, Alarms, Address)
    FIRESTATION(StationAddress,StationPhone)
    FIREMAN(FiremanID,FiremanName,FiremanPhone,FiremanHomeStation)
    TRUCK(TruckID,License,TruckHome)
    FIRE_REPORT(FireID,FiremanID,TruckID)

    Referencial Integriety Statements
    FireID in FIRE_REPORT must exist in FireID in FIRE
    FiremanID in FIRE_REPORT must exist in FireID in FIREMAN
    TruckID in FIRE_REPORT must exist in TruckID in TRUCK
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice