I'm struggling to work out how foreign keys can affect partial and transitive dependencies when normalising databases.
I have multiple tables, two of which are job offer and accepted job.
in job offer, offerID -> expectedStart, expectedEnd, hourlyPay
, in the accepted job table jobID -> startDate, endDate, totalPay, offerID(FK)
.
My thinking is that the expected start and end dates can change after the job offer, so start and end dates are derived just from jobID, however totalPay is derived from startDate, endDate and offerID as the hourly pay is in the job offer table (of which offerID is the foreign key).
I'm trying to normalise the tables but am really struggling to work out if totalPay is causing partial or transitive dependencies as it is derived from two other entries in accepted jobs and also a foreign key.