1 qadam: create table hisobchi( mijoz id integer generated always as identity, mijoz ismi varchar(30) not null, mijoz familyasi varchar

O‘ZBEKISTON RESPUBLIKASI AXBOROT TEXNOLOGIYALARI VA KOMMUNIKATSIYALARINI RIVOJLANTIRISH VAZIRLIGI
MUHAMMAD AL-XORAZMIY NOMIDAGI TOSHKENT AXBOROT TEXNOLOGIYALARI UNIVERSITETI SAMARQAND FILIALI



“KOMPYUTER INJINIRINGI” FAKULTETI
“Malumotlar Bazasi” KAFEDRASI
“Ma’lumotlar bazasi” fanidan
5-HAFTA LABORATORIYA ISHI
(2-kurslar uchun)


Fan o‘qituvchisi:Xolmatov Orzumurod
Fan o’quvchisi:Bafoqulov Bahriddin

S a m a r q a n d _ 2022

1 - qadam:


create table hisobchi(
mijoz_id integer generated always as identity,
mijoz_ismi varchar(30) not null,
mijoz_familyasi varchar(30) not null,
primary key(mijoz_id)
)



2 - qadam:


create table hisobchi_n(
id integer generated always as identity,
client id int not null,
mijoz_familyasi varchar(30) not null,
changed_on timestamp(5) not null


)



3 - qadam:


create or replace function
log_f_ism_changes()
returns trigger
language plpgsql
as
$$
begin
if new, mijoz_ismi<>old.mijoz_ismi then
insert into xaridor_nazorati
(mijoz_id, first_name, changed_on)
values(old.id, old.mijoz_ismi, now());
end if;
return new;
end;
$$



4 - qadam:


create trigger mijoz_ismi_changes
before update
on hisobchi
for each row
execute procedure log_f_ism_changes()





5 - qadam:


insert into hisobchi(mijoz_ismi, mijoz_familyasi)
values('Bafoqulov', 'Bahriddin'), ('Roziboyev', 'Begzod')

6 - qadam: