Problem
In a car repair shop one mechanic uses one toolbox and one toolbox is used by exactly one mechanic. These are the tables.
MECHANIC (MechanicID, Name, Phone)
TOOLBOX(Box#, Location)
What is the relationship between MECHANIC and TOOLBOX (1:1? 1:N?N:M?)?
In order to establish the relationship how will the foreign key(s) be placed? How will the new tables look like?