CSE 3241 Summer 2022
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
CSE 3241
Summer 2022
Project Overview
Scenario:
Your team is hired by Dr. Hope Smilow. 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.
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. We can assume that the entire invoice is billed under one main supervising dentist’s name. 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. Checkpoint 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 checkpoint 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 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.
2022-07-12