I am modelling a database that tracks our earth moving machines (Plant). I am seeking confirmation that the ERD is sound before I commence with creating the database.
After reviewing it appears I need to:
- Track the locations (site) of each piece of plant.
- Know which customer is assigned to pieces of plant.
- The name of the operator is currently working that piece of plant for that customer.
NOTE: it is not uncommon for multiple pieces of our plant to be assigned to multiple different customers we have who are working at the same site.
I have attached two formats of my ERD for those who would like to provide feedback on if I am on the right track or not.