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`);

Base de Datos Realacional de AGUA DE SABOR.JPG