Purchase Solution

Service Mining

Not what you're looking for?

Ask Custom Question

Please explain how a databses management system (DBMS) and data mining can help a motor vehicle maintenance center improve its services, and what tables would be needed in such a database. Also what additional way can the DBMS and data mining be used to imporve customer service.

Purchase this Solution

Solution Summary

This solution of 584 words defines data mining, motor vehicle maintenance center and how DBMS and data mining are used to improve customer service.

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

Purchase this Solution


Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Basic Networking Questions

This quiz consists of some basic networking questions.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.