2. RequirementHealthcare system The cost of healthcare insurance has increased dramatically since the events of 9-11. Many companies are facing incredible challenges to stay profitable in today’s downward economic environment. In order to reduce operation costs, ABC Company is seeking a way to save on healthcare cost. The company will work together with healthcare vendors to provide a healthcare plan that benefits both the company and its employees.The company will reserve some cash for employees to spend on healthcare. The reserved cash is used to pay off patient’s medical and prescription bills. After the reservedcash is exhausted, the patient is required to pay medical and prescription costs based on his or her chosen plan coverage. The healthcare vendor will cover 100% of the healthcarecost until the maximum out of pocket amount is reached. The new healthcare plan will help ABC Company to save money when patients use their reserved cash wisely. The objective for this project is to build a database model on the MLPQ system tosimulate the real world healthcare application. In order to successfully accomplish this objective, we need to understand how the healthcare application is developed and used today. We chose United Healthcare [1] to learn more about healthcare systems and terminologies used. After gathering the information, we came up with a requirements listfor the healthcare data model. We implemented it on MLPQ and then exercised project requirement queries on our healthcare database model. We found there are some difficulties implementing the constraint database on MLPQ because it contains many unknown defects. After spending many hours learning about MLPQ, we discovered sometricks to find workarounds to the problems. In this report, we applied the concepts of constraint databases and normalization techniques that we learned from class. You will find our database model requirements, implementation, database schema, dummy data, class diagram, and the result of iconic queries and SQL queries on MLPQ in this document. 2. RequirementThe following cases are the requirement gathered from patients, vendors, companies, and doctors’ opinions. These requirements are mandatory.Requirement 1: Patients can find the lowest service fee charged by doctors.Requirement 2: Patients can find out the day which offices are open based on the specified doctor.Requirement 3: Patients can visually see the doctor’s office location on a map and the daywhich the office is open.Requirement 4: Patients can calculate how much money he or she has spent on medical and pharmacy costs.Requirement 5: Patients can see doctor’s rating.Requirement 6: Patients can choose their medical plan from a number of choices.Requirement 7: Patients can provide customer survey feedback to evaluate doctor service quality, and the feedback in reflected in doctor rating.Requirement 8: Doctors can find out the proximity of where a patient lives relative to their office. Doctors can advertise his or her service to those patients.Requirement 9: Patients can choose medicine from a range of choices in their medical plan.Requirement 10: Patients can find the cheapest medicine among the
View Full Document
Unlocking...