Forum Discussion

giovannafnr88's avatar
giovannafnr88
Frequent Visitor
5 years ago
Solved

DA 100 - Data Modeling in Power BI

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

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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!

3 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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