Walden University ITEC 8145Week 6 Assignment - ITEC-8145
Week 6 Assignment – ITEC-8145
1. Define your database.
a. Describe the database, its
... [Show More] purpose, why it was created, who it
was created for, who the users are, and what type of processes
and functions it will support.
The digitization of the healthcare industry is happening fast. A major result
of this transformation from paper to electronic records is the proliferation
of healthcare data. And with that, of course, comes the healthcare
database. Databases are foundational to any use of data. For the purposes
of this assignment, we will profile Aspire Healthcare Insurance Company
which package health insurance products or provide coverage plans
directly to patients or indirectly through employer or governmental
intermediaries. The purpose of this database is to store and retrieve
information in a way that is accurate and effective, and to provide a system
to manage the different databases it contains (performance, security,
availability, etc.). Additionally, this database is designed to allow the
customer data to be recorded accurately with no duplication information
and creates an effective result for the company also allows the customer to
experience a good sales transaction and service from the company.
b. List the entities of your database.
The entities of Aspire Healthcare Insurance Company database are as
follows:
Customer
Health plan
1 | P a g e
Request
Request Line
Region for health insurance company
c. Present the business rules that determine connectivity, using the
format reviewed in Week
Aspire Healthcare Insurance business rules is reflective of the ensuing
cardinalities:
Customer ↔ Region for Health Insurance company
A Customer belongs to one and only one region
A Region for Aspire Health Insurance company can have many
Customers
Customer 1:M Region for Health Insurance Company
Customer ↔ Request
A Customer can have one and only one request ID
A Request can be requested by many customers.
Customer 1:M Request
Request ↔ Request Line
A Request can have Many Request Line.
A Request Line can have one and only one Request
Request M:1 Request Line
Request line ↔ Health Plan
A Request Line can have one and only one health plan ID,
A Health plan can have many Request Lines
Request Line 1:M Health Plan
d. Draw the ERD; copy the drawing into your Word project
document. [Show Less]