Assignment: Database Schema
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 ﬁve 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 diﬃcult to develop and provide a brief assessment of the diﬃculty 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 OmniGraﬄe, you can simply create diagrams in a presentation tool like PowerPoint. This is an essential skill which is used in the ﬁeld.
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 Topic 4 and 5. Prior to Topic 4, review any feedback provided to you by the instructor.
You are not required to submit this assignment to LopesWrite.
Topic 2 DQ 1
What are the beneﬁts or disadvantages of ER diagrams? Why bother with logical design and not just create tables and columns (physical design) directly?
Topic 2 DQ 2
How does understanding the logic of a database assist clinical resources? How does being involved with workﬂow development assist IT resources?