MariaDB [(none)]> create database almacenamiento; Query OK, 1 row affected (0.33 sec) MariaDB [(none)]> use almacenamiento Database changed MariaDB [almacenamiento]> create table operario(idoperario char(5)not null primary key,cedula char(11)not null, nombre char(50)not null, rh char(3)null, fecha_Ingreso date not null); Query OK, 0 rows affected (0.49 sec) MariaDB [almacenamiento]> describe operario -> ; +---------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+-------+ | idoperario | char(5) | NO | PRI | NULL | | | cedula | char(11) | NO | | NULL | | | nombre | char(50) | NO | | NULL | | | rh | char(3) | YES | | NULL | | | fecha_Ingreso | date | NO | | NULL | | +---------------+----------+------+-----+---------+-------+ 5 rows in set (0.18 sec) MariaDB [almacenamiento]> create table maquina(codmaquina char(5)not null primary key, descripcion char(30)not null, seria char(12)not null, activo boolean); Query OK, 0 rows affected (0.10 sec) MariaDB [almacenamiento]> describe maquina -> ; +-------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------+------+-----+---------+-------+ | codmaquina | char(5) | NO | PRI | NULL | | | descripcion | char(30) | NO | | NULL | | | seria | char(12) | NO | | NULL | | | activo | tinyint(1) | YES | | NULL | | +-------------+------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) MariaDB [almacenamiento]> create table lote(codlote char(10)not null primary key); Query OK, 0 rows affected (0.28 sec) MariaDB [almacenamiento]> describe lote; +---------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------+------+-----+---------+-------+ | codlote | char(10) | NO | PRI | NULL | | +---------+----------+------+-----+---------+-------+ 1 row in set (0.00 sec) MariaDB [almacenamiento]> create table seccion(codseccion char(3) not null primary key, nombre char(50)not null, color char(20)not null); Query OK, 0 rows affected (0.19 sec) MariaDB [almacenamiento]> describe seccion; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | codseccion | char(3) | NO | PRI | NULL | | | nombre | char(50) | NO | | NULL | | | color | char(20) | NO | | NULL | | +------------+----------+------+-----+---------+-------+ 3 rows in set (0.00 sec) MariaDB [almacenamiento]> create table localizacion(codlocal char(3)not null primary key, nombre char(50)not null); Query OK, 0 rows affected (0.04 sec) MariaDB [almacenamiento]> describe localizacion; +----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+----------+------+-----+---------+-------+ | codlocal | char(3) | NO | PRI | NULL | | | nombre | char(50) | NO | | NULL | | +----------+----------+------+-----+---------+-------+ 2 rows in set (0.00 sec) MariaDB [almacenamiento]> show tables; +--------------------------+ | Tables_in_almacenamiento | +--------------------------+ | localizacion | | lote | | maquina | | operario | | seccion | +--------------------------+ 5 rows in set (0.01 sec) MariaDB [almacenamiento]> create table producto(codproducto char(5)not null primary key, nombre char(50)not null, costo int not null); Query OK, 0 rows affected (0.08 sec) MariaDB [almacenamiento]> describe producto; +-------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+-------+ | codproducto | char(5) | NO | PRI | NULL | | | nombre | char(50) | NO | | NULL | | | costo | int(11) | NO | | NULL | | +-------------+----------+------+-----+---------+-------+ 3 rows in set (0.00 sec) MariaDB [almacenamiento]> show tables; +--------------------------+ | Tables_in_almacenamiento | +--------------------------+ | localizacion | | lote | | maquina | | operario | | producto | | seccion | +--------------------------+ 6 rows in set (0.00 sec) MariaDB [almacenamiento]> create table operario_maquina(idoperario char(5)not null, codmaquina char(5)not null, foreign key(idoperario)references operario(idoperario)on delete cascade on update cascade, foreign key(codmaquina) references maquina(codmaquina)on delete cascade on update cascade); Query OK, 0 rows affected (0.97 sec) MariaDB [almacenamiento]> show tables; +--------------------------+ | Tables_in_almacenamiento | +--------------------------+ | localizacion | | lote | | maquina | | operario | | operario_maquina | | producto | | seccion | +--------------------------+ 7 rows in set (0.00 sec) MariaDB [almacenamiento]> describe operario_maquina; +------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+---------+------+-----+---------+-------+ | idoperario | char(5) | NO | MUL | NULL | | | codmaquina | char(5) | NO | MUL | NULL | | +------------+---------+------+-----+---------+-------+ 2 rows in set (0.05 sec) MariaDB [almacenamiento]> create table maquina_producto(codmaquina char(5)not null, codproducto char(5)not null, foreign key(codmaquina)references maquina(codmaquina)on delete cascade on update cascade, foreign key(codproducto) references producto(codproducto)on delete cascade on update cascade); Query OK, 0 rows affected (0.06 sec) MariaDB [almacenamiento]> create table lote_seccion(codlote char(10)not null, codseccion char(3)not null, foreign key(codlote) references lote(codlote)on delete cascade on update cascade, foreign key(codseccion) references seccion(codseccion)on delete cascade on update cascade); Query OK, 0 rows affected (0.03 sec) MariaDB [almacenamiento]> create table seccion_local(codseccion char(3)not null, codlocal char(3)not null, foreign key(codseccion) references seccion(codseccion) on delete cascade on update cascade, foreign key (codlocal) references localizacion(codlocal)on delete cascade on update cascade); Query OK, 0 rows affected (0.04 sec) MariaDB [almacenamiento]> create table orden(idorden int auto_increment primary key, codproducto char(5)not null, codlote char(5)not null,cantidad int(8)not null, foreign key (codproducto) references producto(codproducto) on delete cascade on update cascade, foreign key (codlote) references lote(codlote)on delete cascade on update cascade); Query OK, 0 rows affected (0.11 sec) MariaDB [almacenamiento]> show tables; +--------------------------+ | Tables_in_almacenamiento | +--------------------------+ | localizacion | | lote | | lote_seccion | | maquina | | maquina_producto | | operario | | operario_maquina | | orden | | producto | | seccion | | seccion_local | +--------------------------+ 11 rows in set (0.01 sec)