• Design a Relational Data Model for the following ER model of a manufacturer/customer database: city street partNo description address M_name 1 N Manufacturer Makes Part N quantity contains ID C_name N OrderNo N 1 orders Customer Order Comments on the ER-diagram: The Manufacturer entity represent the manufacturers The Part entity represent the parts The Order entity represent the orders made The Customer entity represent the customers The key in each entity is underlined with a solid line. The Makes relationship represents the "who-make-which-part" relationship The contains relationship represents the parts in the orders The orders relationship represents the "which-customer-made-which-order" relationship Your relational model answer must satisfy the following requirements: ■ Use the smallest possible number of relations ■ Attributes in relations must not have NULL values. Exception: If avoiding NULL values will require creating a new relation, the attribute is allowed to have NULLS. Underline the primary key of each relation For every foreign key in the relational model: ■ Draw an arrow from the foreign key to the relation that the foreign key is "pointing to" (i.e., it's "home relation").