Sales and Product tables using the product_id column as the join key.product_name from the Product table.year and price columns from the Sales table.product_name, year, and price for each sale_id.erDiagram
Sales ||--o{ Product : has
Sales {
int sale_id
int product_id
int year
int quantity
int price
}
Product {
int product_id
varchar product_name
}