-- tabela cu vinzarile efectuate DROP TABLE vinzari / CREATE TABLE vinzari ( cods NUMBER(3), codp NUMBER(3), cant NUMBER(5) ) / -- cods cod sectie -- codp cod produs -- cant cantitatea vinduta -- nomenclatorul de sectii DROP TABLE sectii / CREATE TABLE sectii ( cods NUMBER(3), den CHAR(10), etaj NUMBER(2)) / -- nomenclatorul de produse DROP TABLE produse / CREATE TABLE produse ( codp NUMBER(3), den CHAR(20), tip CHAR(2), cul CHAR(15), pret NUMBER(10)) / -- cul culoare -- nomenclatorul de functionari DROP TABLE functionari / CREATE TABLE functionari ( codf NUMBER(3), nume CHAR(30), sef NUMBER(3), cods NUMBER(3), sal NUMBER(10), func CHAR(10)) / -- codf identificatorul functionarului -- sal salariu -- func functie -- nomenclatorul de furnizori DROP TABLE furnizori / CREATE TABLE furnizori ( codf NUMBER(3), numef CHAR(20)) / -- codf cod furnizor -- numef denumire -- produsele furnizate de furnizori unei anumite sectii DROP TABLE furnizeaza ; CREATE TABLE furnizeaza ( codf NUMBER(3), cods NUMBER(3), codp NUMBER(3), cant NUMBER(5)) / INSERT INTO sectii VALUES (1, 'Sectia 1', 3); INSERT INTO sectii VALUES (2, 'Sectia 2', 3); INSERT INTO sectii VALUES (3, 'Sectia 3', 3); INSERT INTO sectii VALUES (4, 'Sectia 4', 2); INSERT INTO sectii VALUES (5, 'Sectia 5', 2); INSERT INTO sectii VALUES (6, 'Sectia 6', 2); INSERT INTO sectii VALUES (7, 'Sectia 7', 1); INSERT INTO sectii VALUES (8, 'Sectia 8', 1); INSERT INTO sectii VALUES (9, 'Sectia 10', 1); INSERT INTO produse VALUES (1, 'Prod.1', 'A', 'galben', 20000); INSERT INTO produse VALUES (2, 'Prod.2', 'B', 'galben', 8000); INSERT INTO produse VALUES (3, 'Prod.3', 'C', 'rosu', 3000); INSERT INTO produse VALUES (4, 'Prod.4', 'A', 'rosu', 4000); INSERT INTO produse VALUES (5, 'Prod.5', 'A', 'rosu', 89898); INSERT INTO produse VALUES (6, 'Prod.6', 'B', 'verde', 7878); INSERT INTO produse VALUES (7, 'Prod.7', 'C', 'maro', 8888); INSERT INTO produse VALUES (8, 'Prod.8', 'C', 'maro', 100); INSERT INTO vinzari VALUES (7, 1, 10); INSERT INTO vinzari VALUES (7, 3, 100); INSERT INTO vinzari VALUES (6, 1, 20); INSERT INTO vinzari VALUES (6, 5, 100); INSERT INTO vinzari VALUES (1, 5, 78); INSERT INTO vinzari VALUES (1, 7, 100); INSERT INTO vinzari VALUES (1, 3, 15); INSERT INTO vinzari VALUES (5, 2, 44); INSERT INTO vinzari VALUES (5, 5, 45); INSERT INTO vinzari VALUES (4, 5, 34); INSERT INTO vinzari VALUES (4, 1, 20); INSERT INTO vinzari VALUES (4, 4, 15); INSERT INTO vinzari VALUES (1, 8, 10); INSERT INTO furnizori VALUES (1, 'Furnizor 1'); INSERT INTO furnizori VALUES (2, 'Furnizor 2'); INSERT INTO furnizori VALUES (3, 'Furnizor 3'); INSERT INTO furnizori VALUES (4, 'Furnizor 4'); INSERT INTO furnizori VALUES (5, 'Furnizor 5'); INSERT INTO furnizeaza VALUES (1, 7, 1, 10); INSERT INTO furnizeaza VALUES (1, 7, 4, 13); INSERT INTO furnizeaza VALUES (1, 7, 5, 113); INSERT INTO furnizeaza VALUES (1, 7, 3, 20); INSERT INTO furnizeaza VALUES (3, 8, 6, 13); INSERT INTO furnizeaza VALUES (3, 8, 7, 13); INSERT INTO furnizeaza VALUES (3, 4, 1, 154); INSERT INTO furnizeaza VALUES (3, 4, 4, 109); INSERT INTO furnizeaza VALUES (3, 4, 5, 289); INSERT INTO furnizeaza VALUES (3, 2, 5, 1); INSERT INTO furnizeaza VALUES (4, 3, 4, 10); INSERT INTO furnizeaza VALUES (4, 3, 5, 11); INSERT INTO furnizeaza VALUES (5, 1, 7, 648); INSERT INTO furnizeaza VALUES (5, 1, 5, 366); INSERT INTO furnizeaza VALUES (1, 8, 3, 10); INSERT INTO furnizeaza VALUES (1, 9, 3, 11); INSERT INTO furnizeaza VALUES (1, 4, 3, 1); INSERT INTO furnizeaza VALUES (1, 5, 3, 100); INSERT INTO furnizeaza VALUES (1, 6, 3, 10); INSERT INTO furnizeaza VALUES (1, 1, 3, 100); INSERT INTO furnizeaza VALUES (1, 2, 3, 19); INSERT INTO furnizeaza VALUES (1, 3, 3, 10); INSERT INTO furnizeaza VALUES (2, 7, 3, 10); INSERT INTO furnizeaza VALUES (2, 8, 3, 10); INSERT INTO furnizeaza VALUES (2, 9, 3, 11); INSERT INTO furnizeaza VALUES (2, 4, 3, 1); INSERT INTO furnizeaza VALUES (2, 5, 3, 100); INSERT INTO furnizeaza VALUES (2, 6, 3, 10); INSERT INTO furnizeaza VALUES (2, 1, 3, 100); INSERT INTO furnizeaza VALUES (2, 2, 3, 19); INSERT INTO furnizeaza VALUES (2, 3, 3, 10); INSERT INTO furnizeaza VALUES (3, 7, 3, 10); INSERT INTO furnizeaza VALUES (3, 8, 3, 10); INSERT INTO furnizeaza VALUES (3, 9, 3, 11); INSERT INTO furnizeaza VALUES (3, 4, 3, 1); INSERT INTO furnizeaza VALUES (3, 5, 3, 100); INSERT INTO furnizeaza VALUES (3, 6, 3, 10); INSERT INTO furnizeaza VALUES (3, 1, 3, 100); INSERT INTO furnizeaza VALUES (3, 2, 3, 19); INSERT INTO furnizeaza VALUES (3, 3, 3, 10); INSERT INTO furnizeaza VALUES (4, 7, 3, 10); INSERT INTO furnizeaza VALUES (4, 8, 3, 10); INSERT INTO furnizeaza VALUES (4, 9, 3, 11); INSERT INTO furnizeaza VALUES (4, 4, 3, 1); INSERT INTO furnizeaza VALUES (4, 5, 3, 100); INSERT INTO furnizeaza VALUES (4, 6, 3, 10); INSERT INTO furnizeaza VALUES (4, 1, 3, 100); INSERT INTO furnizeaza VALUES (4, 2, 3, 19); INSERT INTO furnizeaza VALUES (4, 3, 3, 10); INSERT INTO furnizeaza VALUES (5, 7, 3, 704); INSERT INTO furnizeaza VALUES (5, 8, 3, 10); INSERT INTO furnizeaza VALUES (5, 9, 3, 11); INSERT INTO furnizeaza VALUES (5, 4, 3, 1); INSERT INTO furnizeaza VALUES (5, 5, 3, 100); INSERT INTO furnizeaza VALUES (5, 6, 3, 10); INSERT INTO furnizeaza VALUES (5, 1, 3, 100); INSERT INTO furnizeaza VALUES (5, 2, 3, 19); INSERT INTO furnizeaza VALUES (5, 3, 3, 10); INSERT INTO furnizeaza VALUES (1, 1, 8, 10); INSERT INTO furnizeaza VALUES (1, 2, 8, 10); INSERT INTO furnizeaza VALUES (1, 3, 8, 10); INSERT INTO furnizeaza VALUES (1, 4, 8, 10); INSERT INTO furnizeaza VALUES (1, 5, 8, 10); INSERT INTO furnizeaza VALUES (1, 6, 8, 10); INSERT INTO furnizeaza VALUES (1, 7, 8, 10); INSERT INTO furnizeaza VALUES (1, 8, 8, 10); INSERT INTO furnizeaza VALUES (1, 9, 8, 10); INSERT INTO furnizeaza VALUES (2, 1, 8, 10); INSERT INTO furnizeaza VALUES (3, 1, 8, 10); INSERT INTO furnizeaza VALUES (4, 1, 8, 10); INSERT INTO furnizeaza VALUES (5, 1, 8, 10); INSERT INTO furnizeaza VALUES (1, 6, 1, 70); INSERT INTO furnizeaza VALUES (2, 6, 5, 720); INSERT INTO furnizeaza VALUES (3, 5, 2, 100); INSERT INTO furnizeaza VALUES (4, 5, 5, 34);