DA 100 - Data Modeling in Power BI

[giovannafnr88]

What would be the correct answer? I think it could be both the first and the second, because he doesn't say that a course can only have a tutor.

You plan to create relationships between the tables in order to arrange a report that shows student and their associated courses.

A student can have multiple tutors. A tutor can only be associated with one student. Each tutor is associated with only one course.

How should you configure the relationship from Course to Tutor?

1. one-to-many
2. one-to-may
3. many-to-many
4. many-to-one

[v-kelly-msft · Accepted solution]

Hi  @giovannafnr88 ,

For the criteria you provided,the relationship between Course to Tutor can be one to one or many to one.

As the relationship between tutor and course is fixed as : one to one.

So from Course to Tutor,the Tutor side should be one,but the Course side is not determined.

All depends on the data structure.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[giovannafnr88]

I agree, but the correct answer they put as the 1

[Anonymous]

Hi @giovannafnr88 

As it says "Each tutor is associated with only one course".

That means each course may have multiple tutors.

So, "Course to Tutor" relationship will be

2. one-to-many