CSE 3241 Spring 2022
Project Overview
Your team is hired by Dr. . She is opening her own dental practice ¡°Smilow Dentistry¡± and needs a database to hold all required data. Her office needs to maintain a list of accepted insurance policy types, a list of standard dental procedures and standard per unit charges for those procedures for each insurance plan. The office will employ various medical professionals such as other dentists, hygienists, dental assistants, receptionists, etc., and will need to maintain standard employee info and licensure details where applicable. They need to keep careful track of patients, their complete demographics, insurance info, medical history,
and appointments.
Copyright By PowCoder代写 加微信 powcoder
In addition to storing basic demographics info, the system needs to keep track if and when a patient signed HIPAA form, date of last x-ray, medications, and allergy information and allow to check that the information is still current.
Any time a patient has an appointment, a billing record needs to be generated with date, doctor / supervising doctor/ medical professional, and procedures performed. They will also keep track of patient payments. Each payment consists of an amount, a date, and a type of payment (cash, check, credit card), and invoices it is applied to. The system should allow to store patients¡¯ payment information and use it when instructed.
Each appointment can involve multiple treatments/procedures performed by various professionals. There will be one invoice (bill) per appointment. Not all patients will have insurance coverage, and some may pay out of pocket. For patients who have insurance coverage, insurance payments are applied first, and the patient is billed for the remainder when applicable. We will assume that each patient can have only one insurance plan. We are not going to worry about secondary coverage at this time. Cancelled appointments are not billed. Specific procedures can be performed by certain licensed medical professionals.
Rules and general requirements:
You and your teammates will work on this project independently from other teams all semester. This project will measure your ability to apply the concepts learned in this course. There will be several required check-point assignments that will help you to navigate through the project and to assemble some of the required components. You will receive feedback on your work. The purpose of that feedback is to provide you with some pointers and assess your progress. Check- point work submitted during the semester does not guarantee the correctness and completeness of your final work. Those are the responsibilities of your team and not of the graders. All check- point work will need to be retained and submitted again as a part of your final project documentation.
Final Project will be due at the times listed. Late submissions will not be accepted. Each team
OHIO STATE UNIVERSITY
CSE 3241 Spring 2022
member is equally responsible for completion, presence, and correctness of required documentation and files. One submission per team is required. However, all team members are expected to retain copies of all completed work. Students who do not contribute fairly towards this project, will face point deduction or/and removal from the team at any point during the semester at the instructor¡¯s discretion.
Detailed final document requirements will be provided in a separate document. Your final project will include a detailed report describing your DB design and capabilities, relational database schema, entity relationship diagram, SQL code, data, and other DB components.
OHIO STATE UNIVERSITY
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com