(Solved) : Hurrry Answer Question Introduction Need Create Operational Database Organization Need App Q29545591 . . . .

hurrry up answer this question

INTRODUCTION

You will need to create an operational database for anorganization. You will need to apply technical skills and using anappropriate tool to create the database based on the scenariobelow.

Scenario

Morgan Importing Ltd. has hired you as a database consultant todevelop an operational database having the following fourtables.

TASK 1 (LO 3)

The database contains several tables. The description of thebusiness is as follows:

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

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

SHIPMENT (ShipmentID, ShipperID, ShipperInvoiceNumber, Origin,Destination, DepartureDate, Arrival Date)

SHIPMENT_ITEM (ShipmentID, ShipmentItemID, PurchaseItemID,InsuredValue)

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

Assume that the organization’s personnel are the owner (Marcia),an