Normalization -- DBDesign

[zipwirebe]

Whats wrong with this?? Help?

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

 

[Jeff Boyce]

Why do you think there's something wrong?

Also, I'm having some difficulty envisioning the table/field structure from
your description.

Are you saying that a single FIRE_REPORT can only have one truck and one
firefighter?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Evi]

Is this all the tables in your db? If yes, then it is wrong.
At the very least, you need
a Station table StationID (primaryKey), Station, Station Address
A Fireman table
FiremanID, fireman Names etc, HomestationID (link from StationID in the
StationTable

If this is just a summary, what are the other tables?

Evi