outdoor data structure

The outdoor database contains details on outdoor equipment and the categories they are part of. The recipes that use the outdoor dataset are based on you being part of an outdoor equipment store. The following diagram shows the relationship between the many outdoor products to their given category:

outdoor data structure

products

The products table contains the following details for each product:

Field

Description

Example

Id_product

Identification for the product

12

desc_product

Product's description

Kelty Grand Mesa 2-Person Tent (Ruby/Tan)

price

Product's price

$107.96

Id_category

Identification for the category; it references to the ...

Get Pentaho Data Integration Cookbook Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.