SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 02 Jan 2018 My Price 10.00

database environment in MySQL to test your results.

the questions is on the PDF. and use the attached SQL file to create your database environment in MySQL to test your results.

  • create database if not exists Warehouse;
    use Warehouse;

    CREATE TABLE Customer(
    CustomerID        VARCHAR(5)not null,
    CName            VARCHAR(25),
    CCity            VARCHAR(25),
    CONSTRAINT Customer_PK PRIMARY KEY (CustomerID)
    ) engine = innodb;
     
    CREATE TABLE Item(
    ItemID            VARCHAR(6) not null,
    Description        VARCHAR(25),
    Price            Double(7,2),
    CONSTRAINT Item_PK PRIMARY KEY (ItemID)
    ) engine = innodb;

    CREATE TABLE OrderTable (
    OrderID            VARCHAR(5)not null,
    OrderDate        DATE,
    CustomerID        VARCHAR(5)not null,
    CONSTRAINT OrderTable_PK PRIMARY KEY (OrderID),
    CONSTRAINT OrderTable_FK2 FOREIGN KEY (CustomerID) REFERENCES Customer (CustomerID)
    ) engine = innodb;

    CREATE TABLE Order_Item (
    OrderID            VARCHAR(5)not null,
    ItemID            VARCHAR(6) not null,
    QTY                SMALLINT,
    CONSTRAINT Order_Item_PK PRIMARY KEY (OrderID,ItemID),
    CONSTRAINT Order_Item_FK1 FOREIGN KEY (OrderID) REFERENCES OrderTable (OrderID),
    CONSTRAINT Order_Item_FK2 FOREIGN KEY (ItemID) REFERENCES Item (ItemID)
    ) engine = innodb;

    CREATE TABLE Warehouse(
    WarehouseID        VARCHAR(3)not null,
    WCity            VARCHAR(25),
    CONSTRAINT Warehouse_PK PRIMARY KEY (WarehouseID)
    ) engine = innodb;

    CREATE TABLE Shipment (
    OrderID            VARCHAR(5)not null,
    WarehouseID        VARCHAR(3)not null,
    ShipDate        DATE,
    CONSTRAINT Shipment_PK PRIMARY KEY (OrderID,WarehouseID),
    CONSTRAINT Shipment_FK1 FOREIGN KEY (OrderID) REFERENCES OrderTable (OrderID),
    CONSTRAINT Shipment_FK2 FOREIGN KEY (WarehouseID) REFERENCES Warehouse (WarehouseID)
    ) engine = innodb;

    insert into Customer (CustomerID, CName, CCity) values ('77777','ABC Inc', 'Philadelphia');
    insert into Customer (CustomerID, CName, CCity) values ('78954','North Woods Health', 'Newark');
    insert into Customer (CustomerID, CName, CCity) values ('74321','Good Sport', 'Baltimore');
    insert into Customer (CustomerID, CName, CCity) values ('85476','The All American', 'New York');
    insert into Customer (CustomerID, CName, CCity) values ('95324','Bobs', 'New York');

    insert into Item (ItemID, Description, Price) values ('100870','Bench Press', 1000);
    insert into Item (ItemID, Description, Price) values ('100475','Tred Mill', 3000);
    insert into Item (ItemID, Description, Price) values ('105472','Weights', 500);
    insert into Item (ItemID, Description, Price) values ('103798','Bike', 895);
    insert into Item (ItemID, Description, Price) values ('104375','Stair Master', 5000);

    insert into OrderTable (OrderID, OrderDate, CustomerID) values ('10000', '2002-12-12', '95324');
    insert into OrderTable (OrderID, OrderDate, CustomerID) values ('10001', '2003-06-05', '95324');
    insert into OrderTable (OrderID, OrderDate, CustomerID) values ('10002', '2002-12-12', '85476');
    insert into OrderTable (OrderID, OrderDate, CustomerID) values ('10003', '2003-10-10', '78954');
    insert into OrderTable (OrderID, OrderDate, CustomerID) values ('10004', '2003-07-07', '74321');
    insert into OrderTable (OrderID, OrderDate, CustomerID) values ('10005', '2003-10-10', '85476');
    insert into OrderTable (OrderID, OrderDate, CustomerID) values ('10006', '2004-01-15', '74321');
    insert into OrderTable (OrderID, OrderDate, CustomerID) values ('10007', '2004-02-10', '85476');

    insert into Order_Item (OrderID ,ItemID, QTY) values ('10000','105472', 1);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10001','105472', 4);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10002','104375', 1);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10003','100870', 2);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10003','103798', 1);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10004','103798', 1);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10004','105472', 2);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10005','100475', 1);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10006','100870', 1);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10006','105472', 1);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10006','103798', 1);
    insert into Order_Item (OrderID ,ItemID, QTY) values ('10007','105472', 2);

    insert into Warehouse (WarehouseID, WCity) values ('102','New York');
    insert into Warehouse (WarehouseID, WCity) values ('105','New York');
    insert into Warehouse (WarehouseID, WCity) values ('107','Boston');
    insert into Warehouse (WarehouseID, WCity) values ('115','Baltimore');
    insert into Warehouse (WarehouseID, WCity) values ('155','Philadelphia');

    insert into Shipment (OrderID, WarehouseID, ShipDate) values ('10000','105', '2003-01-16');
    insert into Shipment (OrderID, WarehouseID, ShipDate) values ('10001','115', '2003-06-20');
    insert into Shipment (OrderID, WarehouseID, ShipDate) values ('10002','155', '2003-06-10');
    insert into Shipment (OrderID, WarehouseID, ShipDate) values ('10003','102', '2003-10-27');
    insert into Shipment (OrderID, WarehouseID, ShipDate) values ('10004','107', '2003-07-22');
    insert into Shipment (OrderID, WarehouseID, ShipDate) values ('10005','115', '2003-10-24');
    insert into Shipment (OrderID, WarehouseID, ShipDate) values ('10006','107', '2003-02-04');
    insert into Shipment (OrderID, WarehouseID) values ('10007','115');


Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 02 Jan 2018 01:01 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)