Option #1: Phase 3: Mamma Mia Purchasing — Entity-Relationships & Database Design
Please refer to the full description of the Mamma lvtia Purchasing project in Week 8. In Weeks 4, 5, 6, and 8 you write one section of the final report (although for the last section in Week 8 you will incorporate all previous sections, with any adjustments that you may want to make to it based on instructor's feedback or any other reason). As such, the paper should not be written as an essay (with introduction and conclusion) but, instead, as a business report containing only the specified subsections each week.
This week's paper should include well-detailed diagrams prepared with MS Visio or any other drawing program — no hand-drawn diagrams are allowed. The paper will document the complete data model through an ERD diagram and also a physical database design in third normal form (in the format of another ERD diagram.) "Crow's foot' notation should be used (as used in our textbook). There is no word count requirement for this paper -- the specific subsection headers to include are as follows:
Note that for Module 5's Portfolio Milestone, you completed part #5. For this Milestone. you will complete part #6.
- ERD Diagrams:
Logical data model Physical database design.
Include a title page and reference page. Make sure your paper follows APA sty
Sample Solution