QUESTION $3$

$[20$ marks$]$

a$.$ The following exercise is based on the records of the company that stores information

about their sessions $($for Sports Physical Therapy$).$ A session record will have a unique

number, session date, patient number, length of the session, therapist number, and

therapy code. Sports Physical Therapy.

Determine the functional dependencies that exist in the following table, and then convert

this table to an equivalent collection of tables that are in the $3$rd normal form.

Session $($SessionNum$,$ SessionDate, PatientNum, LengthOfSession, TherapistID,

TherapyCode, Description, UnitOfTime$)$

b$.$ Describe what is meant by transitive dependency and describe how this type of

dependency relates to $3$NF$.$ Provide an example to illustrate your answer.