18 Aug Case Study Analysis #2 – Databases and Entity RelationshipsF

Case Study Analysis #2 – Databases and Entity RelationshipsFor this case analysis, you will assume the role of a manager for a small company.You have been tasked with a project that involves designing and implementing a database for the company’s managers to assist with business decision making.This case analysis is comprised of the following parts: Part I: Database Design and ContextWhat is a database?What are the uses of databases?Part II: Entity Relationships Diagrams (ERD)What is an ERD?How would you develop a database using an ERD?Show an ERD for your small company.Part III: Creating a DatabaseUsing the ERD you developed, create a database (use MS-Excel) with a MINIMUM of SIX records (aka tuples) in rows and SIX fields (aka attributes) in columns.Database MUST show the use of at least ONE Pivot Table (included as an MS-Excel tab) to demonstrate functionality.Submit a written paper of between 750 to 1,000 words. Provide sufficient details for the paper to be readily understood.NOTE: As stated earlier, APA format is REQUIRED. This includes a MINIMUM of three academically acceptable references and the expectation of correctly used “in-text” citations.To find more information and also instruction to write your case study see the following files:1- Case Study Instruction2- Sample Case Study.Rubrics for Case Study / Final Project – Graduate levelSubmission statusSubmission statusNo attemptGrading statusNot gradedDue dateTime remainingGrading criteriaSubstance of the Assignment0-35: The paper was not written to the writing prompt and remained in the domain of the subject matter. Less than 750 words.36-43: The paper was somewhat written to the writing prompt and remained in the domain of the subject matter. 750 -1,000 words minimum.44-50: The paper was written to the writing prompt and remained in the domain of the subject matter. 750 -1,000 words minimum.Maximum score50Organization of the applied project0-6: The structure and pattern of the paper is incomprehensible.7-8: The structure and pattern of the paper is unclear, has some organization, but has a good logical flow. Most paragraphs are well developed and there are transitions between paragraphs.9-10: The structure and pattern of the paper is clear, organized, and has a logical flow. Each paragraph is well developed and there is a good transition between paragraphs.Maximum score10Mechanics of writing0-6: Student’s paper has more than ten errors in spelling, punctuation, and grammar.7-8: Student’s paper has less than ten errors in spelling, punctuation, and grammar.9-10: Student’s paper has less than six errors in spelling, punctuation, and grammar.Maximum score10Evidence of research0-16: The student’s paper is not supported with at least 1 scholarly peer reviewed academic resources and there are no citations in APA format.17-18: Some of the student’s paper is supported with at least 2 -scholarly peer reviewed academic resource, which is correctly cited in APA format.19-20: The student’s paper is supported with at least 2 – 3 scholarly peer reviewed academic resources, which are correctly cited in APA format.Maximum score20Length of paper0-7: Students paper did not meet the paper length requirement.8: Student’s paper was two or less pages under the required paper length for their degree level.9-10: Student has met the paper length requirement for their degree level.Maximum score10Late Work DeductionPoints will be deducted for late submissions as per CMU late work policy (see course page).Maximum score0