Week $7-$ Assignment: Develop a Database Design Plan that Meets Business Objectives

Instructions

This week, you learned about the importance of documenting a database design plan that meets stated busine transforming the design plan into a prototype database system for demonstration of functionality. Throughout the course, you have designed a prototype for the database planned for future implementation. $U$ study scenario provided in Week $2$ and the set of business rules, create a draft version of the database design feedback provided by your professor, will be finalized in Week $8.$

Using the outline provided in the lecture materials create a database design plan document with a title pag and each section. For this assignment, assume that your role emphasizes the design concept so you will be com of the outline and entering To Be Determined in the other sections.

Write an effective Executive Summary that is no more than one page long. Using non$-$technical language, system, its purpose, and business goals and objectives. Be sure to describe how the database system will provid organization.

Include the following information in the Database Design and Information Flows section of the Database Desig

a$.$ Using technical language, describe the database system $($hardware and software$),$ purpose, and business objectives.

b$.$ Explain the database requirements definition, including how business rules will be supported using indu best practices $($supported by sources$).$

c$.$ Provide a detailed justification as to why $3$rd normal form is adequate for the database design $($supporte

d$.$ Include a detailed description of the data dictionary $($including metadata$).$

e$.$ Provide an entity$-$relationship matrix $($ERM$)$ as an annotated table.

f$.$ Embed the entity$-$relationship diagram $($ERD$)$ using Crow's foot notation and with cardinality levels specif

Length: $5$ to $7-$page paper, including $1$ entity$-$relationship diagram $($ERD$)$

References: Include a minimum of $2$ scholarly resources.