can u guys do this assignment for me(my old erd in the first snap and the 2 nd snap is what i need)

1. please putt Primery key and foregin key in entities and expand and enhance the old erd diagram and putt supertype and subtype entities. you have to choice to decide if the specialization hierarchy is disjoining of overlapping and if the constraints are partial or complete. Make sure you should apply this to no less than 2 entities.

2. improve the database design by make sure the tables are normalized.

3 create at least 1 rescursive relationship

if u guys see any mistake correct it

In this modern era, Shoping from supermarket is a super market practice, everyone always looking for the place where he or she can get all the products that they need on one place, these places are called supermarkets, here I am designing a database for a supermarket, which provides information about the suppliers, brand, products, customers, orders, order item. Orders Order Suppliers weer per me support Supplier phone Product prod production rice dapton der Customer Customer Address Customers customer customer and stomer phone Customer Address Brand order_item ered brand OL Business Rules: 1 Every supplier can supplies many products. 2 every product series by one supplier. 3 every brand can has many products 4 every product can be has many brands 5 every order has many products 6 every product can has many orders 7. every customer can has many orders 1. Expand and enhance your database design to include Supertype and Subtype entities (refer to the lesson on Feb 20). You have the choice to decide if the Specialization Hierarchy is Disjoint or Overlapping and if the constraints are Partial or Complete. Make sure you apply this to no less than 2 Entities. It in your previous assignment you did not provide any entities that could be Extended then make sure you add to your Database design entities that could be categorized I 2. Improve your database design by make sure your tables are Normalized. (refer to the lesson on Feb 27). To solve this go through the check list provided with this assignment and make sure you have done all the recommendation given to you. Note: This Check list is recommended for your use anytime you design a database 3. Create at least 1 recursive relationship, 1- Expand and enhance your database design to include Supertype and Subtype entities (refer to the lesson on Feb 20). You have the choice to decide if the Specialization Hierarchy is Disjoint or Overlapping and if the constraints are Partial or Complete. Make sure you apply this to no less than 2 Entities. If in your previous assignment you did not provide any entities that could be Extended then make sure you add to your Database design entities that could be categorized 2- Improve your database design by make sure your tables are Normalized. (refer to the lesson on Feb 27). To solve this go through the check list provided with this assignment and make sure you have done all the recommendation given to you. Note: This Check list is recommended for your use anytime you design a database 3- Create at least 1 recursive relationship