You plan to create a country entity that contains one record for each country in the world. You need to track which countries a contact visited. No additional data will be tracked. Which type of relationship should you create?
A.
a many-to-many (N:N) relationship from the contact to the country
B.
a one-to-many (1:N) relationship from the country to the contact
C.
a many-to-many (N:N) relationship from the contact to the country that has a relationship behavior type of Parental
D.
a one-to-many (1:N) relationship from the contact to the country
One contact record could have multiple countries, but not more than one of the same country (1:N) accordingly, each country would also only be associated with a contact once (1:N).
If there was N:N that would mean that a contact could be associated with the same country many times and visa versa, but the scenario isn't asking for this. It asks for the countries visited, not the number of times a country is visited. D is correct.
The answer is correct, it's D. A one-to-many relationship doesn't mean that records on the "many" side can be used only once. A many-to-many relationship would also work but isn't necessary because, as someone else said, you don't need to see the Contacts against the Country
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Mansi
Highly Voted 5 years, 6 months agoPiia
Highly Voted 5 years, 6 months agoMandya
Most Recent 4 years, 7 months agodark_talent
4 years, 7 months agoCParker
4 years, 11 months agoputo
4 years, 11 months agoceejaybee
5 years agoceejaybee
4 years, 12 months agotroisdsolide
5 years, 1 month agoLarmikann
5 years, 5 months agokainpo
5 years, 1 month agoniksingh
5 years, 5 months ago