Objective: Design a relational database schema to meet the reporting needs of th
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
Submission: Submit a document containing the following:
Identify the tables needed and specify the primary key (PK) for each, as well as any foreign keys (FK).
In 1-2 paragraphs, describe three potential challenges and considerations in implementing this database solution.