There are three kinds of relationships that exist between tables:

One$-$to$-$one relationships

Many$-$to$-$one relationships

Many$-$to$-$many relationships

Describe from the above diagram only, these types of relationships. You are required to submit the following:

Name the tables $($from the above diagram$)$ with the relationships between them. $($At least $2$ different relationships with their tables$)$

You study the diagram and see there is no contact information for the suppliers. Following a relationship design, where will you insert another table

and link it to$?$ You are required to submit the following:

A new table, with some fields relating to contact details

Briefly describe the relationship and to what table you will add it and how $($where will the foreign key be inserted$)$