Relationship Comparison

[bitzgam]

Hello Guys hope your doing great
Whats the difference with this relationship? How do they differ?
Just confused

See Attachment

 

[smig]

In A you will have all countries, and for these also have a state you will get also the state data.
In B you have all state as and for these also have a country you will get also the country data.

 

[MarkK]

But Relationship B doesn't make sense. If a Country record contains a single StateID, then a country can only have one state. #NotWorkable

 

[Thales750]

One of them is valid and the other is not. Bitzgam, if you are a student. In your own words, why does the second one not have any use.

 

[bitzgam]

Thank you Guys for the responses. Now I understand.

@MarkK you explained well thank you Sir

@Thales sorry Sir I cant answer coz honestly I dont know the answer thats why im asking in the first place. Thank You again

GodBless

 

[ButtonMoon]

Neither of these pictures appear to make much sense. They don't use a standard ER modelling notation and the intention isn't exactly clear from the naming conventions either. If we are supposed to understand that the arrowhead points to the attribute(s) being referenced in the parent table then it appears that in A the arrow is probably pointing the wrong way. In B each Country_ID determines a single State_ID - which is probably incorrect.

 

[essaytee]

Neither of these pictures appear to make much sense. They don't use a standard ER modelling notation and the intention isn't exactly clear from the naming conventions either. If we are supposed to understand that the arrowhead points to the attribute(s) being referenced in the parent table then it appears that in A the arrow is probably pointing the wrong way. In B each Country_ID determines a single State_ID - which is probably incorrect.

Makes perfect sense to me. If your only tool is Access, then that's all you're going to get.

Steve.