DROP TABLE Dependenti;
 CREATE TABLE Dependenti(
	IDAngajat int NOT NULL PRIMARY KEY,
	Nume varchar(32),
	Prenume varchar(32),
	DataN datetime,
	GradRudenie varchar(27)
);
 DROP TABLE Ingineri;
CREATE TABLE Ingineri(
	IdAngajat int NOT NULL PRIMARY KEY,
	Specialitate varchar(32)
);
 DROP TABLE Secretare;
CREATE TABLE Secretare(
	IdAngajat int NOT NULL PRIMARY KEY,
	VitezaRedactare int
);

DROP TABLE Sectii;
CREATE TABLE Sectii(
	IdSectii int NOT NULL PRIMARY KEY,
	Nume varchar(32),
	Buget decimal
);

DROP TABLE Angajati;
CREATE TABLE Angajati(
	IdAngajat int NOT NULL PRIMARY KEY,
	Nume varchar(32),
	Prenume varchar(32),
	DataNasterii datetime,
	Adresa varchar(42),
	Functie varchar(26),
	Salariu decimal,
	IdSectie int
);

DROP TABLE Achizitii;
CREATE TABLE Achizitii(
	IdAchizite int NOT NULL PRIMARY KEY,
	IdFurnizor int,
	IdComponenta int,
	IdAchizitor int,
	Data datetime,
	NrComponente int,
	PretUnitar decimal
);
DROP TABLE Compozitii;
CREATE TABLE Compozitii(
	IdComponenta int NOT NULL PRIMARY KEY,
	IdProdus int,
	NrComponente int
);
DROP TABLE Vanzari;
CREATE TABLE Vanzari(
	IdVanzare int NOT NULL PRIMARY KEY,
	IdProdus int,
	IdClient int,
	IdVanzator int,
	Data datetime,
	NrProduse int
);
DROP TABLE Activitati;
CREATE TABLE Activitati(
	IdProiect int NOT NULL PRIMARY KEY,
	IdAngajat int,
	Ore int
);
DROP TABLE Furnizori;
CREATE TABLE Furnizori(
	IdFurnizor int NOT NULL PRIMARY KEY,
	Nume varchar(32),
	Prenume varchar(32),
	Adresa varchar(42)
);
DROP TABLE Componente;
CREATE TABLE Componente(
	IdComponenta int NOT NULL PRIMARY KEY,
	Denumire varchar(32),
	Descriere varchar(64)
);
DROP TABLE Produse;
CREATE TABLE Produse(
	IdProdus int NOT NULL PRIMARY KEY,
	Denumire varchar(32),
	Descriere varchar(64)
);
DROP TABLE Clienti;
CREATE TABLE Clienti(
	IdClient int NOT NULL PRIMARY KEY,
	Nume varchar(32),
	Prenume varchar(32),
	Adresa varchar(42)
);
DROP TABLE Proiecte;
CREATE TABLE Proiecte(
	IdProiect int NOT NULL PRIMARY KEY,
	Denumire varchar(32),
	Termen datetime,
	Buget decimal
);

ALTER TABLE Dependenti ADD CONSTRAINT fk_dependenti FOREIGN KEY(IdAngajat) REFERENCES Angajati(IdAngajat);
ALTER TABLE Angajati ADD CONSTRAINT fk_angajati FOREIGN KEY(IdSectie) REFERENCES Sectii(IdSectie);
ALTER TABLE Ingineri ADD CONSTRAINT fk_ingineri FOREIGN KEY(IdAngajat) REFERENCES Angajati(IdAngajat);
ALTER TABLE Secretare ADD CONSTRAINT fk_secretare FOREIGN KEY(IdAngajat) REFERENCES Angajati(IdAngajat);
ALTER TABLE Achizitii ADD CONSTRAINT fk_achizitii FOREIGN KEY(IdAchizitor) REFERENCES Angajati(IdAngajat);
ALTER TABLE Vanzari ADD CONSTRAINT fk_vanzari FOREIGN KEY(IdVanzator) REFERENCES Angajati(IdAngajat);
ALTER TABLE Activitati ADD CONSTRAINT fk_activitati FOREIGN KEY(IdAngajat) REFERENCES Angajati(IdAngajat);
ALTER TABLE Achizitii ADD CONSTRAINT fk_achizitii2 FOREIGN KEY(IdFurnizor) REFERENCES Furnizori(IdFurnizor);
ALTER TABLE Achizitii ADD CONSTRAINT fk_achizitii3 FOREIGN KEY(IdComponenta) REFERENCES Componente(IdComponenta);
ALTER TABLE Compozitii ADD CONSTRAINT fk_compozitii FOREIGN KEY(IdComponenta) REFERENCES Componente(IdComponenta);
ALTER TABLE Compozitii ADD CONSTRAINT fk_compozitii2 FOREIGN KEY(IdProdus) REFERENCES Produse(IdProdus);
ALTER TABLE Vanzari ADD CONSTRAINT fk_vanzari2 FOREIGN KEY(IdVanzare) REFERENCES Produse(IdProdus);
ALTER TABLE Vanzari ADD CONSTRAINT fk_vanzari3 FOREIGN KEY(IdClient) REFERENCES Clienti(IdClient);
ALTER TABLE Activitati ADD CONSTRAINT fk_activitati2 FOREIGN KEY(IdProiect) REFERENCES Proiecte(IdProiect);

INSERT INTO Sectii VALUES(1,'Vanzari',2300);
INSERT INTO Sectii VALUES(2,'HR',2500);
INSERT INTO Sectii VALUES(3,'Technical Support',1900);

INSERT INTO Angajati VALUES(1,'Alex','Ion','02/02/1998','Filiasi','Vanzator',800,1);
INSERT INTO Angajati VALUES(2,'Marius','Bobel','04/08/1997','Catane','Resurse umane',1100,2);
INSERT INTO Angajati VALUES(3,'Bobi','Mondialu','02/12/1988','Craiova','QA',120,3);

INSERT INTO Ingineri VALUES(2,'Inginer tehnic');

INSERT INTO Secretare VALUES(1,200);

SELECT * FROM Secretare;