Explore BrainMass
Share

Data Normalisation

This content was STOLEN 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 October 24, 2018, 9:57 pm ad1c9bdddf
https://brainmass.com/computer-science/data/data-normalisation-relationship-described-143279

Solution Preview

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 ...

Solution Summary

Types of Relationships among data items are explained.

$2.19
See Also This Related BrainMass Solution

The Relational Model and Data Normalization

1. Define functional dependency and give an example.

2. What are insertion and deletions anomalies?

3. List and briefly describe first, second and third normal form.

4. Describe a one-to-one relationship.

5. Describe the many-to-many attribute relationship.

View Full Posting Details