AnsweredAssumed Answered

ERD Review - Plant Hire

Question asked by dig on Aug 7, 2016
Latest reply on Sep 4, 2016 by dig

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:


  1. Track the locations (site) of each piece of plant.
  2. Know which customer is assigned to pieces of plant.
  3. 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.


Thank you.