Design a database schema for the proposed Database

Question # 00433158 Posted By: kimwood Updated on: 11/30/2016 04:07 AM Due on: 11/30/2016
Subject General Questions Topic College life Tutorials:
Question
Dot Image

Design a database schema for the proposed Database Design Proposal in Module 1.

Identify and list all relevant entities and their relationships:

1) Select no less than five entities.

2) Provide a diagram.

3) Map this to a database schema.

4) Provide a data dictionary for all entity attributes.

Focus on one or two areas of your design that seemed especially difficult to develop and provide a brief assessment of the difficulty you encountered in modeling or mapping to the schema. In addition, provide the rationale for the design chosen, its limitations, and its possible extensions.

Tip: If you do not have access to ER modeling software or a diagramming tool like Visio or OmniGraffle, you can simply create diagrams in a presentation tool like PowerPoint. This is an essential skill which is used in the field.

APA format is not required, but solid academic writing is expected.

This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.

This assignment will be utilized again in Modules 4 and 5. Prior to Module 4, review any feedback provided to you by the instructor.

Dot Image
Tutorials for this Question
  1. Tutorial # 00428790 Posted By: kimwood Posted on: 11/30/2016 04:08 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Design a database schema for the proposed Database...
    Attachments
    database_schema.docx (337.01 KB)
    solution.zip (41.84 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    ...yb Rating Tutorials helped secure A+ grade 02/18/2018

Great! We have found the solution of this question!

Whatsapp Lisa