Free Preparation Discussions
MENU
Microsoft PL-600 Exam - Topic 1 Question 89 Discussion
Topic #: 1
You are designing the data model for a school. The school wants to track students' enrollments in courses.
The system must meet the following requirements:
Track the courses in which each student is enrolled.
Track the students that are enrolled in each course.
Track dates when each student enrolled in each course and the person who approved the enrollment.
Allow users to create a report that details which students are enrolled in which courses.
You need to recommend a data model that will fit the school's requirements.
Which logical model should you recommend?
Need a relationship table.
N:N (Many-to-Many): A table relationship that depends on a special Relationship table, sometimes called an
Intersect table, so that many rows of one table can be related to many rows of another table.
When viewing rows of either table in a N:N relationship you can see a list of any rows of the other table that are
related to it.
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships
Caren
2 days agoDierdre
7 days agoErasmo
25 days agoRoosevelt
1 month agoJess
1 month agoAntonio
1 month agoKanisha
2 months agoMicaela
2 months agoRuthann
2 months agoMadalyn
2 months agoFlorinda
2 months agoRessie
2 months agoIrma
3 months agoJesusa
3 months agoShaquana
3 months agoMaybelle
3 months agoLevi
3 months agoSue
4 months agoNickolas
4 months agoCletus
4 months agoPeggie
4 months ago