Explore BrainMass
Share

Explore BrainMass

    Astronomy - General Astronomy

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

    On a clear sunny day, the sky above us looks bright blue. In the evening, the sunset puts on a brilliant show of reds, pinks and oranges. Why is the sky blue? What makes the sunset red?

    © BrainMass Inc. brainmass.com October 9, 2019, 10:24 pm ad1c9bdddf
    https://brainmass.com/physics/astronomy/astronomy-general-astronomy-219158

    Solution Preview

    Please see the attachment.

    Motor vehicle maintenance center DMBS & Data Mining
    A well designed database management system (DBMS) and data mining can help a lot to a motor vehicle maintenance center improve its services, and the following tables would be needed in such a database.
    DBMS of a motor vehicle maintenance center:

    Tables needed:
    1. Vehicles
    Vehicle_id
    Manufacturer_code (FK)
    Vehical_type_code(FK)
    Date_of_manufacture
    Capacity_tonnagge
    Passenger_capacity
    Max_speed
    VIN,
    Color,
    Registeration_number,
    Other_vehical_details

    2. Automobiles
    Automobile_id (FK)
    Color_code

    3. Ref_Manufacturers
    Manufacturer_code
    Manufacture_code
    Country_made
    Other_details

    4. Vehical_Maintenance
    Maintenance_id
    Supplier_id(FK)
    Vehical_id(FK)
    Date_from
    Date_to
    Maintenance_notes
    Part_id
    Mechanic_id
    status

    5. Vehical_Ownership
    Vehical_id(FK)
    Date_owned_from
    Owner_id(FK)
    Date_owned_to

    6. Vehical_Owners
    Owner_id
    Frist_name
    Last_name
    Home_phone
    Cell_phone
    Email_id
    Address1
    Address2
    City
    State
    Zip

    7. ...

    Solution Summary

    A Complete write-up is provided in the attached file 'Why the Sky is blue'

    $2.19