Go4Expert - View Single Post - Boyce-Codd Normal Form

kumaran21

Hi everyone,

Can some please advice me if the below tables are in Boyce-Codd Normal Form.

OWNER (Owner_SSN, Owner_Name, Owner_Address)

OWNER_CONTACT (Owner_SSN, Owner_Telno)

OWNERSHIP (Owner_SSN, Owner_Number, Car_RegNo, Owner_From, Owned_To)

CAR (Car_RegNo, Make, Model, Production_Year, First_Registration, Fuel_Type, Pax_Capacity, First_Purchase_Price, Original_Price.)

INSURANCE (Policy_No, Car_RegNo, Commencement_Date, Renewal_Date, Policy_Amount, Claim_Date, Claim_Amount)

TRAFFIC_VIOLATION (Traffic_ReportNo, Car_RegNo , Violation_Date, Penalty_Type, Driver_Name, Driver_License_No)

ACCIDENT_HISTORY (Accident_HistoryID, Car_RegNo, Accident_Detail, Accident_Date, Accident_Repair_Cost)

SERVICE_HISTORY (Garage_Name, Garage_Address, Car_RegNo , Service_Date, Service_Type, Part_Replaced, Part_Detail)

kumaran21 Newbie Member
30Mar2011,13:29
	Hi everyone, Can some please advice me if the below tables are in Boyce-Codd Normal Form. OWNER (Owner_SSN, Owner_Name, Owner_Address) OWNER_CONTACT (Owner_SSN, Owner_Telno) OWNERSHIP (Owner_SSN, Owner_Number, Car_RegNo, Owner_From, Owned_To) CAR (Car_RegNo, Make, Model, Production_Year, First_Registration, Fuel_Type, Pax_Capacity, First_Purchase_Price, Original_Price.) INSURANCE (Policy_No, Car_RegNo, Commencement_Date, Renewal_Date, Policy_Amount, Claim_Date, Claim_Amount) TRAFFIC_VIOLATION (Traffic_ReportNo, Car_RegNo , Violation_Date, Penalty_Type, Driver_Name, Driver_License_No) ACCIDENT_HISTORY (Accident_HistoryID, Car_RegNo, Accident_Detail, Accident_Date, Accident_Repair_Cost) SERVICE_HISTORY (Garage_Name, Garage_Address, Car_RegNo , Service_Date, Service_Type, Part_Replaced, Part_Detail)