create database firma;

use firma;

create table iller(
Posta_Kodu int,
il_Adi nvarchar(50));

create table musteriler(
m_No tinyint,
Posta_Kodu int);

create table urunler(
mu_No tinyint,
urun_Adi nvarchar(50),
urun_Adeti int);

insert into iller values
(2000,"Adıyaman"),
(5000,"Amasya"),
(15000,"Burdur"),
(35000,"İzmir");

insert into urunler values 
(1,"Çanta",5),
(1,"CD",200),
(1,"Kitap",3),
(2,"Çanta",2),
(3,"Laptop",1),
(4,"Kitap",2),
(4,"Defter",50);

insert into musteriler values 
(1,2000),
(2,5000),
(3,15000),
(4,35000);

select * from musteriler;

select * from urunler;

select * from iller;