Hi, I am facing a database relationship issue. I am not sure if my design is correct or wrong...
My company is leasing alot of machines to customer and I come out with a design like these.
The interpretation is:
A model can have many machine s/n.
each machine s/n must comes from a model.
a machine can only be leased by one customer.
a customer can leased more than one machine.
a customer can make many complaint of a machine
a complaint must comes from a customer...
The problem that I need advice is:
does the complainttable link to to the customer or the machines?
is my machine to customer relationship is correct?