This assignment continues the case study analysis of Foxcore Retail that you worked on in Part 1. We have now covered some more data modeling concepts and are now ready to design a much more comprehensive data model. In this submission, you need to do the following.
Write a new report, once again with a cover page that must have your name, email id, course name, semester, and date of submission. The report should have the following sections.
DB Design Overview: (50 points)Write a summary of the key changes and improvements made from Part1. If you received some feedback in Part 1 and were asked to fix some issues, please point them out clearly in this section.
Write a description of the ER model, highlighting the key decisions taken and their reason when coming up with this design.
Point out the strong / weak entities, strong / weak relationships, and optional / mandatory participation
DB data model: Draw a fully developed ER model using Crow-foot notation. The following elements must be clearly shown: (75 points)Entities, their attributes, primary keys, foreign keys.
Relationships with cardinalities.
Entity super-type and sub-type where applicable with sub-type discrimination, disjoint/overlapping constraint, complete/partial constraint.
Conclusion and key take aways: Summarize your key learnings from this case study, and how could your design be further improved in future. (25 points)
Feedback of my submission Case Study 1, Part:1
‘Good job on identifying most of the improtant entities.
Data model should have ER diagram as covered in this week. ‘ I didn’t submit ER Diagram in part-1.
