Databases Question

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)

1. Billing details: invoice number, procedure code, payment method
2. Inventory items: supply name, quantity in stock, supplier/vendor, cost
3. Submission: Submit a document containing the following:
4. Identify the tables needed and specify the primary key (PK) for each, as well as any foreign keys (FK).
5.