Mapping EER to Relational Schema Diagram Consider the following EER diagram for a car dealer Part no Description Manufacture_date PART Batch no Supplier_name Drawing.no List_price MANUFACTURED PART PURCHASED PART Map the above EER schema into a set of relations. For the PART to MANUFACTURED_PART/PURCHASED_PART generalization, consider the four options presented in Step8 and show the relational schema design under each of those options. Option A: Multiple relations - Superclass and subclasses (5 points) Option B: Multiple relations - Subclasses relations only (5 points) Option C: Single relation with one type attribute (5 points) Option D: Single relation with multiple type attribute (5 points) Mapping EER to Relational Schema Diagram Consider the following EER diagram for a car dealer Part no Description Manufacture_date PART Batch no Supplier_name Drawing.no List_price MANUFACTURED PART PURCHASED PART Map the above EER schema into a set of relations. For the PART to MANUFACTURED_PART/PURCHASED_PART generalization, consider the four options presented in Step8 and show the relational schema design under each of those options. Option A: Multiple relations - Superclass and subclasses (5 points) Option B: Multiple relations - Subclasses relations only (5 points) Option C: Single relation with one type attribute (5 points) Option D: Single relation with multiple type attribute (5 points)