Here's a simple Entity-Relationship model.
The crazy part of this is that the asset can be three different types of assets: support contracts, software, and hardware. The support contract can support a software asset or a hardware asset.
The asset itself can be assigned to a user, managed by support, and purchased (owned) by a manager, all of which are some type of employee. There's not distinction in the type of employee, other than has the asset relates to the employee (owner, user, supporter).
The asset itself can be assigned to a user, managed by support, and purchased (owned) by a manager, all of which are some type of employee. There's not distinction in the type of employee, other than has the asset relates to the employee (owner, user, supporter).
So the question is how can this be easily represented?

No comments:
Post a Comment