Book Image

Intelligent IoT Projects in 7 Days

By : Agus Kurniawan
Book Image

Intelligent IoT Projects in 7 Days

By: Agus Kurniawan

Overview of this book

Intelligent IoT Projects in 7 days is about creating smart IoT projects in just 7 days. This book will help you to overcome the challenge of analyzing data from physical devices. This book aims to help you put together some of the most exciting IoT projects in a short span of time. You'll be able to use these in achieving or automating everyday tasks—one project per day. We will start with a simple smart gardening system and move on to a smart parking system, and then we will make our own vending machine, a smart digital advertising dashboard, a smart speaker machine, an autonomous fire fighter robot, and finally look at a multi-robot cooperation using swarm intelligence
Table of Contents (9 chapters)
Essential Hardware Components

Designing a database model

If you have a vending machine with various products and payment methods, it's recommended you use a database to store all transactions in the vending machine.

Three data points that you should take care about are product, transaction, and machine vending capabilities. In general, we can describe the core database design as follows:

The Product table consists of product information, including quantity and price. If you look at the schema in the figure, there are two fields: product_code and product_vending_code. product_code is the internal manufacturing identity that the system will use for all transactions. You can put Stock Keeping Unit (SKU) data into this field. Each product usually has an SKU ID so we can use it for our product identity. Otherwise, the product_vending_code field is designed for identity numbers on vending machines. These are...