· 5 years ago · Jul 19, 2020, 01:06 PM
1/*==============================================================*/
2/* DBMS name: Microsoft SQL Server 2008 */
3/* Created on: 21.06.2020 09:35:15 */
4/*==============================================================*/
5
6
7if exists (select 1
8 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
9 where r.fkeyid = object_id('faktura') and o.name = 'FK_FAKTURA_R_1_FORMA_PL')
10alter table faktura
11 drop constraint FK_FAKTURA_R_1_FORMA_PL
12go
13
14if exists (select 1
15 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
16 where r.fkeyid = object_id('pracownik') and o.name = 'FK_PRACOWNI_R_6_STANOWIS')
17alter table pracownik
18 drop constraint FK_PRACOWNI_R_6_STANOWIS
19go
20
21if exists (select 1
22 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
23 where r.fkeyid = object_id('pracownik') and o.name = 'FK_PRACOWNI_R_7_FILIA')
24alter table pracownik
25 drop constraint FK_PRACOWNI_R_7_FILIA
26go
27
28if exists (select 1
29 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
30 where r.fkeyid = object_id('pracownik') and o.name = 'FK_PRACOWNI_R_8_DZIAL')
31alter table pracownik
32 drop constraint FK_PRACOWNI_R_8_DZIAL
33go
34
35if exists (select 1
36 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
37 where r.fkeyid = object_id('zamowienie') and o.name = 'FK_ZAMOWIEN_R_2_FAKTURA')
38alter table zamowienie
39 drop constraint FK_ZAMOWIEN_R_2_FAKTURA
40go
41
42if exists (select 1
43 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
44 where r.fkeyid = object_id('zamowienie') and o.name = 'FK_ZAMOWIEN_R_5_PRACOWNI')
45alter table zamowienie
46 drop constraint FK_ZAMOWIEN_R_5_PRACOWNI
47go
48
49if exists (select 1
50 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
51 where r.fkeyid = object_id('zamowienie') and o.name = 'FK_ZAMOWIEN_R_9_KLIENT')
52alter table zamowienie
53 drop constraint FK_ZAMOWIEN_R_9_KLIENT
54go
55
56if exists (select 1
57 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
58 where r.fkeyid = object_id('zamowienie_produkt') and o.name = 'FK_ZAMOWIEN_R_3_PRODUKT')
59alter table zamowienie_produkt
60 drop constraint FK_ZAMOWIEN_R_3_PRODUKT
61go
62
63if exists (select 1
64 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
65 where r.fkeyid = object_id('zamowienie_produkt') and o.name = 'FK_ZAMOWIEN_R_4_ZAMOWIEN')
66alter table zamowienie_produkt
67 drop constraint FK_ZAMOWIEN_R_4_ZAMOWIEN
68go
69
70if exists (select 1
71 from sysobjects
72 where id = object_id('dzial')
73 and type = 'U')
74 drop table dzial
75go
76
77if exists (select 1
78 from sysindexes
79 where id = object_id('faktura')
80 and name = 'R_1_FK'
81 and indid > 0
82 and indid < 255)
83 drop index faktura.R_1_FK
84go
85
86if exists (select 1
87 from sysobjects
88 where id = object_id('faktura')
89 and type = 'U')
90 drop table faktura
91go
92
93if exists (select 1
94 from sysobjects
95 where id = object_id('filia')
96 and type = 'U')
97 drop table filia
98go
99
100if exists (select 1
101 from sysobjects
102 where id = object_id('forma_platnosci')
103 and type = 'U')
104 drop table forma_platnosci
105go
106
107if exists (select 1
108 from sysobjects
109 where id = object_id('klient')
110 and type = 'U')
111 drop table klient
112go
113
114if exists (select 1
115 from sysindexes
116 where id = object_id('pracownik')
117 and name = 'R_8_FK'
118 and indid > 0
119 and indid < 255)
120 drop index pracownik.R_8_FK
121go
122
123if exists (select 1
124 from sysindexes
125 where id = object_id('pracownik')
126 and name = 'R_7_FK'
127 and indid > 0
128 and indid < 255)
129 drop index pracownik.R_7_FK
130go
131
132if exists (select 1
133 from sysindexes
134 where id = object_id('pracownik')
135 and name = 'R_6_FK'
136 and indid > 0
137 and indid < 255)
138 drop index pracownik.R_6_FK
139go
140
141if exists (select 1
142 from sysobjects
143 where id = object_id('pracownik')
144 and type = 'U')
145 drop table pracownik
146go
147
148if exists (select 1
149 from sysobjects
150 where id = object_id('produkt')
151 and type = 'U')
152 drop table produkt
153go
154
155if exists (select 1
156 from sysobjects
157 where id = object_id('stanowisko')
158 and type = 'U')
159 drop table stanowisko
160go
161
162if exists (select 1
163 from sysindexes
164 where id = object_id('zamowienie')
165 and name = 'R_9_FK'
166 and indid > 0
167 and indid < 255)
168 drop index zamowienie.R_9_FK
169go
170
171if exists (select 1
172 from sysindexes
173 where id = object_id('zamowienie')
174 and name = 'R_5_FK'
175 and indid > 0
176 and indid < 255)
177 drop index zamowienie.R_5_FK
178go
179
180if exists (select 1
181 from sysindexes
182 where id = object_id('zamowienie')
183 and name = 'R_2_FK'
184 and indid > 0
185 and indid < 255)
186 drop index zamowienie.R_2_FK
187go
188
189if exists (select 1
190 from sysobjects
191 where id = object_id('zamowienie')
192 and type = 'U')
193 drop table zamowienie
194go
195
196if exists (select 1
197 from sysindexes
198 where id = object_id('zamowienie_produkt')
199 and name = 'R_4_FK'
200 and indid > 0
201 and indid < 255)
202 drop index zamowienie_produkt.R_4_FK
203go
204
205if exists (select 1
206 from sysindexes
207 where id = object_id('zamowienie_produkt')
208 and name = 'R_3_FK'
209 and indid > 0
210 and indid < 255)
211 drop index zamowienie_produkt.R_3_FK
212go
213
214if exists (select 1
215 from sysobjects
216 where id = object_id('zamowienie_produkt')
217 and type = 'U')
218 drop table zamowienie_produkt
219go
220
221/*==============================================================*/
222/* Table: dzial */
223/*==============================================================*/
224create table dzial (
225 id_dzial int not null,
226 nazwa_dzial varchar(40) not null,
227 constraint PK_DZIAL primary key nonclustered (id_dzial)
228)
229go
230
231/*==============================================================*/
232/* Table: faktura */
233/*==============================================================*/
234create table faktura (
235 id_faktura int IDENTITY(1,1) not null,
236 id_forma_platnosci int not null,
237 numer_faktura varchar(15) not null,
238 data_wystawienia_faktura datetime not null,
239 termin_platnosci_faktura datetime not null,
240 constraint PK_FAKTURA primary key nonclustered (id_faktura)
241)
242go
243
244/*==============================================================*/
245/* Index: R_1_FK */
246/*==============================================================*/
247create index R_1_FK on faktura (
248id_forma_platnosci ASC
249)
250go
251
252/*==============================================================*/
253/* Table: filia */
254/*==============================================================*/
255create table filia (
256 id_filia int IDENTITY(1,1) not null,
257 nazwa_filia varchar(30) not null,
258 constraint PK_FILIA primary key nonclustered (id_filia)
259)
260go
261
262/*==============================================================*/
263/* Table: forma_platnosci */
264/*==============================================================*/
265create table forma_platnosci (
266 id_forma_platnosci int IDENTITY(1,1) not null,
267 nazwa_forma_platnosci varchar(20) not null,
268 constraint PK_FORMA_PLATNOSCI primary key nonclustered (id_forma_platnosci)
269)
270go
271
272/*==============================================================*/
273/* Table: klient */
274/*==============================================================*/
275create table klient (
276 id_klient int IDENTITY(1,1) not null,
277 imie_klient varchar(30) not null,
278 nazwisko_klient varchar(30) not null,
279 adres_1 varchar(50) not null,
280 adres_2 char(6) not null,
281 adres_3 varchar(30) not null,
282 constraint PK_KLIENT primary key nonclustered (id_klient)
283)
284go
285
286/*==============================================================*/
287/* Table: pracownik */
288/*==============================================================*/
289create table pracownik (
290 id_pracownik int IDENTITY(1,1) not null,
291 id_stanowisko int not null,
292 id_dzial int not null,
293 id_filia int not null,
294 imie_pracownik varchar(30) not null,
295 nazwisko_pracownik varchar(30) not null,
296 pesel_pracownik char(11) not null,
297 constraint PK_PRACOWNIK primary key nonclustered (id_pracownik)
298)
299go
300
301/*==============================================================*/
302/* Index: R_6_FK */
303/*==============================================================*/
304create index R_6_FK on pracownik (
305id_stanowisko ASC
306)
307go
308
309/*==============================================================*/
310/* Index: R_7_FK */
311/*==============================================================*/
312create index R_7_FK on pracownik (
313id_filia ASC
314)
315go
316
317/*==============================================================*/
318/* Index: R_8_FK */
319/*==============================================================*/
320create index R_8_FK on pracownik (
321id_dzial ASC
322)
323go
324
325/*==============================================================*/
326/* Table: produkt */
327/*==============================================================*/
328create table produkt (
329 id_produkt int IDENTITY(1,1) not null,
330 nazwa_produkt varchar(30) not null,
331 cena_produkt decimal(8,2) not null,
332 constraint PK_PRODUKT primary key nonclustered (id_produkt)
333)
334go
335
336/*==============================================================*/
337/* Table: stanowisko */
338/*==============================================================*/
339create table stanowisko (
340 id_stanowisko int IDENTITY(1,1) not null,
341 nazwa_stanowisko varchar(40) not null,
342 constraint PK_STANOWISKO primary key nonclustered (id_stanowisko)
343)
344go
345
346/*==============================================================*/
347/* Table: zamowienie */
348/*==============================================================*/
349create table zamowienie (
350 id_zamowienie int IDENTITY(1,1) not null,
351 id_faktura int not null,
352 id_pracownik int not null,
353 id_klient int not null,
354 numer_zamowienia varchar(6) not null,
355 data_przyjecia_zamowienie datetime not null,
356 data_realizacji datetime null,
357 constraint PK_ZAMOWIENIE primary key nonclustered (id_zamowienie)
358)
359go
360
361/*==============================================================*/
362/* Index: R_2_FK */
363/*==============================================================*/
364create index R_2_FK on zamowienie (
365id_faktura ASC
366)
367go
368
369/*==============================================================*/
370/* Index: R_5_FK */
371/*==============================================================*/
372create index R_5_FK on zamowienie (
373id_pracownik ASC
374)
375go
376
377/*==============================================================*/
378/* Index: R_9_FK */
379/*==============================================================*/
380create index R_9_FK on zamowienie (
381id_klient ASC
382)
383go
384
385/*==============================================================*/
386/* Table: zamowienie_produkt */
387/*==============================================================*/
388create table zamowienie_produkt (
389 id_produkt int not null,
390 id_zamowienie int not null,
391 ilosc int not null,
392 constraint PK_ZAMOWIENIE_PRODUKT primary key (id_produkt, id_zamowienie)
393)
394go
395
396/*==============================================================*/
397/* Index: R_3_FK */
398/*==============================================================*/
399create index R_3_FK on zamowienie_produkt (
400id_produkt ASC
401)
402go
403
404/*==============================================================*/
405/* Index: R_4_FK */
406/*==============================================================*/
407create index R_4_FK on zamowienie_produkt (
408id_zamowienie ASC
409)
410go
411
412alter table faktura
413 add constraint FK_FAKTURA_R_1_FORMA_PL foreign key (id_forma_platnosci)
414 references forma_platnosci (id_forma_platnosci)
415go
416
417alter table pracownik
418 add constraint FK_PRACOWNI_R_6_STANOWIS foreign key (id_stanowisko)
419 references stanowisko (id_stanowisko)
420go
421
422alter table pracownik
423 add constraint FK_PRACOWNI_R_7_FILIA foreign key (id_filia)
424 references filia (id_filia)
425go
426
427alter table pracownik
428 add constraint FK_PRACOWNI_R_8_DZIAL foreign key (id_dzial)
429 references dzial (id_dzial)
430go
431
432alter table zamowienie
433 add constraint FK_ZAMOWIEN_R_2_FAKTURA foreign key (id_faktura)
434 references faktura (id_faktura)
435go
436
437alter table zamowienie
438 add constraint FK_ZAMOWIEN_R_5_PRACOWNI foreign key (id_pracownik)
439 references pracownik (id_pracownik)
440go
441
442alter table zamowienie
443 add constraint FK_ZAMOWIEN_R_9_KLIENT foreign key (id_klient)
444 references klient (id_klient)
445go
446
447alter table zamowienie_produkt
448 add constraint FK_ZAMOWIEN_R_3_PRODUKT foreign key (id_produkt)
449 references produkt (id_produkt)
450go
451
452alter table zamowienie_produkt
453 add constraint FK_ZAMOWIEN_R_4_ZAMOWIEN foreign key (id_zamowienie)
454 references zamowienie (id_zamowienie)
455go
456
457INSERT INTO filia (nazwa_filia) VALUES ('Wrocław'), ('Kraków'), ('Warszawa'),
458('Poznań');
459INSERT INTO dzial (nazwa_dzial) VALUES ('Sprzedaż'), ('Kadry'), ('Obsługa klienta'),
460('Marketing');
461INSERT INTO forma_platnosci (nazwa_forma_platnosci) VALUES ('Gotówka'), ('Przelew
462odroczony'), ('Przelew');
463INSERT INTO stanowisko (nazwa_stanowisko) VALUES ('Pracownik biurowy'), ('Kadrowa'),
464('Sprzedawca'), ('Handlowiec');
465INSERT INTO produkt (nazwa_produkt, cena_produkt) VALUES ('Tusz ZZWQ22', 100),
466('Papier A4', 15.99), ('Monitor LCD17', 459.99), ('Monitor LCD24', 689.99), ('Toner
467M23', 256.99), ('Toner H323', 276.99), ('Toner Y652', 311.99), ('Toner W235R',
468256.99), ('Mysz optyczna KK23', 168.99), ('Mysz optyczna YRK32W', 126.99), ('Mysz
469optyczna ZYR65WQ', 224.99), ('Monitor LCD24DH', 1029.99), ('Monitor LCD24DHYW',
4701259.99);
471INSERT INTO klient (imie_klient, nazwisko_klient, adres_1, adres_2, adres_3) VALUES
472('Maurycy', 'Bednarski', 'ul. Niecała 8/9', '52-156', 'Środa Śląska'), ('Kamila',
473'Konarska', 'Będkowice 38', '54-523', 'Wrocław'), ('Wociech', 'Uciechowski', 'ul.
474Wąska 23a', '55-689', 'Raszyn'), ('Jan', 'Jankowski', 'ul. Krótka 2a', '69-112',
475'Poznań'), ('Bożena', 'Wielka', 'ul. Balicka 55/45', '28-569', 'Kraków');
476INSERT INTO pracownik (id_stanowisko, id_dzial, id_filia, imie_pracownik,
477nazwisko_pracownik, pesel_pracownik) VALUES
478((SELECT id_stanowisko FROM stanowisko WHERE nazwa_stanowisko = 'Pracownik biurowy'),
479(SELECT id_dzial FROM dzial WHERE nazwa_dzial = 'Sprzedaż'), (SELECT id_filia FROM
480filia WHERE nazwa_filia = 'Wrocław'), 'Jan', 'Kowalski', '67121323456'),
481((SELECT id_stanowisko FROM stanowisko WHERE nazwa_stanowisko = 'Kadrowa'), (SELECT
482id_dzial FROM dzial WHERE nazwa_dzial = 'Kadry'), (SELECT id_filia FROM filia WHERE
483nazwa_filia = 'Warszawa'), 'Maria', 'Wróblewska', '88081298765'),
484((SELECT id_stanowisko FROM stanowisko WHERE nazwa_stanowisko = 'Sprzedawca'), (SELECT
485id_dzial FROM dzial WHERE nazwa_dzial = 'Obsługa klienta'), (SELECT id_filia FROM
486filia WHERE nazwa_filia = 'Poznań'), 'Maksymilian', 'Zabłocki', '89031202562'),
487((SELECT id_stanowisko FROM stanowisko WHERE nazwa_stanowisko = 'Handlowiec'), (SELECT
488id_dzial FROM dzial WHERE nazwa_dzial = 'Marketing'), (SELECT id_filia FROM filia
489WHERE nazwa_filia = 'Kraków'), 'Walery', 'Walerowski', '91326502336');
490INSERT INTO faktura (id_forma_platnosci, numer_faktura, termin_platnosci_faktura,
491data_wystawienia_faktura) VALUES
492((SELECT id_forma_platnosci FROM forma_platnosci WHERE nazwa_forma_platnosci =
493'Gotówka'), '333/2016', '01/31/2016', '01/13/2016'),
494((SELECT id_forma_platnosci FROM forma_platnosci WHERE nazwa_forma_platnosci =
495'Przelew odroczony'), '334/2016', '02/28/2016', '02/25/2016'),
496((SELECT id_forma_platnosci FROM forma_platnosci WHERE nazwa_forma_platnosci =
497'Przelew'), '335/2016', '04/30/2016', '03/16/2016'),
498((SELECT id_forma_platnosci FROM forma_platnosci WHERE nazwa_forma_platnosci =
499'Przelew'), '498/2016', '07/02/2016', '06/23/2016'),
500((SELECT id_forma_platnosci FROM forma_platnosci WHERE nazwa_forma_platnosci =
501'Gotówka'), '566/2016', '08/24/2016', '08/18/2016'),
502((SELECT id_forma_platnosci FROM forma_platnosci WHERE nazwa_forma_platnosci =
503'Przelew odroczony'), '689/2016', '03/29/2016', '03/24/2016'),
504((SELECT id_forma_platnosci FROM forma_platnosci WHERE nazwa_forma_platnosci =
505'Przelew odroczony'), '705/2016', '03/29/2016', '03/24/2016');
506INSERT INTO zamowienie (id_faktura, id_klient, id_pracownik, numer_zamowienia,
507data_przyjecia_zamowienie, data_realizacji) VALUES
508((SELECT id_faktura FROM faktura WHERE numer_faktura = '333/2016'), (SELECT id_klient
509FROM klient WHERE imie_klient = 'Maurycy' AND nazwisko_klient = 'Bednarski'), (SELECT
510id_pracownik FROM pracownik WHERE pesel_pracownik = '67121323456'), 253, '01/12/2016',
511'01/14/2016'),
512((SELECT id_faktura FROM faktura WHERE numer_faktura = '334/2016'), (SELECT id_klient
513FROM klient WHERE imie_klient = 'Kamila' AND nazwisko_klient = 'Konarska'), (SELECT
514id_pracownik FROM pracownik WHERE pesel_pracownik = '67121323456'), 368, '02/24/2016',
515'02/26/2016'),
516((SELECT id_faktura FROM faktura WHERE numer_faktura = '335/2016'), (SELECT id_klient
517FROM klient WHERE imie_klient = 'Wociech' AND nazwisko_klient = 'Uciechowski'),
518(SELECT id_pracownik FROM pracownik WHERE pesel_pracownik = '88081298765'), 458,
519'03/15/2016', '03/22/2016'),
520((SELECT id_faktura FROM faktura WHERE numer_faktura = '498/2016'), (SELECT id_klient
521FROM klient WHERE imie_klient = 'Jan' AND nazwisko_klient = 'Jankowski'), (SELECT
522id_pracownik FROM pracownik WHERE pesel_pracownik = '89031202562'), 789, '06/22/2016',
523'06/25/2016'),
524((SELECT id_faktura FROM faktura WHERE numer_faktura = '566/2016'), (SELECT id_klient
525FROM klient WHERE imie_klient = 'Bożena' AND nazwisko_klient = 'Wielka'), (SELECT
526id_pracownik FROM pracownik WHERE pesel_pracownik = '91326502336'), 1024,
527'08/16/2016', '08/22/2016'),
528((SELECT id_faktura FROM faktura WHERE numer_faktura = '689/2016'), (SELECT id_klient
529FROM klient WHERE imie_klient = 'Maurycy' AND nazwisko_klient = 'Bednarski'), (SELECT
530id_pracownik FROM pracownik WHERE pesel_pracownik = '67121323456'), 2068,
531'09/22/2016', NULL),
532((SELECT id_faktura FROM faktura WHERE numer_faktura = '705/2016'), (SELECT id_klient
533FROM klient WHERE imie_klient = 'Wociech' AND nazwisko_klient = 'Uciechowski'),
534(SELECT id_pracownik FROM pracownik WHERE pesel_pracownik = '88081298765'), 3012,
535'09/22/2016', NULL);
536INSERT INTO zamowienie_produkt (id_zamowienie, id_produkt, ilosc) VALUES
537((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 253), (SELECT
538id_produkt FROM produkt WHERE nazwa_produkt = 'Tusz ZZWQ22'), 3),
539((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 253), (SELECT
540id_produkt FROM produkt WHERE nazwa_produkt = 'Papier A4'), 10),
541((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 368), (SELECT
542id_produkt FROM produkt WHERE nazwa_produkt = 'Papier A4'), 20),
543((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 458), (SELECT
544id_produkt FROM produkt WHERE nazwa_produkt = 'Monitor LCD17'), 1),
545((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 458), (SELECT
546id_produkt FROM produkt WHERE nazwa_produkt = 'Monitor LCD24'), 1),
547((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 789), (SELECT
548id_produkt FROM produkt WHERE nazwa_produkt = 'Toner M23'), 2),
549((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 789), (SELECT
550id_produkt FROM produkt WHERE nazwa_produkt = 'Toner H323'), 2),
551((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 789), (SELECT
552id_produkt FROM produkt WHERE nazwa_produkt = 'Toner Y652'), 2),
553((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 789), (SELECT
554id_produkt FROM produkt WHERE nazwa_produkt = 'Toner W235R'), 2),
555((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 1024), (SELECT
556id_produkt FROM produkt WHERE nazwa_produkt = 'Mysz optyczna KK23'), 8),
557((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 1024), (SELECT
558id_produkt FROM produkt WHERE nazwa_produkt = 'Mysz optyczna YRK32W'), 12),
559((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 1024), (SELECT
560id_produkt FROM produkt WHERE nazwa_produkt = 'Mysz optyczna ZYR65WQ'), 16),
561((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 2068), (SELECT
562id_produkt FROM produkt WHERE nazwa_produkt = 'Mysz optyczna KK23'), 3),
563((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 2068), (SELECT
564id_produkt FROM produkt WHERE nazwa_produkt = 'Mysz optyczna YRK32W'), 5),
565((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 3012), (SELECT
566id_produkt FROM produkt WHERE nazwa_produkt = 'Monitor LCD24DH'), 4),
567((SELECT id_zamowienie FROM zamowienie WHERE numer_zamowienia = 3012), (SELECT
568id_produkt FROM produkt WHERE nazwa_produkt = 'Monitor LCD24DHYW'), 8);