Question: Williams Physio, is Chicago based physiotherapy clinic which is managed by the chief therapist Allan. There are several physio-therapists who under Allan in this facility.

Williams Physio, is Chicago based physiotherapy clinic which is managed by the chief therapist Allan. There are several physio-therapists who under Allan in this facility. The clinic offers three categories of treatments. One category can have multiple therapies under it but each therapy is associated with one & only one category. Each therapy is given a unique code, treatment duration and charges. During physiotherapy session, a therapist is assigned to the patient for further treatment. A patient may get treatment from several therapists as well as one therapist can handle multiple patients. Billing for the physiotherapy is done based on the treatment category and therapy opted by patient. Jim has joined this clinic as business analyst, and he wants to design and upgrade the existing information system. As a business analyst working under Jim, your tasks are - Identify all entities Identify attributes for each entity Identify primary key for each entity
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
