Explore BrainMass

Explore BrainMass

    Data Normalisation

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1. In a car garage, how would you describe the relationship between vehicles and service, MOT or repairs. Is it one to many or many to many?

    2. Same question for car parts and repairs.

    3. How about repairs and accidents. Can one say it is a one to one relationship?

    © BrainMass Inc. brainmass.com December 24, 2021, 6:50 pm ad1c9bdddf
    https://brainmass.com/computer-science/data/data-normalisation-relationship-described-143279

    SOLUTION This solution is FREE courtesy of BrainMass!

    1. In a car garage, how would you describe the relationship between vehicles and service, MOT or repairs. Is it one to many or many to many?

    One car may need many services
    Many cars may need the same service
    ----------------------------------------------
    Therefore it is many to many relation.

    2. Same question for car parts and repairs.

    One car part may be used in many repairs
    Many car parts may be used in the same repairs
    --------------------------------------------------------
    Therefore it is many to many relation.

    3. How about repairs and accidents. Can one say it is a one to one relationship?

    One repair may be needed after many accidents
    Many repairs may be needed by the same accident
    -----------------------------------------------------------
    Therefore it is many to many relation.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    © BrainMass Inc. brainmass.com December 24, 2021, 6:50 pm ad1c9bdddf>
    https://brainmass.com/computer-science/data/data-normalisation-relationship-described-143279

    ADVERTISEMENT