MishMash is a supermarket that delivers grocery items and household goods to customers. Each customer can make more than one purchase, but each purchase is made by only one customer.

Data Dictionary:

Variable

Description

Customer$\_$ID

The unique ID for each customer $($integer$).$

First$\_$Name

First name of the customer $($string$).$

Last$\_$Name

Last name of the customer $($string$).$

Address

Address of the customer $($string$).$

Birth$\_$Date

Birthdate of the customer $($date$).$

Points

Number of points the customer received from past purchases $($integer$).$

Purchase$\_$ID

The unique ID for each purchase $($integer$).$

Item

Name of the purchased item $($string$).$

Unit$\_$Price

Price of each unit of the purchased item $($integer$).$

Quantity

Number of units of the item that were purchased $($integer$).$