Our example will demonstrate three different table relationships: One-to-One One-to-Many Many-to-Many You can download the schema.sql here, and run it with MySQL client. /* create database */ CREATE DATABASE itblogs DEFAULT CHARACTER SET utf8;   USE itblogs;   /* One-to-One relationship */ /* SHOP – ADDRESS */ CREATE TABLE ADDRESS( id BIGINT NOT NULL AUTO_INCREMENT,