MySQL database

Hi everyone, i am currently working on a personal project that i need help with using MySQL and knowledge of databases. I have provided below all the instructions in attatchments.

Project Overview:

James Morgan owns and operates Morgan Importing, which purchases antiques and home furnishings in Asia, ships those items to a warehouse facility in Los Angeles, and then sells these items in the United States. James has hired you to design a database that tracks the Asian purchases and subsequent shipments of these items to Los Angeles and keeps a list of items purchased, shipments of the purchased items, and the items in each shipment. You have chosen to include the following tables:

EMPLOYEE (EmployeeID, LastName, FirstName, Department, Position, Supervisor, OfficePhone, OfficeFax, EmailAddress)

STORE (StoreID, StoreName, City, Country, Phone, Fax, EmailAddress, Contact)

PURCHASE_ITEM (PurchaseItemID, StoreID, PurchasingAgentID, PurchaseDate, ItemDescription, Category, PriceUSD)

SHIPPER (ShipperID, ShipperName, Phone, Fax, EmailAddress, Contact)

SHIPMENT (ShipmentID, ShipperID, PurchasingAgentID, ShipperInvoiceNumber, Origin, Destination, ScheduledDepartureDate, ActualDepartureDate, EstimatedArrivalDate)

SHIPMENT_ITEM (ShipmentID, ShipmentItemID, PurchaseItemID, InsuredValue)

SHIPMENT_RECEIPT (ReceiptNumber, ShipmentID, PurchaeItemID, ReceivingAgentID, ReceiptDate, ReceiptTime, ReceiptQuantity, isReceivedUndamaged, DamageNotes)

The referential integrity constraints are:

Supervisor in EMPLOYEE must exist in EmployeeID in EMPLOYEE

StoreName in PURCHASE_ITEM must exist in StoreName in STORE

PurchasingAgentID in PURCHASE_ITEM must exist in EmployeeID in EMPLOYEE

ShipperID in SHIPMENT must exist in ShipperID in SHIPPER

PurchasingAgentID in SHIPMENT must exist in EmployeeID in EMPLOYEE

PurchaseItemID in SHIPMENT_ITEM must exist in PurchaseItemID in PURCHASE_ITEM

ShipmentID in SHIPMENT_RECEIPT must exist in ShipmentID in SHIPMENT

PurchaseItemID in SHIPMENT_RECEIPT must exist in PurchaseItemID in PURCHASE_ITEM

ReceivingAgentID in SHIPMENT_RECEIPT must exist in EmployeeID in EMPLOYEE

Furthermore, you have decided that EmployeeID of EMPLOYEE, PurchaseItemID of PURCHASE_ITEM, ShipperID of SHIPPER, ShipmentID of SHIPMENT, and ReceiptNumber of SHIPMENT_RECEIPT are all surrogate keys.

The values of the Country column in the STORE table are restricted to: Hong Kong, India, Japan,Peru, Philippines, Singapore, and United States.

Evner: MySQL, Database Administration

Se mere: project mysql database access using odbc, xml mysql database project sample, implement mysql database online bookstore project, mysql database design project visual studio 2008, prepare project proposal mysql database client, free project php mysql database search, create setup project mysql database, visual basic project mysql database, need someone fix mysql database, vbnet project adding images mysql database, need chinese project need help, convert project access mysql database, connect mysql database vb6 project, mysql database project using jms java code, mysql database fill blank project, flex working mysql database, football pool mysql database project, need help database project php mysql, need simple java project mysql database, need help writing a book i have dyspriea

Om arbejdsgiveren:
( 1 bedømmelse ) North Bergen, United States

Projekt ID: #30197485

Tildelt til:


Hope you stay safe. Now I understand your requirement and would like to work on your project. I am a senior developer and Database Administrator with 5+ years of history working with MYSQL. I will offer fast delivery a Flere

$30 USD på 1 dag
(0 bedømmelser)

3 freelancere byder i gennemsnit $23 timen for dette job


Hi, I am interesting in your job. Till now I have completed a few of projects like yours. So I am very pretty know what I should do for you on this project. I can share my idea more detail via chatting. Please send me Flere

$20 USD in 7 dage
(4 bedømmelser)

Hi, Greetings for the day!! I have gone through your requirement and understood every aspect of them and Attachments. I Have Experience in MySQL, Database Administration. I will do all miscellaneous work for You.. Flere

$20 USD in 7 dage
(1 bedømmelse)