I need the crow's foot ERD diagram for the question 1 and real world examples for the 2 question.

Design a database for a shipping firm based on this Shipment Manifest (3NF and ERD) SHIPMENT MANIFEST Shipment id: 00401 Shipment Date May 7, 2012 Origin: Boston, USA Expected Arrival May 19, 2012 Destination: Rio, Brazil Captain ID 002-15 Ship No: 3993 Captain Name H Moore Ship Name: Master of Seas Ship Registration: Panama Item number Type Description Weight/unit Quantity Total weight 3223 BM Concrete form 500 Lbs 100 50,000 3297 BM Steel beam 87 Lbs 2.000 174.000 1634 LM Crude Oil 200 Barrels 100 20,000 Shipment total: 244,000 Rules: Each Shipment Manifest document refers to an ad hoc shipment trip made by one of the ships of a large shipping company, Marine West. Out of its several Captains, anyone may be assigned for the trip; thus captains may go with different ships on different shipment trips. A captain may work on different ships, and a ship may have different captains over time. Each shipment trip has its own route and list of goods carried on it. Similarly, a ship also gets assigned to different shipment trips over time. Each shipment trip represents a specific voyage or trip and carries several goods. The above document captures data for a specific shipment or shipment trip. You also need to include the full port address: street, city, state, postalcode, and country in your database. BM and LM are types of materials and refer to bulk material and liquid material type, respectively. Question 2 20 pts Q2. Explain the specified two terms in detail with at least one real world example (i.e., illustration: include entity names, attributes, relationship descriptions) for each (10 Pts): A. PARTIAL DEPENDENCY B. SUBTYPE