[SOLVED] CSIS 325- Project Phase I – Instructions Health Care Options, Inc.

We offer all "help with my paper" services e.g. Custom essay writing, Dissertation writing help, Research paper writing, and Term paper writing services at affordable prices. We cover all your paper help needs 24/7.
Get started Order in Chat
Orders delivered on time
Academic disciplines covered
Average rating

Health Care Options, Inc. (HCO) is a home-health care facility located in the heart of the
Blue Ridge Mountains. It supports local residents within a 50-mile radius by providing home
health care services that range from medication administration, catheterization, and wound
dressing to bathing, dressing, and feeding. These services are administered by skilled nurses and
home health aides who are employed by HCO. The management staff includes a receptionist,
two co-owners/managers, and an accountant.

Patients receive services based upon a doctor’s written referral. Referrals consist of the
type of care needed (i.e. skilled nursing or home health aide), the equipment needed to provide
the services (i.e. albuterol and breathing apparatus for breathing treatments, syringes, catheters,
etc.), and a description of the care needed (i.e. change wound bandages twice per week, provide
baths every other day, etc.). Payment for services can occur in one of four ways: Medicare Part
B, Medicaid, private insurance, and private-pay.

In cases where Medicare or Medicaid is used, payment is received based upon a costreimbursement basis. This basis is calculated by determining total direct costs for all home
visits, plus an allowable amount for overhead. Direct costs include both labor and inventory.
Labor consists of a standard rate for a nurse or aide, depending on the services needed. A nurse
currently has a standard cost of $150 per hour, while an aide has a standard cost of $47 per hour.
Inventory is another direct cost. Inventory consists of items such as various types of syringes,
gauze, catheters, etc. All inventory is currently provided by a single medical supplier, Blue
Ridge Medical Supplies, which provides a list of all of its medical supplies and prices on a
quarterly schedule. Prices are subject to change from quarter to quarter, and the company uses a
weighted-average inventory method to keep track of the cost of inventory that is purchased and

Using the direct cost data that is accumulated throughout the year, HCO submits an
annual cost report to its Medicare/Medicaid Intermediary on December 31. This cost report
includes a total of direct costs as well as the indirect costs of the business. Indirect costs include
salaries of staff personnel, rent, utilities, and other miscellaneous office supplies. Total direct
costs and indirect costs are totaled in the annual cost report, and a per-patient cost reimbursement
rate is determined by dividing the total costs (both direct and indirect) by the total number of
patient visits. It is this cost-reimbursement rate that is billed to the Medicare/Medicaid home
office when a home health care visit is incurred. Note that the direct costs that are accumulated
and submitted within the cost report are only those costs associated with Medicare/Medicaid
patients. Private pay and insurance patients are excluded from these calculations. Total indirect
costs are included in the cost report submission as they cannot be directly traced to any
individual patient or patient type.

For patients with insurance, a pre-determined rate per visit is negotiated with each
insurance company. The rate-per-visit per insurance company is currently stored in an Excel
spreadsheet. This rate per visit is based solely upon the skill level of the care provider. For
instance, an RN has a skill level of 10, whereas an LPN has a skill level of 7, and an aide has a
skill level of 3. An entry in the spreadsheet indicates that for All-Insurance (a local insurance
company), any visit provided by a staff member with a skill level above 5 is reimbursed at a rate
of $238 per visit, up to a maximum of 30 visits in a three-month period. Most other insurance
companies also provide a rate for a range of skills levels up to a maximum number of visits
within a given duration (usually in months). Once this maximum has been exceeded, a patient’s
doctor must write a new referral. This referral serves as the basis for a new contract between the
patient and HCO.

Private pay patients are unique in that a different rate is negotiated with each patient.
That is, a contract is signed with each patient that requires the patient to pay a certain amount for
each home health care visit up to a maximum number of visits. This maximum number is also
negotiated and included in the patient’s contract.

Related: Discover Top 150 Interesting Medical Research Topics
Contracts are required for every patient who receives services. Contracts include the type
of services performed (i.e. wound dressings, bathing, etc.), the number of visits per week, the
supplies used in the provision of these services, and the duration of services needed. Naturally,
the contract includes the type of payment (Medicare, Medicaid, insurance, or private pay) to be
used. Contracts are assigned start and end dates based on the terms of the referral, or in cases
where the method of payment is insurance, the duration of the contract is the lesser of the term
specified in the referral or the constraints of the insurance company. In most cases, doctors write
referrals that are within the allowable duration that most insurance companies stipulate.
Scheduling is a major issue in home health care. It is important to match the needs of the
patient with the skills of the nurse or aide. Additionally, the geographic location of the patient
must match the geographic location of the nurse or aide providing the services. Currently,
zipcode is used to match the locations of patients to their home health care providers. One
additional component of the scheduling feature is the availability of the care providers. Some
nurses and aides are available seven days per week, while others work a part-time schedule–
perhaps on Mondays, Wednesdays, and Fridays only. An important feature of scheduling is to
match not only the skills and geographic locations of patients with providers, but also to match
the availability of care providers with the frequency of visits needed by the patients. In cases
where no match is found for a patient and provider based on these factors (geography and
availability), notices are sent to the managers, who must individually assign nurses/aides who are
outside of their geographic areas or days of availability. These exceptions are rare, but when
they occur, management pays an additional stipend to its nurses/aides who must work outside of
their locations and/or days available. No replacements are ever made when skill sets of
providers do not match the needs of patients. In these circumstances, a patient’s doctor is
immediately notified to allow the patient to receive in-hospital or rehabilitative care, and the
existing contract is nullified. This situation only occurs when a nurse/aide who provides a
specialized care subsequently leaves the company, and no other health care professionals are
available with the same skill set in the company.

Phase I Deliverables:
1. ERD
For this phase, assume you are a member of a team of database and GUI
developers/analysts. As a member of the database team, you are required to create an ER
Diagram that will facilitate the development of Health Care Options’s company-wide database.
It should be created using ER Assistant and include entities, attributes, and relationships.
The scope of the database includes all entities referenced above. The goal of this phase
of development is to support a scheduling system that will replace the current spreadsheet
process, but your database should be designed to support all of the company’s current and future
needs. Note that your team will not actually create the scheduling system. You are responsible
only for designing the database that will be used by the system. Subsequent phases will include
table design and broaden the scope to support billing and cost report compilation. Thus, plan and
design your initial database carefully, as it will affect your future deliverables.

Also Read: The Secret to 100% Correct Aleks Answers
2. CREATE TABLE Statements
Based on your ERD design, in step 1, write and execute the CREATE TABLE statements
for each of the tables. Be sure to create primary, foreign key, and NOT NULL constraints as
To receive full credit for this assignment, all of your CREATE TABLE statements must
be executed in MS SQL Server.
In addition to creating the tables, you must add at least 3 rows of data to each one. If
there are any errors in your ERD, you will likely find them yourself at this point in the process
and make any needed adjustments to your design. Remember, order matters when you are
creating tables and loading data.

Finally, execute the following commands for each table and print out the results to show
that you have successfully performed the CREATE TABLE step of this assignment and have
populated the tables correctly.
exec sp_help [table name]
select * from [table name]
What you will submit:
Submit your ERD file (created in ER Assistant) along with a Word document that contains
the following:
1. CREATE TABLE statements for all of the tables in your ERD.
2. Screenshots of each table you created after running the exec sp_help and select
statements described above.

[SOLVED] CSIS 325- Project Phase I - Instructions Health Care Options, Inc.

Quality Guaranteed

With us, you are either satisfied 100% or you get your money back-No monkey business

Too much stress and so little time?
Our experts are ready to help
Place order
Why Choose Us
Expert writers
Our rigorous writer selection procedure ensures that only subject-matter experts with master's degrees and higher work on your assignments.
Your personal information is not shared with any third parties. Neither do writers have access to it.
Affordable prices
My Paper Support is a cheap do my paper service that offers high quality papers at amazing prices. Our customers enjoy lifetime discounts and other offers
Original content
All papers are written from scratch and plagiarism is not tolerated. We scan all papers for plagiarism using Copyscape, Turniting and Safe Assign
Here's why students opt for MyPaper Support
Hiring a professional "do my paper" service is a guaranteed method of balancing academic, family, and professional demands.
Pressed for time
Better grades
Working smart
Busy Schedule
We understand that balancing professional and student roles is an onerous task. As a result, we have tailored our services to help you balance the increasing demands without tainting the integrity of our education system. Get your paper done within tight deadlines of up to 4 hours.
Speedy delivery. You will receive your
paper before the deadline.
Get started Order in Chat
Raise the GPA
Our paper writers have helped thousands of students improve their GPA and advance professionally. We have a robust QA team which ensures that no error goes unnoticed. Join us and get that Summa cum laude.
Accurate papers. Your work will be based on reputable
sources that provide factual information on the topic.
Get started Order in Chat
Career growth
Why should you stagnate in one position yet you have the required experience to advance professionally? Most students use our do my paper service to obtain the much-needed papers to complement their experience and advance in career.
Ownership of final product You can use the delivered
samples in any way you choose.
Get started Order in Chat
Professional do my paper service
At MyPaper Support, we take your privacy seriously and that why students love us. No writer has access to your personal information. What happens here, stays here..
Value for money. We will return your money
if you are not satisfied with the result.
Get started Order in Chat
Check Prices
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know that being a student these days is hard. Because of this, our prices are some of the lowest on the market.

Instead, we offer perks, discounts, and free services to enhance your experience.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Get personalized services with My Paper Support
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
The skilled writer did a great job on assignment!! Thank you!!
Customer 452547, June 16th, 2021
Thank you!
Customer 452707, June 29th, 2022
Social Work and Human Services
Excellent! Done earlier than needed and with more sources than needed! Great work!
Customer 452485, August 22nd, 2021
Database design and optimization
communication was great and the work looks perfect.
Customer 452715, February 26th, 2022
Social Work and Human Services
Good Work!
Customer 452587, September 2nd, 2021
IT, Web
Excellent job on the paper.
Customer 452885, January 25th, 2023
Customer 452813, June 28th, 2022
excellent service! Not a beat missed!
Customer 452453, October 17th, 2021
Social Work and Human Services
Great Work!
Customer 452587, October 13th, 2021
Financial Statement Analysis
Thanks for the help
Customer 452821, March 10th, 2023
Social Work and Human Services
Excellent Work!
Customer 452587, August 24th, 2021
Words can't describe how helpful this service has been for me. Thank you!
Customer 452707, January 9th, 2023
Enjoy affordable prices and lifetime discounts
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Order Now Order in Chat

Ensure originality, uphold integrity, and achieve excellence. Get FREE Turnitin AI Reports with every order.