he 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 to 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? 1. Table: Patient -field (PatientNum, LastName, FirstName, Address, City, State, ZipCode, Balance) 2. Table: Session -field (SessionNum, SessionDate, PatientNum, LengthOfSession, TherapistID, TherapyCode) 3. Table: Therapist - field (TherapistID, LastName, FirstName, Street, City, State, ZipCode) 4. Table: Therapies -field (TherapyCode, Description, UnitOfTime)
The Sports Physical Therapy
1. Table: Patient -field (PatientNum, LastName, FirstName, Address, City, State, ZipCode, Balance)
2. Table: Session -field (SessionNum, SessionDate, PatientNum, LengthOfSession, TherapistID, TherapyCode)
3. Table: Therapist - field (TherapistID, LastName, FirstName, Street, City, State, ZipCode)
4. Table: Therapies -field (TherapyCode, Description, UnitOfTime)

Trending now
This is a popular solution!
Step by step
Solved in 3 steps









