docx
keyboard_arrow_up
School
Purdue Global University *
*We aren’t endorsed by this school
Course
234
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
2
Uploaded by Savannah_98
Unit 2 Assignment 2: Group Exercise - Developing a Logical Database Model for a Hypothetical
Medical Scenario
Outcomes addressed in this activity:
Unit Outcomes:
●
Identify attributes for entities in the database.
●
Define data type and nullability.
●
Identify all primary keys for entities in the database.
●
Recognize any foreign keys required for entities in the database.
●
Create an entity relationship diagram (ERD) that reflects the logical data model.
Course Outcomes:
IT234-1: Demonstrate the fundamental concepts of database management systems.
PC-1.2: Contribute to team goals and objectives through active participation and collaboration.
Purpose
The individual assignments for Units 1 and 2 focus on the conceptual and logical models of the
Movies Database. In this group exercise, you will use the process of creating a logical design for
a new scenario associated with building a new patient database. Your group will use a provided
medical data form to collect medical information that may be used by a doctor’s office for the
basis of discussion and creation of the diagram representing the logical model of the database.
Assignment Instructions
Your instructor will divide you up into groups.
You will meet with your group to prepare a diagram of a logical model based on the form
provided. The layout of this logical diagram is the same as that used in the Unit 2 assignment
and will be generated using Microsoft Visio.
A suggestion for collaboration would be for each team to meet two times. The team could first
meet to outline and assign responsibilities for creating tables that will be included in the final
diagram. Team members will then create their tables, and then the team could meet again to
consolidate and synthesize a final diagram.
Download and use the
Medical Data Form
as the basis for your analysis.
Annotate any references you use at the end of the diagram.
Each team member should submit a copy of the final logical diagram along with their completed
peer evaluation form
.
Access the Unit 2 Team Area Discussion
Assignment Requirements
Generate the logical design diagram using Microsoft Visio. Microsoft Visio can be obtained at no
cost from the
Microsoft Azure Dev Tools for Teaching
site.
Compose your Assignment in a Word document and be sure to identify yourself, your class, and
unit Assignment at the top of your paper. Copy the design diagram(s) into your Word document.
Be sure to use appropriate APA format and cite your textbook or other sources that you used in
the assignment. For more information on APA style formatting, go to Academic Writer under the
Academic Tools area of this course.
Also review the university policy on plagiarism. If you have any questions, please contact your
professor.
The group assignment is due by the final day of the Unit 7 week
.
Directions for Submitting Your Assignment
Name your assignment document according to this convention:
IT234_<YourName>_Unit2_Assn2.docx. (replace <YourName> with your full name). Submit
your completed assignment to the Unit 2 Assignment 2 Dropbox by the final day of the Unit 7
week.
Review the Unit 2 Assignment 2 Rubric before beginning this activity.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help