how to create one-to-one relatinship between two tables
Hi,
I know how to join two tables on basis of one-to-many relationship.
one should be primary and the other should be a reference key.
then in er diagram we get one to many relationship.
How we can get this relationship in case of one-to-one when we want to relate two tables where both are primary keys.
how can we get a one to one relatinship in Toad ER diagram. as i did by adding a primary key in both tables but i cant get them in toad.
Does anybody can help.
Thanks