Draw the Crow’s foot ERD keeping in mind the following requirements. It is important that you use the proper symbols in each case. 1. Identify the connectivity for all the relationships involved between the 8 entities and give an appropriate name. In the case of 1 to Many relationships, the relationship should be written from 1 to the Many side of the relationship. Please note that while each relationship is bidirectional in nature, you have to label the relationship of only one direction in the ERD. When I read your ERD the statement A relates to B should make sense. For example, in the relationship between Painter and Painting, Painter paints Painting makes sense. Show the entity, relationship and connectivity using appropriate symbols on the ERD (20 points)
2. Resolve the Many to Many relationships properly and show the appropriate elements properly (20 points)
3. Identify the relationship participation of each entity in a relationship. Please note that when A is related to B, B may be optional or mandatory to A and A may be optional or mandatory to B. You need to make sure that you indicate appropriate symbols for both If you make assumptions, please state them clearly on a separate document. Please note that your assumptions should not violate the business rules listed for the relationship in the problem. (20 points)
4. Identify the relationship strength of each relationship and show it appropriately in the ERD. List any assumptions you make on a separate document. Once again, your assumptions should not violate the business rules listed for the relationship in the problem. (20 points)
5. Your ERD should show only the primary key and foreign keys in the entity box. You need not show other attributes. Please remember to indicate the primary key and foreign keys clearly. Please see figure 4.35 on page 144 of the course textbook for a good example of a Crow’s foot ERD. (20 points)
6. You may draw the ERD neatly on an 81/2 by 11 ½ size paper using a scale and pen and submit a scanned copy. Please note that it is important that I am able to read your ERD submission, understand and evaluate it. If I cannot read your ERD clearly, please note that I cannot give you a grade. Alternatively, you may use Microsoft Visio to draw the ERD. There are no extra credits for drawing the ERD using a tool.
Please submit your ERD and any assumption documents in Canvas. Only one group member should submit on behalf of the group. If more than one group member submits the assignment for the group, I will evaluate only the latest submission. Please indicate the names of your group members on the assignment submission.