I am trying to solve the following:
- My app is an employee database for HR people
- In this app, you can also register items in an inventory, such as a phone, laptop etc.
- The point is for a small company to see all its employees, and all it’s assets, in one place
- I would like to log the ownage history of each item, so that you can not only tell which employee owns each cell phone, but also who used to own it. In addition.
Item: iPhone 7
Data type: Item
Data type: Employee
Data type: Item ownership
Data type: Ownership date range
In my head, this would solve it, but it requires two extra data types, which just seems a bit heavy to me. Does this seem like an ok solution, or do you have any in mind that would require less database power?