Service Mining
Not what you're looking for?
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.