Thread: Normalize

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    1
    Rep Power
    0

    Normalize


    Can anyone normalize this? I'm confused with all the assumptions...

    FIRE_REPORT(FireID, Alarms, Adddress, FiremanID, FiremanName, FiremanPhone, FiremanHomeStation, StationAddress, StationPhone, TruckID, LicensePlate)

    Assumptions:
    1. each fire can have several firefighters assigned to it
    2. each fire can have several fire trucks assigned to it
    3. each firefighter can be assigned to several fires
    4. each fire truck can be assigned to several fires
    5. each firefighter has a single home station
    6. each station name is unique
    7. each station has a single phone number
  2. #2
  3. Transforming Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    14,130
    Rep Power
    9398
    Are you familiar with terms like "one-to-many" or "many-to-many"?

    A fire can have many firefighters, and a firefighter can be assigned to many fires.
    A fire can have many fire trucks, and a fire truck can be sent to many fires.
    A firefighter can reside in one home station, and a home station can have many firefighters.
    (meanwhile the station name and phone number are just attributes of a station)
  4. #3
  5. Hockey face
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    St. Catharines, Canada
    Posts
    8,147
    Rep Power
    1316
    So you want people to do your homework for you?
    I mean first time you've posted here and you post a homework question with no input at all for what you've tried and telling us where you actually are having problems.

IMN logo majestic logo threadwatch logo seochat tools logo