From the course: Microsoft Power Platform Fundamentals (PL-900) Cert Prep: Core Components

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Dataverse relationships

Dataverse relationships

- [Instructor] So we've talked about how Dataverse is a relational database, and let's talk about a little bit of the practical terms of that relational database. So our related tables model our real-world connections of data. So for example, an order could have order items, and that order item could then point to a product, and that is a series of related tables. Dataverse relationships implement the connections between these tables, and these relationships have the behaviors that we have to find to ensure the data integrity. As an example here with our order, if you delete that order, we can define what happens to the additional related records, so if we delete an order, we might want to delete the order items, but we probably don't want to delete the product. We have two types of relationships, one to N and N to one, and then the other type of relationship is the N to N. So that's one to many, many to one, and…

Contents