Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table EMPLEADO(
- codigo_c varchar(20) primary key,
- nombre varchar(30) not null,
- edad int(2) not null,
- oficio varchar(15) not null,
- dir varchar(15) not null,
- fecha_alt varchar(15) not null,
- salario int(7) not null,
- comision int(5) not null,
- depto_no int(3) not null
- );
- create table DEPARTAMENTO(
- depto_num int(3) primary key,
- nombre_depto varchar(20) not null,
- localizacion varchar(15) not null,
- foreign key (depto_num) references EMPLEADO(depto_no)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement