Develop an entity relationship diagram (ERD) for your project database based on the initial data requirements.
The company that we are working on distributes many products, like secure bolts and screws, to many different construction companies. In order for the company to be successful it is important for them to keep a reliable and accurate inventory system.
As part of the diagram, include:
- Entities
- Attributes
- Primary Keys
- Relationships
- Cardinalities (both minimum and maximum)
The ERD should include documentation of design decisions. It should not be converted to relational tables. Develop the diagram using VISIO or Word.