Create database

  • Thread starter Thread starter Excel
  • Start date Start date
E

Excel

Need help with business order
It should be like this example:

BUSINESS ORDER

Id Order: (ex. MK 01/01, MK 02/01, MK 03/01...)
Date:
Customer - Name Customer
Order - many activity (ex. 1. cutting material, drilling material, up to 10
or more activities)
Work hours - (ex. cutting - 2h, sawing 5h, drilling 3h ....up to 10 or more)
Material - (ex material used in work process, steel plates - 150 kg, tubes
15 kg, and more...)

Please help with this database
How many tables! and relationship beetween them.

Thanks, Michael
 
Back
Top