physical model

Shop_list has Shop_no numeric(10) FK_SHOP_LIS_REFERENCE_CUSTOMER shop_address char shop_owner char has FK_SHOP_LIS_REFERENCE_PRODUCT Customer Product Shop_no int Available to Product_id int FK_PRODUCT_REFERENCE_CUSTOMER Customer_name char Product_name char Product_id int Product_quantity int Item char product_desc char quantity int Address char has Attached By has FK_ATTACHED_REFERENCE_CUSTOMER FK_ATTACHED_REFERENCE_PRODUCT Customer_id int Product_id int place Contains FK_CUSTOMER_REFERENCE_ORDERS FK_ORDERS_REFERENCE_PRODUCT Orders Order_id int Order_date datetime order_status char 1/1