SQL Relationships

Copper Contributor

 

Is this right (valid)?

 

The Garment Table has a Many to Many, Recursive relationship.

1 Dress can be matched with many Coats.

1 Coat can be matched with many Dresses.

 

 

4 Replies

 


Is this right (valid)?

@McClendon111 , we don't know your business rules, so know one can say, if it's right or wrong.

@olafhelper 

 

Thanks for your reply. I'm only asking if that kind of relationship is possible, valid, techinicqlly speaking. I believe it it but it's been 20 years since I've worked with SQL databases logic

Of course is a many-to-many relation possible and can be valid.
Thanks!