close nav

close nav

Thread: Doubt in many to many relationship

Forum : Database Design & Data Modelling   1 Mar, 2021
User Image
AKASH428

Newbie

Joined: 9 Oct, 2020

Points: 100

Threads: 10

Posts: 2

Doubt in many to many relationship

| Quote Date : 1 Mar, 2021    Views:697    

In many to many relationship, instead of taking a third table if I will take PK of second table as a FK in my first table and write the composite primary key(by taking pk of my first table and fk of second table) in my first table only then is it correct?

Comments

User Image
spavan

Newbie

Joined : 14 Dec, 2019

Points : 100

Threads: 0

Posts: 4

Re: Doubt in many to many relationship

Reply Date : 1 Mar, 2021

without taking third table how it is possible to write composite primary key ....if try to write something without 3rd table final result endup in either one-to-many or one-to-one only mostly it becomes one-to-many only

Load More

No More Comments