1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Boyce-Codd Normal Form

Discussion in 'Database' started by kumaran21, Mar 30, 2011.

  1. kumaran21

    kumaran21 New Member

    Joined:
    Mar 30, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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)
     

Share This Page