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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!