Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

A motor vehicle maintenance center wants to improve its services by using database management systems (DBMS) and data mining. What tables are needed in such a database and how can it help improve their services

To find out what tables are needed; first we need to define the entities and attributes associated with this database. A ERD should be created to show the relationships between the entities and attributes. Since this is a motor vehicle maintenance center trying to improve its services, then the entity should be VEHICLE. The entity is an object of interest to the end user. The VEHICHLE entity includes the attributes of VEH_MODEL, VEH_MAKE, VEH_YEAR, VEH_COLOR and VEH_VIN among with many other attributes. To make the database more flexible we can assign a primary key (PK) to the VEH_VIN which will act as an identifier. By typing in the vehicle’s vin number, this can pull up multiple information from the database. Here is an example from

chapter 4 from Entity Relationship (ER) modeling. Below the diagram a multivalued attribute in an entity.

By implementing these tables, entities and attributes, this will help this maintenance center a great deal because, the employees will be able to work more efficiently, effectively and quicker. This can avoid phone calls to other shops or dealerships trying to locate parts or even locating old filed records on vehicles.

testimonials icon
Please turn in at least a two (2) page paper following APA formatting.   Topic: HARVEY CITY C...
testimonials icon
I need someone expert in R Studio. I want him to modify my project. I've  already finished  from the first part and I think it's true. Th...
testimonials icon
Running head: SUBSTANCE ABUSE MEDICATIONFactors that Determine the Appropriateness of Drug Abuse MedicationStudents NameInstitutional Affiliation1SUB...
testimonials icon
Developmental Assessment And School Age Child a href=’https://allaplusessays.com/order Issue/a The needs of th...
testimonials icon
Using the “eyeball” method, the regression line y ̂ = 2+2x has been fitted to the data points (x = 2, y = 1), (x = 3, y = 8), and (x = 4, y =...
testimonials icon
Select one key stage and expand. Four Stages of the Visualization Workflow Do some research and compare the R programming language...
testimonials icon
The directions attached  I prefer you watched an ethnographic film and can WRITE a 3 pages / 10 paragraphs about it ...
testimonials icon
A description of the statistical methods covered in the chapter, what they measure, and under what circum...
testimonials icon
1 Allergic symptoms may cause increased nasal congestion, sneezing, watery eyes, and difficulty in sleeping. What are some of the potential problem...
testimonials icon
COMPANY RESEARCH. Assignment in...
testimonials icon
Alternative analysis involves comparing two or more alternative ways to address a project activity.What tools might you use to compare two o...
testimonials icon
95% confidence Intervals, both the lower limit and the upper limit where the blanks are in the photo of the question....

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65