Just wanted to know what type of relationship does these table hold, as the customer id is primary key which is unique and the customer id in sales table is the one corresponding to the sales and the column representing customer id has possible scenarios of duplication, which means we are banking on customer table to identify the customer who purchased x product. Going by this logic is is it correct to say that the two table establishes one to many relationship.

Hi Gunjan! Thanks for reaching out. You understand it very well. Congratulations! Keep it up with the good work! Hope this helps. Best, Tsvetelin

Follow this topic

Last answered:

16 Dec 2021

Posted on:

21 Nov 2021

Realationship between Customer table and Sales table

1 answers ( 0 marked as helpful)

Instructor

Posted on:

16 Dec 2021