Topic 3: Database Design Components
Topic 3: Database Design Components
Jan 27, 2022 – Feb 2, 2022 Max Points: 130
Resources
MySQL
Explore the MySQL website.
https://www.mysql.com/
Optional: Database Tutorial for Beginners
For additional information regarding Lucidchart that can be utilized in the Topic 3 assignment, the following is
recommended:
“Database Tutorial for Beginners,” by Lucidchart (2018), located on the YouTube website.
Optional: Omnigrafe
For additional information regarding the Omnigrafe program that can be utilized in the Topic 3 assignment,
the following is recommended:
Explore the Omnigrafe website.
https://www.omnigroup.com/omnigrafe
Optional: What Is Visio?
For additional information regarding the Microsoft Visio program that can be utilized in the Topic 3
assignment, the following is recommended:
Page 7 Grand Canyon University 2022 © Prepared on: Jan 10, 2022
“What Is Visio?” located on the Microsoft Support website.
https://support.microsoft.com/en-us/ofce/video-what-is-visio-421b0c94-7ecf-4e62-8072-d27e04d24fe6
Assessments
Database Project Proposal – Part 2
Start Date & Time Due Date & Time Points
Jan 27, 2022, 12:00 AM Feb 2, 2022, 11:59 PM 100
The purpose of this assignment is to build upon your database project proposal by creating the database
schema components. A schema is a logical grouping of database objects, such as tables, indexes, views, and
queries that are related to each other.
To complete Part 2 of the Database Project Proposal assignment, write a 750-1,000-word essay that contains
the following information:
1. Restate your database project; describe its goal and objectives.
2. Describe the purpose of the database schema for your project.
3. Write out the process associated with your business rules relating to your database.
4. Create a data dictionary that contains no less than fve entities. Select and design an entity-relationship
diagram (Crow, Chen, UML); Note: There are a variety of ER modeling software programs on the market.
Microsoft Visio, OmniGrafe, LucidChart, and MySQL are few of these programs that provide free trials to
create entity-relationship diagrams. In addition, you can simply create diagrams by utilizing Microsoft Word,
PowerPoint Shapes, or SmartArt.
5. Focus on one or two areas of your design that seemed especially difcult to develop and provide a brief
assessment of the difculty you encountered in modeling.
6. Discuss the project’s limitations and possible extensions.
This is an ongoing project and feedback from the instructor at every stage will help you to improve your fnal
project.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student
Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar
with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is
located in Class Resources if you need assistance.
CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the
master’s degree level:
F1: Health: Does
F2: Information Science and Technology: Does
