Работа с БД SQL

CREATE DATABASE ObminnuyPunkt;
 
USE ObminnuyPunkt;
 
CREATE TABLE ObminnuyPunkt(
 Id INT PRIMARY KEY AUTO_INCREMENT,
 Name VARCHAR(130),
 Address VARCHAR(200),
 DirectorPIB VARCHAR(200),
 ObminnuyPunktNomer INT,
 KupivlyaProdazId INT
);
 
 
CREATE TABLE KupivlyaProdaz(
 Id INT PRIMARY KEY AUTO_INCREMENT,
 Valyutu VARCHAR(130),
 KupivlyaProdazh VARCHAR(130),
 VartistValyut INT(130),
 Address VARCHAR(200),
 KrayinuValyutId INT
);
 
 
CREATE TABLE KrayinuValyut (
 Id INT PRIMARY KEY AUTO_INCREMENT,
 Country VARCHAR(30),
 Valyuta VARCHAR (30),
 ValyutuStanomNaId INT
);
 
 
CREATE TABLE ValyutuStanomNas(
 Id INT PRIMARY KEY AUTO_INCREMENT,
 Nazwa VARCHAR(130),
 Price INT,
 DATE datetime,
 ObminnuyPunktId INT
);
 
 
 
 
ALTER TABLE ObminnuyPunkt 
ADD FOREIGN KEY(KupivlyaProdazId) REFERENCES KupivlyaProdaz(Id);
 
ALTER TABLE KupivlyaProdaz 
ADD FOREIGN KEY(KrayinuValyutId) REFERENCES KrayinuValyut(Id);
 
ALTER TABLE KrayinuValyut 
ADD FOREIGN KEY(ValyutuStanomNasId) REFERENCES ValyutuStanomNa(Id);
 
ALTER TABLE ValyutuStanomNas 
ADD FOREIGN KEY(ObminnuyPunktId) REFERENCES ObminnuyPunkt(Id);
 
 
USE ObminnuyPunkt;
 
INSERT INTO ObminnuyPunkt (Name, Address, DirectorPIB, ObminnuyPunktNomer, KupivlyaProdazId)
VALUES
("Privat bank", "Ukraine, Ternopil, pr.Stepana Banderu", "Boyko A.V.", 19384723, 1),
("Raifaisen bankaval", "Ukraine, Chernivtsyi, Shevchenka street", "Gogoc B.I.", 18234753, 2),
("Alfa bank", "Ukraine, Chmelnitskiy, Bogdana Chmelnitskogo", "Zhmura V.I.", 12954303, 3),
("Privat bank", "Ukraine, Ivano-Frankivsk, L'vivska","Koloda M.K.", 13214723, 4),
("Raifaisen bankaval", "Ukraine, Vinnitsya, Babiy sreet", "Takizava S.R", 13124335, 5),
("Alfa bank", "Ukraine, Odessa, Chehova", "Kushnir V.V.", 23384723, 6),
("Privat bank", "Ukraine, Simferopol', Miru street", "Gogoc B.I.", 11234753, 7),
("Raifaisen bankaval", "Ukraine, Lviv, Troleybusna", "Zhmura V.I.", 14224303, 8),
("Privat bank", "Ukraine, Kyiv, St. Ioan street","Koloda M.K.", 13211243, 9),
("Alfa bank", "Ukraine, Ternopil, Lesi Ukrainku", "Takizava S.R", 13124535,10);
 
 
INSERT INTO KupivlyaProdaz(Valyutu, KupivlyaProdazh, VartistValyut, KrayinuValyutId)
VALUES
("USD","Kupivlya-Prodazh", 35, 1),
("EUR","Kupivlya-Prodazh", 38, 2),
("BYR","Kupivlya-Prodazh", 10, 6),
("AUD","Kupivlya-Prodazh", 5, 3),
("WST","Kupivlya-Prodazh", 11, 5),
("CZK","Kupivlya-Prodazh", 7, 4),
("SEK","Kupivlya-Prodazh", 345, 7),
("TRY","Kupivlya-Prodazh", 11, 8),
("BYN","Kupivlya-Prodazh", 1, 9),
("SEK","Kupivlya-Prodazh", 8, 10);
 
 
INSERT INTO KrayinuValyut (Country, Valyuta, ValyutuStanomNaId)
VALUES
( "United States", "USD", 1),
( "GB", "FT", 2),
( "Belarus", "BYN", 3),
( "Giblartar", "GIP", 4),
( "Australian", "AUD", 5),
( "Samoan", "WST", 6),
("Czech", "CZK", 7),
( "Shweden", "SEK", 8),
( "Turkey", "TRY", 9);
 
INSERT INTO ValyutuStanomNas(Nazwa, Price, DATE, ObminnuyPunktId)
VALUES
("USD", 35, "2018-10-05", 1),
("EUR", 38, "2018-11-03", 2),
("BYN", 0.345,   "2018-01-01", 3),
("GIP", 11,   "2018-05-11", 4),
("AUD", 07,   "2018-03-07", 5),
("WST", 16,   "2018-11-11", 6),
("CZK", 10,  "2018-11-09", 7),
("CHF" ,09,   "2018-06-10", 8),
("SEK", 18,   "2018-02-05", 9),
("TRY", 02,   "2018-07-03", 10)