What is the relationship between mechanic and toolbox


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?

Request for Solution File

Ask an Expert for Answer!!
Computer Engineering: What is the relationship between mechanic and toolbox
Reference No:- TGS03233063

Expected delivery within 24 Hours