Computer Science Homework Help

WK 2, MIS6211

PART I

TASKS

Study the Zachman framework for enterprise data architecture and describe in specific terms how you would apply that framework to your case study. Since each of you has defined an individual case study topic, you may want to provide a brief overview of your application with your analysis.

Note: To support your work, use your course and text readings and also use the South University Online Library. As in all assignments, cite your sources in your work and provide references for the citations in APA format.

• PART II

• Analysis

  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 5-7 pages in a Microsoft Word document.