Problem: The Wholesale Database introduced in Project 1 is a simplified version of a database that serves to keep track of the products manufactured by different brands and the selling price comparison between each product supplied by different vendors. Consider the following set of requirements along with the tables provided in Project 1 (a) Each vendor is described by the ID, name, category, address, email, and phone number (b) Each brand is described by the ID, name, license, contact phone, contact email and contract year (c) Each product is described by the ID, name, category, and production_cost (d) One product must belong to one brand. One brand may or may not provide more than one product. (e) Each vendor may supply zero or multiple product(s). A product may be supplied by zero or multiple vendor(s). Design an ER schema for this application, and draw an ER diagram for that schema Specify key attributes of each entity type and structural constraints on each relationship type using (min, max) notation. Note any unspecified requirements, and make appropriate assumptions to make the specification complete. You only need to draw an ER diagram to show your design