Construct a database of the following ER diagram by creating each of the relations using Oracle SQL.The Relational Database table has also been provided:

Vendors (Vendor#, Name, Address, Telephone#, Vendor_Type)

Parts (Part#, Description, Part_cost, Part_type)

Purchase_order (Order#, Quantity_Ordered, Date_requested, Date_shipped)

Assembled_parts (Part#, Vendor#)

Sub_parts (Part#, Vendor#, Assembled_parts#)

Part Name Assembled parts Address Part Vendors Telephone# Vendor Sub parts Vendor Type Part Date requested Parts Purchase order Quantity Ordered Date_shipped Description Part type Part cost ordet ltem_ordered