Car Make, Model, Year, Color Date Acquired Exterior Condition Interior Condition VIN Storage Location, Name, Address Size, Heat/Cool Amount Paid Source Monthly Cost Manufacturer Service Intervals Miles Interval Oil change 3000 Grease frame fittings Tire pressure 15000 Replace spark plugs., Tune-up Rotate tires Grease door fittings Actual Service Records Miles Date Location Service Comments Cost Labor Parts

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

A rich uncle owns about a dozen classic automobiles. He keeps them in several garages around town and actually drives them for different events. At a recent family holiday get-together, he mentioned that he struggles to remember the maintenance schedules for all of the vehicles. He has records for all of the service work, including oil changes, tune-ups, and other repairs. But currently, they are just paper receipts and he needs a way to track and schedule the maintenance so that any of the cars will be available for use when he wants it. He also would like to plan his usage so that he doesn’t have to get all of the cars serviced at the same time. You suggested that it would be a good application for a database. Actually, you are really hoping he will let you borrow one of them for a date; but first you have to design the database.

Car Make, Model, Year, Color
VIN
Date Acquired
Exterior Condition
Interior Condition
Storage Location, Name, Address
Size, Heat/Cool
Monthly Cost
Amount Paid
Source
Manufacturer Service Intervals
Miles Interval
Oil change
3000
Grease frame fittings
Tire pressure
15000
Replace spark plugs,., Tune-up
Rotate tires
Grease door fittings
Actual Service Records
Miles
Date
Location Service
Comments
Cost
Labor Parts
Transcribed Image Text:Car Make, Model, Year, Color VIN Date Acquired Exterior Condition Interior Condition Storage Location, Name, Address Size, Heat/Cool Monthly Cost Amount Paid Source Manufacturer Service Intervals Miles Interval Oil change 3000 Grease frame fittings Tire pressure 15000 Replace spark plugs,., Tune-up Rotate tires Grease door fittings Actual Service Records Miles Date Location Service Comments Cost Labor Parts
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY