Get startedGet started for free

One-to-many classification

Understanding the difference between a one-to-one and one-to-many relationship is a useful skill. In this exercise, consider a set of tables from an e-commerce website. The hypothetical tables are the following:

  • A customer table with information about each customer
  • A cust_tax_info table with customers unique tax IDs
  • An orders table with information about each order
  • A products table with details about each unique product sold
  • An inventory table with information on how much total inventory is available to sell for each product

This exercise is part of the course

Joining Data with pandas

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise