Guruh Qurvonnazarov Ixlosbek

921_21 guruh
Qurvonnazarov Ixlosbek
create database Avtosalon
use Avtosalon
go
create table Xodimlar(id int, Xodimlar_id int, F_I varchar(100),Tel_raqami int, Ish_vaqti varchar(100) )
insert into Xodimlar values (1, 21,'Nazarov Ali Sadullaevich',994569815,'8 soat'),
(2, 54,'Nazarov Abdukarim ',903654837,'8 soat'),
(3, 36,'Niyozmetov Javohir',903684568,'8 soat'),
(4, 20,'Norqulov Bozor',932545435,'8 soat')

create table Omborxona (id int, Tavar_id int, Keltirilgan_sanasi varchar(30), Tavar_miqdori varchar(30))

insert into Omborxona values(1, 11, '17.10.2022', '101' ),
(1, 24, '03.12.2022', '98' ),
(1, 98, '15.01.2022', '56' ),
(1, 10, '05.07.2022', '51' ),
(1, 13, '30.05.2022', '10' )

create table Tavar (id int, Tavar_id int, Tavar_nomi varchar(30), Tavar_narxi varchar(30), Ombordagi_miqdori varchar(30))

insert into Tavar values (1, 12,'Onix','210000000 som', '101'),
(2, 36, 'Lacetti', '156000000', '98'),
(3, 13,'Avto kuzov', '40000000', '56'),
(6, 14, 'Damas', '786000560', '51'),
(7, 15, 'Malibu','429659800' ,'10')
create table Kredit_bolimi (id int, Kredit_id int, Kredit_turi varchar(30), Kredit_foizi varchar(30), Kredit_miqdori varchar(30))
insert into Kredit_bolimi values (1, 12,'birlamchi_avto_kredit','27 %', '500000000 somgacha'),
(2, 36, 'ikkilamchi_avto_kredit', '25%', '120000000 somgacha')

select * from Tavar

select * from Omborxona
select * from Xodimlar
select * from Kredit_bolimi

create database Avtosalon
use Avtosalon
go
create table Xodimlar(id int, Xodimlar_id int, F_I varchar(100),Tel_raqami int, Ish_vaqti varchar(100) )
insert into Xodimlar values (1, 21,'Nazarov Ali Sadullaevich',994569815,'8 soat'),
(2, 54,'Nazarov Abdukarim ',903654837,'8 soat'),
(3, 36,'Niyozmetov Javohir',903684568,'8 soat'),
(4, 20,'Norqulov Bozor',932545435,'8 soat')

create table Omborxona (id int, Tavar_id int, Keltirilgan_sanasi varchar(30), Tavar_miqdori varchar(30))

insert into Omborxona values(1, 11, '17.10.2022', '101' ),
(1, 24, '03.12.2022', '98' ),
(1, 98, '15.01.2022', '56' ),
(1, 10, '05.07.2022', '51' ),
(1, 13, '30.05.2022', '10' )

create table Tavar (id int, Tavar_id int, Tavar_nomi varchar(30), Tavar_narxi varchar(30), Ombordagi_miqdori varchar(30))

insert into Tavar values (1, 12,'Onix','210000000 som', '101'),
(2, 36, 'Lacetti', '156000000', '98'),
(3, 13,'Avto kuzov', '40000000', '56'),
(6, 14, 'Damas', '786000560', '51'),
(7, 15, 'Malibu','429659800' ,'10')
create table Kredit_bolimi (id int, Kredit_id int, Kredit_turi varchar(30), Kredit_foizi varchar(30), Kredit_miqdori varchar(30))
insert into Kredit_bolimi values (1, 12,'birlamchi_avto_kredit','27 %', '500000000 somgacha'),
(2, 36, 'ikkilamchi_avto_kredit', '25%', '120000000 somgacha')

create table mijozlar(id int, mijoz_ism varchar, mijoz_xaridi varchar(30), mijoz_tel_raqami varchar(30), Kredit_turi varchar(30))

insert into mijozlar values (1, 'Toxirov', 'Lacetti' ,'[phone]', 'birlamchi'),
(2, 'Zokirjonov', 'Onix', '[phone]', 'ikkilamchi'),
(3, 'Rajabov' , 'Malibu', '[phone]', 'naqd')
select * from Tavar
select * from Omborxona
select * from Xodimlar
select * from Kredit_bolimi
select * from Mijozlar