/dsc-1-05-13-one-to-many-and-many-to-many-joins-lab-online-ds-ft-021119

Primary LanguageJupyter Notebook

One-to-Many and Many-to-Many Joins - Lab

Introduction

In this lab, you'll practice your knowledge on One-to-Many and Many-to-many relationships!

Objectives

You will be able to:

  • Query data including Many-to-Many relationships
  • Write queries that make use of Join Tables

One-to-Many and Many-to-Many Joins

Employees and their Office (a One-to-One join)

Return a list of all of the employees with their first name, last name and the city and state of the office that they work out of (if they have one). Include all employees and order them by their first name, then their last name.

#Your code here

Customers and their Orders (a One-to-Many join)

Return a list of all of the customers. For each customer return a record for each of their order numbers, order dates and statuses.

# Your code here

Orders and their Order Details (another One-to-Many join)

Return a list of orders. For each order return a record for each order detail within the order.

# Your code here

Orders, Order details and Product Details (a Many-to-Many Join)

Return a list of the orders with the the order information, and all the product information for each product in the order.

# Your code here

Summary

In this lab, you practiced your knowledge on One-to-Many and Many-to-many relationships!