MariaDB [papeleria]> INSERT INTO producto VALUES ('P001', 'Cuaderno', 1200, 0, 100),('P002', 'L piz', 300, 0, 500),('P003', 'Bol¡grafo', 500, 0, 300),('P004', 'Marcador', 700, 0, 150),('P005', 'Tijeras', 2500, 0, 80),('P006', 'Pegamento', 1800, 0, 90),('P007', 'Borrador', 200, 0, 400),('P008', 'Regla', 1000, 0, 120),('P009', 'Carpeta', 3500, 0, 50),('P010', 'Calculadora', 25000, 0, 30); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> select * from producto; +-------------+-------------+--------------+--------------+------------+ | id_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+-------------+--------------+--------------+------------+ | P001 | Cuaderno | 1200 | 0 | 100 | | P002 | L piz | 300 | 0 | 500 | | P003 | Bol¡grafo | 500 | 0 | 300 | | P004 | Marcador | 700 | 0 | 150 | | P005 | Tijeras | 2500 | 0 | 80 | | P006 | Pegamento | 1800 | 0 | 90 | | P007 | Borrador | 200 | 0 | 400 | | P008 | Regla | 1000 | 0 | 120 | | P009 | Carpeta | 3500 | 0 | 50 | | P010 | Calculadora | 25000 | 0 | 30 | +-------------+-------------+--------------+--------------+------------+ 10 rows in set (0.001 sec) MariaDB [papeleria]> INSERT INTO distribuidor VALUES ('D001', 'Distribuidora Central', '3112345678', 'Bogot '),('D002', 'Papeles del Norte', '3156789123', 'Medell¡n'),('D003', 'Suminsitros Andes', '3109876543', 'Cali'),('D004', 'Office Supplies', '3167890123', 'Barranquilla'),('D005', 'Distribuciones Siglo XXI', '3123456789', 'Cartagena'),('D006', 'Surtitodo', '3119876543', 'Pereira'),('D007', 'Distribuidora del Sur', '3104567891', 'Bucaramanga'),('D008', 'Insumos y Papeles', '3145678912', 'Manizales'),('D009', 'Papeler¡a Todo', '3198765432', 'C£cuta'),('D010', 'Suministros Express', '3176543210', 'Ibagu‚'); Query OK, 10 rows affected (0.018 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> select * from distribuidor; +-----------------+--------------------------+------------+--------------+ | id_distribuidor | Nombre | Telefono | Ciudad | +-----------------+--------------------------+------------+--------------+ | D001 | Distribuidora Central | 3112345678 | Bogot  | | D002 | Papeles del Norte | 3156789123 | Medell¡n | | D003 | Suminsitros Andes | 3109876543 | Cali | | D004 | Office Supplies | 3167890123 | Barranquilla | | D005 | Distribuciones Siglo XXI | 3123456789 | Cartagena | | D006 | Surtitodo | 3119876543 | Pereira | | D007 | Distribuidora del Sur | 3104567891 | Bucaramanga | | D008 | Insumos y Papeles | 3145678912 | Manizales | | D009 | Papeler¡a Todo | 3198765432 | C£cuta | | D010 | Suministros Express | 3176543210 | Ibagu‚ | +-----------------+--------------------------+------------+--------------+ 10 rows in set (0.001 sec) MariaDB [papeleria]> INSERT INTO consumidor VALUES ('C001', 'Luis G¢mez', '3214567890', 'Bogot '),('C002', 'Marta Rojas', '3229876543', 'Medell¡n'),('C003', 'Carlos D¡az', '3234567891', 'Cali'),('C004', 'Ana Ram¡rez', '3245678901', 'Barranquilla'),('C005', 'Pedro P‚rez', '3256789012', 'Cartagena'),('C006', 'Laura Ortega', '3267890123', 'Pereira'),('C007', 'Juan Torres', '3278901234', 'Bucaramanga'),('C008', 'Sof¡a Castillo', '3289012345', 'Manizales'),('C009', 'Andr‚s Herrera', '3290123456', 'C£cuta'),('C010', 'Mar¡a C rdenas', '3201234567', 'Ibagu‚'); Query OK, 10 rows affected (0.002 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> select * from consumidor; +---------------+----------------+------------+--------------+ | id_consumidor | Nombre | Telefono | Ciudad | +---------------+----------------+------------+--------------+ | C001 | Luis G¢mez | 3214567890 | Bogot  | | C002 | Marta Rojas | 3229876543 | Medell¡n | | C003 | Carlos D¡az | 3234567891 | Cali | | C004 | Ana Ram¡rez | 3245678901 | Barranquilla | | C005 | Pedro P‚rez | 3256789012 | Cartagena | | C006 | Laura Ortega | 3267890123 | Pereira | | C007 | Juan Torres | 3278901234 | Bucaramanga | | C008 | Sof¡a Castillo | 3289012345 | Manizales | | C009 | Andr‚s Herrera | 3290123456 | C£cuta | | C010 | Mar¡a C rdenas | 3201234567 | Ibagu‚ | +---------------+----------------+------------+--------------+ 10 rows in set (0.001 sec) MariaDB [papeleria]> INSERT INTO pedidos_distribuidores VALUES ('PD001', '2024-10-01', 'D001'),('PD002', '2024-10-02', 'D002'),('PD003', '2024-10-03', 'D003'),('PD004', '2024-10-04', 'D004'),('PD005', '2024-10-05', 'D005'); Query OK, 5 rows affected (0.010 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> select * from pedidos_distribuidores; +-----------------+------------+-----------------+ | id_pedidodistri | Fecha | FK_distribuidor | +-----------------+------------+-----------------+ | PD001 | 2024-10-01 | D001 | | PD002 | 2024-10-02 | D002 | | PD003 | 2024-10-03 | D003 | | PD004 | 2024-10-04 | D004 | | PD005 | 2024-10-05 | D005 | +-----------------+------------+-----------------+ 5 rows in set (0.001 sec) MariaDB [papeleria]> INSERT INTO detalles_pedido VALUES ('DP001', 'Cuaderno', 100, 1200, 'PD001', 'P001'),('DP002', 'L piz', 500, 300, 'PD002', 'P002'),('DP003', 'Bol¡grafo', 300, 500, 'PD003', 'P003'),('DP004', 'Marcador', 150, 700, 'PD004', 'P004'),('DP005', 'Tijeras', 80, 2500, 'PD005', 'P005'); Query OK, 5 rows affected (0.011 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> select * from detalles_pedido; +----------------+-----------+-----------------+---------------+-----------------+-------------+ | id_detallePedi | Nombre | cantidad_pedido | precio_compra | FK_pedidodistri | FK_producto | +----------------+-----------+-----------------+---------------+-----------------+-------------+ | DP001 | Cuaderno | 100 | 1200 | PD001 | P001 | | DP002 | L piz | 500 | 300 | PD002 | P002 | | DP003 | Bol¡grafo | 300 | 500 | PD003 | P003 | | DP004 | Marcador | 150 | 700 | PD004 | P004 | | DP005 | Tijeras | 80 | 2500 | PD005 | P005 | +----------------+-----------+-----------------+---------------+-----------------+-------------+ 5 rows in set (0.001 sec) MariaDB [papeleria]> INSERT INTO venta VALUES ('V001', '2024-10-01', 'C001'),('V002', '2024-10-02', 'C002'),('V003', '2024-10-03', 'C003'),('V004', '2024-10-04', 'C004'),('V005', '2024-10-05', 'C005'); Query OK, 5 rows affected (0.009 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> select * from venta; +----------+------------+---------------+ | id_venta | Fecha | FK_consumidor | +----------+------------+---------------+ | V001 | 2024-10-01 | C001 | | V002 | 2024-10-02 | C002 | | V003 | 2024-10-03 | C003 | | V004 | 2024-10-04 | C004 | | V005 | 2024-10-05 | C005 | +----------+------------+---------------+ 5 rows in set (0.000 sec) MariaDB [papeleria]> INSERT INTO detalles_venta VALUES ('DV001', 2, 'V001', 'P001'),('DV002', 5, 'V002', 'P002'),('DV003', 3, 'V003', 'P003'),('DV004', 1, 'V004', 'P004'),('DV005', 4, 'V005', 'P005'); Query OK, 5 rows affected (0.012 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> select * from detalles_venta; +-----------------+------------------+----------+-------------+ | id_detalleventa | Cantidad_vendida | FK_venta | FK_producto | +-----------------+------------------+----------+-------------+ | DV001 | 2 | V001 | P001 | | DV002 | 5 | V002 | P002 | | DV003 | 3 | V003 | P003 | | DV004 | 1 | V004 | P004 | | DV005 | 4 | V005 | P005 | +-----------------+------------------+----------+-------------+ 5 rows in set (0.001 sec) MariaDB [papeleria]> exit