IT510 Homework Activity: Module Seven

IT 510 Module Seven Homework Activity Guidelines and Rubric

Using the questions found at the end of Chapter 9 in your textbook, submit a Word document including an ERD with the answers to the following questions:

  • What is a DBMS? Briefly describe the components of a DBMS.
  • Describe a primary key, candidate key, secondary key, foreign key, and a combination key. Use your imagination to provide an example of each key that is not in the textbook.
  • What are entity-relationship diagrams and how are they used? What symbol is used for a relationship? What is an associative entity? Provide an example. Note: For the purpose of this assignment, you may use an ERD not related to this specific case study.

What to Submit

Homework Activity Module Seven should follow these formatting guidelines: 12 pages, double spacing, 3 components of DMBSs are defined, entity-relationship diagram, 12-point Times New Roman font, one-inch margins, and APA citations.

Module Seven Homework Activity Rubric

Criteria Proficient (100%) Needs Improvement (55%) Not Evident (0%) Value
DBMS Defines and identifies DBMSs and DMBS components Insufficiently defines and/or identifies DMBSs and their components Does not define or identify DMBSs or their components 30
Keys Compares and contrasts each of the required key types and introduces a key type not related to the assigned case Insufficiently compares and/or contrasts each required key type as well as the additional key type introduced Does not compare or contrast the required key types 30
Entity Relationship Diagram Provides an ERD sample either reflecting the case or via a personally selected scenario Insufficiently addresses the case study via the ERD provided Does not provide an ERD 30
Articulation of Response Submission has no major errors related to citations, grammar, spelling, syntax, or organization Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas 10
Total: 100%