Agua De Sabor
CREATE DATABASE `AGUA DE SABOR`;
CREATE TABLE `AGUA DE SABOR`. `SABOR` (
`ID_SABOR` INT (10) NOT NULL AUTO_INCREMET,
`NOMBRE` VARCHAR (50) NOT NULL,
PRIMARY KEY (`ID_SABOR`),
FOREIGN KEY (ID_SABOR) REFERENCES SABOR (ID_SABOR))
ENGINE=INNODB;
CREETE TABLE `AGUA DE SABOR`. ` COSTO`(
`ID_COSTO` INT (10) NOT NULL AUTO_INCREMET,
`CANTI_COSTO` INT (10) NOT NULL,
`ID_SABOR` INT (10) NOT NULL,
FOREIGN KEY (ID_COSTO) REFERENCES COSTO (ID_COSTO))
ENGINE=INNODB;
INSERT INTO `AGUA DE SABOR`. `SABOR`(
`ID_SABOR`,
`NOMBRE`)
VALUES (
(NULL,`FRESA`),
(NULL, `ARROZ`),
(NULL, `UVA`),
(NULL, `AVENA`),
(NULL, `SANDIA`);
INSERT INTO `AGUA DE SABOR` .`COSTO` (
`ID_COSTO`,
`CANTI_COSTO`)
VALUES (
NULL, `15`,`1`),
NULL, `10`,`2`),
NULL, `20`,`3`),
NULL, `25`,`4`),
NULL, `12`,`5`);