Answered You can hire a professional tutor to get the answer.

QUESTION

I keep getting this error message in the MySQL Workbench. Can somebody please take a look at the code and assist?

I keep getting this error message in the MySQL Workbench. Can somebody please take a look at the code and assist?

Error:

PRIMARY KEY (`CustomerID`, `ItemID`, `OrderDate`, `Orders_CustomerID`, `Orders_Customers_CustomerID`, `Items_ItemID`),

     INDEX `(ItemID) REFERENCES Items(ItemID),_idx` (`ItemID` ASC),

     CONSTRAINT `(CustomerID) REFERENCES Customers(CustomerID),`

      FOREIGN KEY (`CustomerID`)

      REFERENCES `CTWeek5`.`Customers` (`CustomerID`)

      ON DELETE NO ACTION

      ON UPDATE NO ACTION,

     CONSTRAINT `(ItemID) REFERENCES Items(ItemID),`

      FOREIGN KEY (`ItemID`)

      REFERENCES `CTWeek5`.`Items` (`ItemID`)

      ON DELETE NO ACTION

      ON UPDATE NO ACTION,

     CONSTRAINT `(OrderDate) REFERENCES Orders(OrderDate)`

      FOREIGN KEY ()

      REFERENCES `CTWeek5`.`Orders` ()

      ON DELETE NO ACTION

      ON UPDATE NO ACTION)

    ENGINE = InnoDB

SQL script execution finished: statements: 8 succeeded, 1 failed

Fetching back view definitions in final form.

Nothing to fetch

BELOW IS MY SCRIPT

-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------

-- Schema CTWeek5

-- -----------------------------------------------------

-- -----------------------------------------------------

-- Schema CTWeek5

-- -----------------------------------------------------

CREATE SCHEMA IF NOT EXISTS `CTWeek5` DEFAULT CHARACTER SET utf8 ;

USE `CTWeek5` ;

-- -----------------------------------------------------

-- Table `CTWeek5`.`Customers`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `CTWeek5`.`Customers` (

 `CustomerID` VARCHAR(10) NOT NULL,

 `CustomerName` VARCHAR(50) NOT NULL,

 `CustomerAddress` VARCHAR(100) NOT NULL,

 PRIMARY KEY (`CustomerID`))

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `CTWeek5`.`Items`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `CTWeek5`.`Items` (

 `ItemID` VARCHAR(10) NOT NULL,

 `ItemDescription` VARCHAR(50) NOT NULL,

 `ItemUnitCost` DECIMAL(10,2) NOT NULL,

 PRIMARY KEY (`ItemID`))

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `CTWeek5`.`Orders`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `CTWeek5`.`Orders` (

 `CustomerID` VARCHAR(10) NOT NULL,

 `OrderDate` DATE NOT NULL,

 `ShipDate` DATE NOT NULL,

 `TotalOrderAmount` DECIMAL(10,2) NOT NULL,

 `Customers_CustomerID` VARCHAR(10) NOT NULL,

 PRIMARY KEY (`CustomerID`, `Customers_CustomerID`),

 INDEX `fk_Orders_Customers_idx` (`Customers_CustomerID` ASC),

 CONSTRAINT `fk_Orders_Customers`

  FOREIGN KEY (`Customers_CustomerID`)

  REFERENCES `CTWeek5`.`Customers` (`CustomerID`)

  ON DELETE NO ACTION

  ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `CTWeek5`.`Order_Item`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `CTWeek5`.`Order_Item` (

 `CustomerID` VARCHAR(10) NOT NULL,

 `ItemID` VARCHAR(10) NOT NULL,

 `OrderDate` DATE NOT NULL,

 `Quantity` DECIMAL(5,0) NOT NULL,

 `ItemTotal` DECIMAL(10,2) NOT NULL,

 `Orders_CustomerID` VARCHAR(10) NOT NULL,

 `Orders_Customers_CustomerID` VARCHAR(10) NOT NULL,

 `Items_ItemID` VARCHAR(10) NOT NULL,

 PRIMARY KEY (`CustomerID`, `ItemID`, `OrderDate`, `Orders_CustomerID`, `Orders_Customers_CustomerID`, `Items_ItemID`),

 INDEX `(ItemID) REFERENCES Items(ItemID),_idx` (`ItemID` ASC),

 CONSTRAINT `(CustomerID) REFERENCES Customers(CustomerID),`

  FOREIGN KEY (`CustomerID`)

  REFERENCES `CTWeek5`.`Customers` (`CustomerID`)

  ON DELETE NO ACTION

  ON UPDATE NO ACTION,

 CONSTRAINT `(ItemID) REFERENCES Items(ItemID),`

  FOREIGN KEY (`ItemID`)

  REFERENCES `CTWeek5`.`Items` (`ItemID`)

  ON DELETE NO ACTION

  ON UPDATE NO ACTION,

 CONSTRAINT `(OrderDate) REFERENCES Orders(OrderDate)`

  FOREIGN KEY ()

  REFERENCES `CTWeek5`.`Orders` ()

  ON DELETE NO ACTION

  ON UPDATE NO ACTION)

ENGINE = InnoDB;

SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question