Vendors (1) sell (N) Products Products (1) belong to (1) Vendor Products (N) are associated with (N) Categories Categories (1) have (N) Products Categories (N) are children of (N) Categories Categories (N) are parents of (N) Categories Deliveries (1) are scheduled by (1) Vendor Deliveries (1) contain (N) Products Products (N) are shipped under (N) Deliveries

draw erd diagram Design

Based on the ERD, the following tables and relationships can be created: Vendors table: vendor_id (PK) vendor_name Products table: product_id (PK) vendor_id (FK) product_name Categories table: category_id (PK) parent_category_id (FK) category_name Product_Categories table: product_id (PK, FK) category_id (PK, FK) Deliveries table: delivery_id (PK) vendor_id (FK) delivery_date Delivery_Products table Draw the relational schema Design