Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   Data design -- Normalization (http://www.go4expert.com/forums/data-design-normalization-t9390/)

zipwirebe 17Mar2008 04:50

Data design -- Normalization
 
Could someone tell me whats wrong with it??


FIRE_REPORT(FireID,Alarms,Address,FiremanID,Firema nName,FiremanPhone,FiremanHomeStation,StationAddre ss,StationPhone,TruckID,License,TruckHomeStation)
TruckID->License,TruckHome
FireID->Alarms,Address
FiremanID->
FiremanName,FiremanPhone,FiremanHomeStaion,Station Address,StationPhone

FIRE(FireID, Alarms, Address)
FIRESTATION(StationAddress,StationPhone)
FIREMAN(FiremanID,FiremanName,FiremanPhone,Fireman HomeStation)
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


All times are GMT +5.5. The time now is 10:32.