Create the above entities in Oracle SQL Plus using DDL syntax. Make sure you include all appropriate constraints, referential integrity, PK, FK etc. Also plug in the data below.

Question: How do you solve this and  How do you insert the data into SQL Plus on macbook?

  

cgmerchant PK Store ID State Zip Code city Store Type has cgManufacturer PK Manufacturer ID UC dc State Zip Code City Manuf Type FK1 Store ID H- 9898 7755 3739 6329 clothes shoes Rx TVs IBA cgManufacturer MANUFACTURER_ID MANUF_TYPE clothes shoes Rx TVS cgShipment SHIP_DATE TRUCK_NO 17-May-2009 4422 20-Jul-2009 2222 21-Jul-2009 9922 23-Jul-2009 7722 Shipment Ship Dats Truck No PK,FK1 Manufacturer ID PK PK DDL Exercise: Create the above entities in Oracle SQL Plus using DDL syntax. Make sure you include all appropriate constraints, referential integrity, PK, FK etc. Also plug in the data below. cgMerchant STORE_ID STORE_TYPE CITY Owings Mills Reistersown Harrisonburg Harrisonburg ZIP CODE 7755 9898 3739 6329 CITY 21117 21136 MD MD 22801 VA 22807 VA MANUFACTURER_ID Glen Burnie Los Angeles Detroit Miami STATE ZIP CODE cgProducts PK Product ID 21156 90088 45443 30588 FK1 Store 0 Product Name Product Price Product Cost contain cgDescription PKFK1 Product ID PK FK2 Shipment Date PK,FK2 Track N PK FK2 ManufactMERE IR MD Quantity Condition STATE STORE_ID 1 CA MI 3 FL 4 2