CREATE TABLE Agenti
(
Zona VARCHAR2(10) ,
Cod CHAR(4) NOT NULL PRIMARY KEY,
Nume VARCHAR2 (15) NOT NULL UNIQUE,
Adresa VARCHAR2(20),
Telefon CHAR (9),
Manager VARCHAR2 (15),
tip_ag NUMBER(2) DEFAULT 1);
sau
CREATE TABLE Agenti
(
Zona VARCHAR2(10) ,
Cod CHAR(4)
CONSTRAINT pk_agenti PRIMARY KEY
CONSTRAINT nn_agenti_cod NOT NULL,
Nume VARCHAR2 (15)
CONSTRAINT un_agenti_nume UNIQUE
CONSTRAINT nn_agenti_nume NOT NULL,
Adresa VARCHAR2(20),
Telefon CHAR (9),
Manager VARCHAR2 (15),
tip_ag NUMBER(2) DEFAULT 1);