Phase 3 (due on Week 6) – Entity-Relationship Model & Database Design:
- Data relationships:
- ERD diagrams (complete data model.)
- Physical database design (complete database.)
Option #2: Phase 3: Mamma Mia Accounts Payable â€“ Entity-Relationships and Database Design
Please refer to the full description of the Mamma Mia Accounts Payable 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.
6. ERD Diagrams:
- Logical data model
- Physical database design
Include a title page and reference page. Make sure your paper follows APA style.
As support for your analysis, use at least two resources and/or outside, credible academic sources other than the textbook, course materials, or other information provided as part of the course materials. For this assignment, a credible source is defined as:
- Scholarly or peer-reviewed journal articles
- Newspaper articles
- Trade or industry journal articles, publications, or websites, including those from trade organizations. Consider CIO Magazine, the Harvard Business Review, Fortune, and similar solid sources.
Please be sure NOT to use direct quotations from sources and, instead, use paraphrasing or summarizing when needed.