Pooja Shah is the practice manager of a physical therapy and rehab clinic in Queens. The practice$$s medical records system is sufficient for scheduling and managing patient treatment plans, but it doesn$$t have good reporting capabilities. Pooja and her IT team have mostly handled reporting needs by exporting data to Excel, which is not secure or efficient. She has hired you to figure out how to structure a relational database and bring their reporting processes into the $21$st century. The rehab clinic team compiled a list of specific data items they expect to be able to report on and Pooja tried to sort the requests as best she could.

Objective: Design a relational database schema to meet the reporting needs of the rehab clinic. Remember the best practices from class, including the normalization rules! You may include additional fields or data elements as you need, especially if you identify any gaps, but at minimum you must offer a way to report on the requested items below.

Specific Data Items Requested by the Team:

Patient information: name, age, gender, reason for rehab $($diagnosis code$),$ address, phone number, insurance company, insurance subscriber ID$,$ patient ID

Insurance information: insurance company, subscriber ID$,$ copay amount

Appointment details: date, time, duration, therapist assigned, procedure code, diagnosis code

Treatment sessions: type of treatment $($procedure code$),$ diagnosis, duration, cost, assigned therapist, supplies used, reason for supply use $($required$,$ optional, replacement, damaged, other$)$

Billing details: invoice number, procedure code, payment method

Inventory items: supply name, quantity in stock, supplier$/$vendor$,$ cost