MIS 6110 CMU Databases and Entity Relationships Case Study Case Study Analysis #2 – Databases and Entity Relationships For this case analysis, you will as

MIS 6110 CMU Databases and Entity Relationships Case Study Case Study Analysis #2 – Databases and Entity Relationships

For 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 Context
What 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 Database
Using 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 Instruction

2- Sample Case Study

.

Rubrics for Case Study / Final Project – Graduate level

Submission status
Submission status No attempt
Grading status Not graded
Due date

Time remaining

Grading criteria
Substance of the Assignment

0-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 score

50

Organization of the applied project

0-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 score

10

Mechanics of writing

0-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 score

10

Evidence of research

0-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 score

20

Length of paper

0-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 score

10

Late Work Deduction

Points will be deducted for late submissions as per CMU late work policy (see course page).

Maximum score

0