Creating an entity relationship diagram

问题:

I've created this ERD:

But now I want to add some more information to my diagram, but I do not how I should do that.

I want to modify my previous ERD, I need to register what recipe was made by what chef in each program. Also, I want to identify what ingredient and tool were used in each step of the recipe.

回答1:

I think implementing your Entity Relationship Diagram into Microsoft Access can be a good start. You've clearly defined the relations between each entity and have declared attributes for each entity. I would say that you first make each entity into a table in MS Access then add the fields and set up the relationships and see how the work together.

Make sure that your relationships are working before you start filling the database with records.