Refer to the “Sports Physical Therapy Case Exercises” in Chapter 1 of the textbook. Discuss the following in the Discussion Board:
The Sports Physical Therapy database does not include a field for the hours that the therapist is working. For example, doing any sort of treatment requires set up and break down of equipment, reading patients’ charts, etc. In which table would you put the hours worked? What might be a better way to record when therapists begin their work and end their work?
What table might the database need to help determine the balance field in the Patient table? Would you want to record when a bill is paid and the amount? How would the insurance part of the bill be recorded?
Textbook
Concepts of Database Management
Lisa Friedrichsen; Lisa Ruffolo; Ellen Monk
More book options
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|