I need Help please

User Generated

znyuhznvqv

Programming

Description

Take the data below and create a Model with functional dependencies.

  1. In a text/word file, write out the “Model” of your tables in the following format:
    TABLE_NAME(Key, otherElements, etc.) (if there is a foreign key, italicize it)
    1. You might want to add extra fields to make your database make more sense.
  2. Create a MySQL Model using MySQL Workbench of your tables & be sure to include the relationships and enter the data below.
    1. Please Call your Database LastNameFirstNameAssignment2
    2. Each table created should have a Primary Key, and data types for each element.
  3. Submit text/word document and database creation script (SQL)

Unformatted Attachment Preview

Antique Store BuyerLastName Buyer FirstName BuyerPhone Shire Robert 205-555-5523 Shire Robert 205-555-5523 Shire Robert 205-555-5523 Bancroft Chris 201-555-5512 Bancroft Chris 201-555-5512 Shire Robert 265-555-5523 Smith Robert 204-123-1234 Smith Robert 204-123-1235 Smith Robert 204-123-1236 Goodyear Katherine 123-555-1234 Shire Robert 205-555-5523 Goodyear Katherine 123-555-1234 Goodyear Katherine 123-555-1234 Goodyear Katherine 123-555-1234 InvoiceDate Invoiceltem Price Item Vendor VendorPhone 7/14/2013 Antique Desk $3,000.00 Chairs, Chairs, Chairs 555-123-1212 7/14/2013 Antique Desk Chair $1,200.00 Chairs, Chairs, Chairs 555-123-1212 7/14/2013 Antique Lamp $800.00 I Love Lamps 555-122-1221 7/14/2013 Candles $45.00 I Heart Candles 555-555-2222 7/14/2013 Book Shelf $250.00 PutUrBooksHere.com 888-333-1212 7/16/2013 Dining Room Table $2,500.00 Tables And More 800-111-5555 8/12/2013 Book Shelf $200.00 PutUrBooksHere.com 888-333-1212 8/12/2013 Dining Room Chairs $1,000.00 Chairs, Chairs, Chairs 555-123-1212 8/24/2013 Dining Room Chairs $1,000.00 Chairs, Chairs, Chairs 555-123-1212 8/25/2013 Antique Couch $4,500.00 Couches A Plenty 555-421-5555 9/1/2013 Coffee Table $500.00 PutUrBooksHere.com 888-333-1212 9/2/2013 Antique Chest $1,250.00 Chest-R-US 800-555-1712 9/2/2013 Generic Chair $75.00 Chairs, Chairs, Chairs 555-123-1212 9/2/2013 Antique Chair $125.00 Chairs, Chairs, Chairs 555-123-1712
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Convert fullscripts.txt to fullscript.sql by copying it to your mysql working since the website does not support .sql files uploads . there is also .mwb file which i did not find possible way to upload please contact support on how we will solve this as i also do so

STORES
PRIMARY KEY

StoreID
StoreName

STORE A
PRIMARY KEY InvoiceID
StoreID
BuyerLastName
BuyerFirstName
BuyerPhone
VendorPhone
InvoiceDate
InvoiceItem
Price
ItemVendor
STORE A
PRIMARY KEY InvoiceID
StoreID
BuyerLastName
BuyerFirstName
BuyerPhone
VendorPhone
InvoiceDate
InvoiceItem
Price
ItemVendor
STORE A
PRIMARY KEY InvoiceID
StoreID
BuyerLastName
BuyerFirstName
BuyerPhone
VendorPhone
InvoiceDate
InvoiceItem
Price
ItemVendor

Attached.

-- 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 LastNameFirstNameAssignment2
-- ------------------------------------------------------ ------------------------------------------------------ Schema LastNameFirstNameAssignment2
-- ----------------------------------------------------CREATE SCHEMA IF NOT EXISTS `LastNameFirstNameAssignment2` DEFAULT CHARACTER SET
utf8 COLLATE utf8_general_ci ;
USE `LastNameFirstNameAssignment2` ;
-- ------------------------------------------------------ Table `LastNameFirstNameAssignment2`.`STORES`
-- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `LastNameFirstNameAssignment2`.`STORES` (
`StoreID` INT NOT NULL COMMENT '',
`StoreName` VARCHAR(45) NOT NULL COMMENT '',
PRIMARY KEY (`StoreID`) COMMENT '',
UNIQUE INDEX `StoreName_UNIQUE` (`StoreName` ASC) COMMENT '')
ENGINE = InnoDB;
-- ------------------------------------------------------ Table `LastNameFirstNameAssignment2`.`ILoveLamps`
-- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `LastNameFirstNameAssignment2`.`ILoveLamps` (
`InvoiceID` INT NOT NULL AUTO_INCREMENT COMMENT '',
`BuyerFirstName` VARCHAR(45) NOT NULL COMMENT '',
`BuyerLastName` VARCHAR(45) NOT NULL COMMENT '',
`BuyerPhone` VARCHAR(45) NOT NULL COMMENT '',
`VendorPhone` VARCHAR(45) NOT NULL COMMENT '',
`InvoiceDate` DATE NOT NULL COMMENT '',
`InvoiceItem` VARCHAR(45) NOT NULL COMMENT '',
`Price` INT NOT NULL COMMENT '',
`STORES_StoreID` INT NOT NULL DEFAULT 002 COMMENT '',
PRIMARY KEY (`InvoiceID`) COMMENT '',
INDEX `fk_ILoveLam...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags