Order from us for quality, customized work in due time of your choice.
This week, as you continue with the data modeling and data governance analysis f
This week, as you continue with the data modeling and data governance analysis for your case study, you will perform the following tasks:
Start with your EER model from Week 1 and now map your model to a logical database design. Ensure that your logical database is normalized per the forms 1NF, 2NF, 3NF, and BCNF.
Research the data types used in DBMS products, such as Oracle, Microsoft SQL Server, IBM DB2, MySQL, or Microsoft Access, and specify data types for all the attributes in your database. Discuss physical design decisions you might consider to arrive at a practical physical database for your case study. For extra credit, you may want to implement your database in Microsoft Access and include screenshots to demonstrate that you implemented this part.
Produce a technical plan that addresses the data architecture management function for data governance of your case study.
Submission Details:
Save your work in approximately 6-8 pages in a Microsoft Word document.
can use as one of the references – Starks, J. J., Pratt, P. Z., & Last, M. (2020). Concepts of database management (10th ed.). Cengage Learning. ISBN: 9780357422083
Cite any sources you use using correct APA format on a separate page.
Submit it to the Submissions Area by the due date assigned.
Order from us for quality, customized work in due time of your choice.