RelationalDesign: polnenje.sql

File polnenje.sql, 441 bytes (added by 201156, 4 months ago)
Line 
1
2INSERT INTO Firma (Adresa, Broj,Naziv)
3VALUES ('Address 1', '123456')
4
5
6INSERT INTO Artikl (Cena, EdMera, StapkaDDV, Zaliha,Naziv)
7VALUES (10.5, 'Piece', 18.0, 100)
8
9
10INSERT INTO Naracka (Kolicina, Datum, Opis)
11VALUES (2, '2024-02-20', 'First order')
12
13INSERT INTO IzrabotkaPlan (DatumStart, DatumEnd)
14VALUES ('2024-03-01', '2024-03-10')
15
16
17INSERT INTO Faktura (Datum, Iznos, Broj)
18VALUES ('2024-02-25', 50.0, '123ABC')
19
20