The following information allows you to understand the organization of the data in our sample Jigsaw database. In the first place, you have the entity relationship diagram (ERD) for the js database:
ERD for the Jigsaw database
The following table contains a brief explanation of what each table is for:
|
Table |
Content |
|
manufacturers |
Information about manufacturers of the products. |
|
products |
It contains information about products such as puzzles and accessories. The table has descriptive information and data about prices and stock. The pro_type column has the type of product—puzzle, glue, and ... |
