Question: This week you will use again the example you selected in Week 2. The first thing you need to do is to modify the ER
- This week you will use again the example you selected in Week 2. The first thing you need to do is to modify the ER Diagram you presented then, with the possible improvements and suggestions that might have been given to you in Week 2s Discussion thread. Also, if needed, you may have to add more entities, attributes, and/or relationships to your ER Diagram to satisfy the following requirements: each ER Diagram should have a minimum of two entities, each one with at least five attributes. These attributes should include in each entity at least 1 identifier attribute, 1 simple attribute, and 1 multivalue attribute. There should be some relation between these two entities. Include the new ER Diagram in your initial reply.
- Once you completed your new ER Diagram, you need to convert it into a graphical representation of a database. As we will see this week, this graphical representation uses a rectangle for each attribute, a set of rectangles to represent an entity (known as tables from these point on), and solid arrows between tables (entities) to support their relationship with foreign keys. Be sure that this Database Design is in Third Normal Form. Include this new diagram of your design also in your initial reply.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
