Entities:

Naracka (Order) Faktura (Invoice) Zaliha (Inventory) Firma (Company) IzrabotkaPlan (Production Plan) Artikli (Articles) Attributes and Keys:

Naracka:

NarackaID (Primary Key) Kolicina (Quantity) Datum (Date)

Artikli:

ArtiklID (Primary Key) EdMera (Unit of Measure) Cena (Price) Stapka (Rate)

Firma:

FirmaID (Primary Key) Adresa (Address) Broj (Number) Faktura: FakturaID (Primary Key) IzrabotkaPlan: NarackaID (Primary Key) DatumStart (Start Date) DatumEnd (End Date)

Zaliha:

DokumentID (Primary Key) ArtiklID Kolicina (Quantity)

Relationships:

Naracka to Artikli (1:N) Firma to Naracka (1:N) Faktura to Artikli (1:N) IzrabotkaPlan to Naracka (1:N) Zaliha to Artikli (1:N)