1. expand and enhance the database design (snap 2nd) to include supertype and subtype entities.

2. you have to decide if the specialization hierarchy is disjoint or overlapping and if the constraints are partial or complete.make sure u apply this to no less than 2 entites.if in my old erd (snap 2) i did not provide any entites that could be extanded then make sure you added to database design entities that could be categorized.

3 Improve the database design by make sure tables are normalized.

4 create at least 1 recursive relationship

5 if u guyes see any mistake in my old erd please correct it and make a summery of what you did in assignment.

(please do it as soon as posible i have time till tommorow afternoon 2 PM)

cheak snap 1 there are all the instructions

i reupload the snaps

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. 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. Suppliers supplied suppliers supplier address Supplier phone suscles Product products product rame product price product description Orders orderd Customer Customer Address Order Customers customer_id Customer name Chstomer hone customer Address Brand broertem trand DO wand product Business Rules: 1 Every supplier can supplies many products. 2 every product suppies by one supplier 3 every brand can has many products 4 every product can be has many brands Severy order has many products 6 every product can has many orders 7. every customer can has many orders Assignment 2 In the last assignment (1.2) you were asked to propose a database for a business. For this assignment you need to work on the SAME database and make improvements to it to Make sure you do the following: 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. 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. Product Customers supplies Suppliers Supplier_id suppliers_namne supplier address Supplier phone product id product name product price product description order Orders order id Customer_id Customer Address customer_id customer name astomer phone customer Address Brand brand ld product_id order_item order_id brand a products Business Rules: 1 Every supplier can supplies many products, 2 every product suppies by one supplier. 3 every brand can has many products 4 every product can be has many brands Severy order has many products 6 every product can has many orders 7. every customer can has many orders