I am working on an ERD which represents the relationships between entities in a Web development company behavioral model. There I have entities like:
- Customer
- Service ----------- (like: web development, web design, web consultation, ...)
- Order-item ------- (like: web development, web design, web consultation, ...)
- Order
- Invoice
- Project
- Project-phase
- Task --------------- (like: web development task3, web design task7)
- Developer
- Delivery ----------- (like: the developed web app, web consultation session, ...)
I have this diagram so far, though I know it still has major problems, and it is just for a start point:
Main concept
- Customer makes
order-item
s onservice
s, combined to form anorder
which relates to aninvoice
. - Each
project
has multipleproject-phase
s with eachproject-phase
related to anorder
. - Each
project-phase
has multipletask
s, each of which is assigned to adeveloper
. - Each
project-phase
has adelivery
, which will be delivered upon payment of the relatedorder
sinvoice
.
Questions
- Are
has
andcontains
completely the same? If not, how to choose between them for relationships?! what is the measure?! - Are there any rational problems with the Main concept section?
- Any helpful ideas or suggestions to improve this model?
Any help with this, would be really appreciated.
Update
Final version of the diagram