I have a database that keeps track of the hours worked by a contractor per week. I have one table for contractors that contains "con ID" as primary key. The other table Weekly Hours Tracker contains month day year (representing a particular week) and hours worked. Now from what I understand this table is a weak entity and relies on contractor table for its existence.
The relationship is defined as one contractor can work for many weeks and in one week there are many contractors working. So there is a Many to Many relationship.
So is the Weekly Hours Tracker a weak entity that has a many to many relationship with its owner entity Contractors?
Is following the correct way to represent the above tables?
(Bold attributes are keys)
Contractors Table
- ConID, Name, HourlyRate, Address
Weekly Hours Tracker
- ConID, Day, Month, Year, HoursWorked