Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   Boyce-Codd Normal Form (http://www.go4expert.com/forums/boyce-codd-normal-form-t25375/)

kumaran21 30Mar2011 13:29

Boyce-Codd Normal Form
 
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)


All times are GMT +5.5. The time now is 13:56.