Member Avatar for pspwxp fan

Hi,
My instructor has given me a project as:

Car Maintenance System 
Data Entry Forms
Setup:
a) Vehicle
b) Maintenance Types
c) Parts
d) Labor
Transaction:
a) Work Order
Reports
a) Printed Output: i) Work Order
b) Information Outputs: i) Vehicle Maintenance History, ii) Labor wise work orders

Its vague to me too, so this is what i assumed:
I have to make a Database system that stores data about a person's transactions at a car maintanance shop. This data includes

  • The cars they have brought for service
  • The services they have aquired
  • The amount of money they have spent
  • The log of all parts they have replaced
  • The log of all labor they have used

The ERD i have designed is attached.

The problem is that i feel clueless at this stage and want some feedback as to whether i am going in the right direction, and if not then what should i be doing. Please see my ERD and ask me questions about it.

Thanks

Capture.PNG 59.04 KB
  • 2 Contributors
  • 3 Replies
  • 168 Views
  • 23 Minutes Discussion Span
  • Latest Post Latest Post by pspwxp fan
Member Avatar for diafol

Careful with spelling - it's vehicle not vecicle in one of your tables.

Also have a look here - a number of items for the 'car' industry
http://www.databaseanswers.org/data_models/

Edited by diafol
Member Avatar for pspwxp fan

Yes i took care of that

Member Avatar for pspwxp fan

Thanks for that. The main issue i think i'm having is in developing the relationships between the tables.
For example, lets suppose the maintanance shop does not have such an extensive set of parts for the Porsche Carrera as it has for a Honda Integra. Is the relationship between Vehicle, Car, Part and Maintanance good enough for such a scenerio?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.