Hi everyone,
I need help in determining functional dependencies of the given entity sets below. I have also included my answers, please check and advice.
Thank you.
[B]OWNER[/B] ([B][U]Owner_SSN[/U][/B], Owner_Name, Owner_Address, {Owner_TelNo})
Owner_SSN -> Owner_Name
Owner_Name -> Owner_Address, Owner_TelNo
[B]CAR[/B] ([U][B]Car_RegNo[/B][/U], Car_Make, Car_Model, Production_Year, First_Registration, Fuel_Type, Pax_Capacity, First_Purchase_Price, Original_Price)
Car_RegNO -> Car_Make, Car_Model
Car_Model -> Car_Make
Car_Make, Car_Model -> Fuel_Type, Pax_Capacity
Production_Year, Car_Make, Car_Model -> First_Purchase_Price, Original_Price
Production_Year -> First_Registration
[B]OWNERSHIP[/B] ([B][U]Owner_SSN[/U][/B], Car_RegNo, Owner_Number, Owner_From, Owned_To)
Owner_SSN -> Car_RegNo
Owner_From, Owned_To -> Owner_Number
[B]ACCIDENT_HISTORY[/B] ([B][U]Accident_HistoryID[/U][/B], Accident_Detail, Accident_Date, Accident_Repair_Cost)
Accident_HistoryID -> Accident_Date
Accident_Date -> Accident_Detail, Accident_Repair_Cost
Accident_Detail -> Accident_Repair_Cost
[B]TRAFFIC_VIOLATION[/B] ([U][B]Traffic_ReportNo[/B][/U], Violation_Date, Penalty_Type, Driver_Name, Driver_License_No)
Traffic_ReportNo -> Violation_Date
Driver_License_No -> Driver_Name
[B]INSURANCE[/B] ([U][B]Policy_No[/B][/U], Insurance_CommencementDate, Policy_RenewalDate, Policy_Amount, Claim_Date, Claim_Amount)
Policy_No -> Insurance_CommencementDate
Insurance_CommencementDate -> Policy_RenewalDate