Furniture Factory

The well-known furniture factory Hi-Key-Ah, intends to implement an information system to store all data on the different types of furniture and components it produces:

The factory produces several lines of furniture, each with a different name and consisting of several pieces of furniture.
All furniture pieces have a unique name, a type (e.g., bed, table, chair, etc), a reference (e.g., CC6578) and a selling price.
Each piece of furniture is composed of several components. The same component can be used more than once in the same piece.
Every component produced is assigned a numerical reference, a manufacturing price and a type (e.g., screw, hinge, board, etc).
The furniture is then sold in various stores throughout the world. Each store has a unique name, an address and a phone number.
To make the manufacturing process more efficient, stores have to place orders every time they need to replenish their stock. These orders must also be stored in the database.
Each order has a number, a date and all the ordered pieces of furniture and their respective quantities.

Acknowledgement

Credits: André Restivo