CREATE TABLE country (id int NOT NULL, name varchar(50) DEFAULT NULL, PRIMARY KEY (id));

INSERT INTO country values(1,'Argentina'),(2,'China'),(3,'Russia'),(4,'Niger'),(5,'Portugal'),(6,'Belarus'),(7,'Ireland'),(8,'Japan'),(9,'Angola'),(10,'Kazakhstan');

CREATE TABLE provider( 
id int NOT NULL, 
name varchar(50) DEFAULT NULL, 
country_id int DEFAULT NULL, 
PRIMARY KEY (id), 
FOREIGN KEY (country_id) REFERENCES country (id));

INSERT INTO provider VALUES(1,'Andalax',9),(2,'Cardguard',4),(3,'Holdlamis',8),(4,'Bitchip',2),(5,'Tin',9),(6,'Holdlamis',10),(7,'Home Ing',4),(8,'Y-find',7),(9,'Zathin',1),(10,'Alphazap',10); 

CREATE TABLE furniture(
id int NOT NULL, name varchar(50) DEFAULT NULL, 
provider_id int DEFAULT NULL, PRIMARY KEY (id), 
FOREIGN KEY (provider_id) REFERENCES provider (id));

INSERT INTO furniture VALUES(1,'Sonair',1100,1),(2,'Subin',1100,2),(3,'Viva',1100,3),(4,'Wrapsafe',1000,4),(5,'Voltsillam',1200,5),(6,'Solarbreeze',1000,6),(7,'Opela',1100,7),(8,'Alphazap',1000,8),(9,'Stronghold',1100,9),(10,'Hatity',1000,10);