Extras din proiect
TEMA APLICATIA 1
CREATE TABLE Furnizori
(codfz INTEGER CONSTRAINT nn_codfz NOT NULL
CONSTRAINT pk_codfz PRIMARY KEY,
Denfz TEXT(20),localitfz TEXT(20),adresafz TEXT(50),
emailfz TEXT(30),bancafz TEXT(20),contfz TEXT (24));
CREATE TABLE Produse
(codp INTEGER CONSTRAINT nn_codp NOT NULL,
CONSTRAINT pk_codp PRIMARY KEY,
denp TEXT(20),unitatep TEXT(25),stocp NUMBER,pretup NUMBER);
CREATE TABLE Magazii
(codm INTEGER CONSTRAINT nn_codm NOT NULL
CONSTRAINT pk_codm PRIMARY KEY,
denm TEXT(30),gestionarm TEXT(20));
CREATE TABLE Facturi
(codnrf INTEGER CONSTRAINT nn_codnrf NOT NULL
CONSTRAINT pk_codnrf PRIMARY KEY,
dataf DATE,codfz INTEGER CONSTRAINT nn_codfz NOT NULL
CONSTRAINT fk_codfz REFERENCES Furnizori(codfz));
CREATE TABLE Linii facturi
(IDliniif INTEGER CONSTRAINT nn_IDliniif NOT NULL
CONSTRAINT pk_IDliniif PRIMARY KEY,
cantp NUMBER,nrcrt NUMBER,
codp INTEGER CONSTRAINT nn_codp NOT NULL
CONSTRAINT fk_codp REFERENCES Produse(codp),
codnrf INTEGER CONSTRAINT nn_codnrf NOT NULL
CONSTRAINT fk_codnrf REFERENCES Facturi(codnrf)).
Preview document
Conținut arhivă zip
- Baze de Date Florarie
- Baze de Date Florarie.accdb
- Baze de Date Florarie.docx
- Florarieaccess1.png