Author |
Topic |
ushynnad
Starting Member
1 Post |
Posted - 2013-10-25 : 18:28:59
|
How it originally started: FIRE_REPORT(FireID, Alarms, Adddress, FiremanID, FiremanName, FiremanPhone, FiremanHomeStation, StationAddress, StationPhone, TruckID, LicensePlate) The 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 numberFIRE_REPORT (FireID, FiremanID, TruckID) (FireID, FiremanID, TruckID) -- (Alarms, Address, FiremanName, FiremanPhone, FiremanHomeStation, StationAddress, StationPhone, LicensePlate) FiremanID -- (FiremanName, FiremanPhone, FiremanHomeStation, StationAddress, StationPhone) FIREMAN (FiremanID, FiremanName, FiremanPhone, FiremanHomeStation) FiremanID in FIRE_REPORT must exist in FiremanID in FIREMAN FireID -- (Alarms, Address) FIRE (FireID, Alarms, Address) FireID in FIRE_REPORT must exist in FireID in FIRE TruckID -- LicensePlate TRUCK (TruckID, LicensePlate) TruckID in FIRE_REPORT must exist in TruckID in TRUCK FiremanHomeStation -- (StationAddress, StationPhone) STATION (FiremanHomeStation, StationAddress, StationPhone) FiremanHomeStation in FIREMAN must exist in FiremanHomeStation in STATION |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-26 : 00:55:45
|
I would have done it like thisFIRE_REPORT (FIREID,FIREMANID,TRUCKID)FIRE (FIREID,Alarms,Adddress)FIREMAN (FiremanID,FiremanName,FiremanPhone,FiremanHomeStationID)STATION (StationID,Station,StationAddress,StationPhone)TRUCK (TruckID,LicensePlate)RelationshipsFIRE_REPORT.FireID -> FIRE.FireIDFIRE_REPORT.FiremanID -> FIREMAN.FiremanIDFIRE_REPORT.TruckID -> TRUCK.TruckIDFIREMAN.FiremanHomeStationID -> STATION.StationID------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|