Class #3 - Data Relationships

追加: 2026-05-30

[00:00:00]Hello and welcome back.

[00:00:02]In our last episode, [music] we learned about entities and attributes, the foundational elements, the DNA of your data.

[00:00:10]But data rarely exists in isolation.

[00:00:13]Just like [music] people have relationships with each other, our data entities relate and interact.

[00:00:19]Understanding these connections is absolutely crucial for building a data [music] model that accurately reflects your business.

[00:00:25]Today, we're going to unravel the different types of relationships [music] that bring our data models to life.

[00:00:31]Let's dive into how our data talks to itself.

[00:00:34]Data relationships come in three primary forms: one-to-one, one-to-many, and many-to-many.

[00:00:41]Each describes a unique way two entities can interact.

[00:00:45]First, one-to-one.

[00:00:47]This means that one instance of entity A is related to exactly [music] one instance of entity B, and vice versa.

[00:00:55]A classic example is person-to-passport.

[00:00:58]One person has one passport, and that passport belongs to only one person.

[00:01:03]These are often used when you need to split data about a single entity, perhaps for security reasons, or to separate rarely accessed information.

[00:01:12]Now, one customer can place many orders, an order belongs to one customer, one-to-many.

[00:01:19]This is perhaps the most common relationship.

[00:01:23]Here, one instance of entity A can be related [music] to many instances of entity B, but an instance of entity B can only be related to one instance of entity A.

[00:01:33]>> [music] >> Think of a customer and their orders.

[00:01:36]One customer can place many orders, but any single order can only belong to one customer. Finally, many-to-many.

[00:01:45]This is where one instance of entity A can relate to many instances of entity B, and one instance of [music] entity B can relate to many instances of entity A.

[00:01:54]A great example is students and courses.

[00:01:57]One student can [music] enroll in multiple courses and one course can have multiple students. In practice, many-to-many relationships are often resolved in the database by introducing an intermediate or associative entity.

[00:02:11]Now, let's get a bit more precise [music] with cardinality and modality.

[00:02:15]Cardinality defines how many instances of one entity relate to how many instances of another.

[00:02:20]For example, a customer can place zero or many orders and order must be placed by exactly one customer.

[00:02:28]It's about the count, the numeric aspect of the relationship.

[00:02:34]Modality tells us [music] whether the relationship is optional or mandatory.

[00:02:38]Does a customer have to have an order?

[00:02:40]Does an order have to have a customer?

[00:02:43]These are typically [music] depicted in an entity-relationship diagram or ERD using something called crow's foot notation.

[00:02:51]A circle before the line signifies zero, optional.

[00:02:55]A single line means one, mandatory, and the crow's foot symbol means many. Let's look at our customer order example.

[00:03:04]On the customer side, [music] we might see a single line and a crow's foot at the order entity, indicating that one customer can have one or many orders.

[00:03:13]Conversely, on the order side pointing back to customer, you'd likely see a single line and a single line.

[00:03:20]Meaning an order must have exactly one customer.

[00:03:23]This notation elegantly captures both how many and whether it's optional or required. To recap, data relationships, one-to-one, one-to-many, and many-to-many are the essential ties that bind your entities together.

[00:03:38]Combined with cardinality and modality, they precisely define how your data interacts, [music] making your model clear, accurate, and functional.

[00:03:49]Understanding these connections is vital for navigating your data effectively and ensuring its integrity.

[00:03:55]Take some time to practice identifying relationships in your own data sets.

[00:04:00]In our next episode, we'll shift gears and look at the different stages of building a data model from high-level concepts to database specific designs.

[00:04:09]Don't [music] miss it.

[00:04:12]I hope you like the content. If yes, provide your like, >> [music] >> subscribe to this channel, and share with others. See you in our next class.