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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice