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

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