Return From Customers ERDVer03 Shoe store Management System

Return From Customers ERD_Ver_03 Shoe store Management System Entity Relationships Diagram D Receipt Number(Pf. K) D Orders From Suppliers Order Code (PK) Customer's Purchases Make D Receipt's Number(PK) Supplied from B Products Customers Products_ Code (PK) Company Produces(PK) B Make Customer ID (PK) Includes Supplier Name (PK) Ask for Make D Repairs Send to Contain Customer’s Orders Legend Repair Code (PK) Entity B D D PK Order Code (PK) Relation Make BB Suppliers Provide Employees B Employee ID (PK) Have a Shifts Shift Name (PK) D Entity Basic Entity Dependant Entity Primary Key Relation 1: 1 1: N N: M Self Relationship Mandatory Optional

DSD_Ver_01 Customer's_Purchases_Tbl Shoe store Management System Data Structured Diagram Customers_Returns_Tbl D Receipt_Number_Fld_(pfk) Rerturn_Amount_Of_Product_Fld Product _Code_Fld(fk) Product_Produce_Comp_Fld(fk) Customer _Id _Fld(fk) Date_Of_Return_Fld Customer_Tbl B Customer Id Fld (pk) Customer_First_Name_Fld Customer_Last_Name_Fld Customer_Phone_Fld Customer_Email_Fld D Item_Sold. By_Store_Tbl Product _Code_Fld(pfk) Product_Produce_Comp_Fld(pfk) Nomber_Receipt_(pfk) Item_Amount_Fld Date_Fld Nomber_Receipt_(pk) Purchase_Date_Fld Purchase_Item_Amount_Fld Customer_Id_Fld(fk) Product_Code Fld(fk) Product_Produce_Comp_ Fld(fk) B Products_Tbl Line_In_Customers_Orders_Tbl Order_Code_Fld_(pfk) Product _Code_Fld(pfk) Product_Produce_Comp_Fld (pfk) Date_Fld Remarks_Fld A Product Code Fld (pk) Product_Produce_Comp_ Fld (pk) Product_Price_Fld Product_Color_Fld Product_Size_Fld Supplier_Name _Fld(fk) Product_Units_In_Stock_Fld Shifts_Tbl Customers_Orders_Tbl D Employees_Tbl Order_Code_Fld_(pk) Product_Code Fld(fk) Product_Produce_Comp_ Fld(fk) Order_Where_Invited_From_Fld Employee_Id __Fld (fk) Customer _Id _Fld (fk) Order_date_Fld Order_Required_date_Fld Order_Actual_date_Fld Order_Payment_Amount_Fld Order_Status_Fld Employee_Id _Fld (pk) Employee_First_Name_Fld Employee_Last_Name_Fld Employee_Address_Fld Employee_Birth_Date_Fld Employee_Phone_Fld Employee_Start_Date_Fld Employee_HMO_Fld Employee_Start_Date_Fld B A Employee_Id_Fld_(pfk) Shift_Name_Fld(pfk) Date_Fld(pfk) Suppliers_Tbl B Supplier_Name _Fld (PK) Supplier_Phone _Fld Supplier_Contact_Name_Fld Supplier_Contact_Phone_Fld Supplier_email_Fld Repairs_Tbl A D Order code Fld (pk) Supplier_Name_Fld(fk) Order_date_Fld Order_Estimate_date_Fld Order_Actual_date_Fld Employee_Id _Fld(fk) Order_Amount_Items_Fld Order_Total_Price_Fld Order_Missing_Items_Fld Order_Status_Fld Product_code_Fld(fk) Product_Produce_Comp_Fld(fk) D Shift_Name_Fld(fk) Date_Fld(fk) Hour_Start_In_Day_Fld Hour_End_In_Day_Fld Shifts_Of_Employees_Tbl Supply_Orders_Tbl D Repair _Code Fld (pk) Customer _Id _Fld(fk) Employee_Id_Fld (fk) Repair_Send_Date _Fld Repair_Return_Date _Fld Repair_Reason_Fld Repair_Status_Fld Repair_Place_Of_Repair_Fld Product Code Fld(fk) Product_Produce_Comp_ Fld(fk)

DSD_Ver_01 2 Shoe store Management System Data Structured Diagram 3 D Customers_Returns_Tbl Receipt_Number_Fld_(pfk) Rerturn_Amount_Of_Product_Fld Product _Code_Fld(fk) Product_Produce_Comp_Fld(fk) Customer _Id _Fld(fk) Customer_Tbl 1 Customer's_Purchases_Tbl 3 Customer Id Fld (pk) Customer_First_Name_Fld Customer_Last_Name_Fld Customer_Phone_Fld Customer_Email_Fld 3 A 2 Order_Code_Fld_(pk) Product_Code Fld(fk) Product_Produce_Comp_ Fld(fk) Order_Where_Invited_From_Fld Employee_Id __Fld (fk) Customer _Id _Fld (fk) Order_date_Fld Order_Required_date_Fld Order_Actual_date_Fld Order_Payment_Amount_Fld Order_Status_Fld Employees_Tbl 1 Employee_Id _Fld (pk) Employee_First_Name_Fld Employee_Last_Name_Fld Employee_Address_Fld Employee_Birth_Date_Fld Employee_Phone_Fld Employee_Start_Date_Fld Employee_HMO_Fld Employee_Start_Date_Fld B B Product Code Fld (pk) Product_Produce_Comp_ Fld (pk) Product_Price_Fld Product_Color_Fld Product_Size_Fld Supplier_Name _Fld(fk) Product_Units_In_Stock_Fld Shifts_Tbl Customers_Orders_Tbl D 2 Products_Tbl Line_In_Customers_Orders_Tbl A Item_Sold. By_Store_Tbl Product _Code_Fld(pfk) Product_Produce_Comp_Fld(pfk) Nomber_Receipt_(pfk) Item_Amount_Fld Date_Fld Nomber_Receipt_(pk) Purchase_Date_Fld Purchase_Item_Amount_Fld Customer_Id_Fld(fk) Product_Code Fld(fk) Product_Produce_Comp_ Fld(fk) Order_Code_Fld_(pfk) Product _Code_Fld(pfk) Product_Produce_Comp_Fld (pfk) Date_Fld Remarks_Fld B D 1 Supply_Orders_Tbl Shifts_Of_Employees_Tbl 3 1 Suppliers_Tbl B Supplier_Name _Fld (PK) Supplier_Phone _Fld Supplier_Contact_Name_Fld Supplier_Contact_Phone_Fld Supplier_email_Fld Repairs_Tbl A D Order code Fld (pk) Supplier_Name_Fld(fk) Order_date_Fld Order_Estimate_date_Fld Order_Actual_date_Fld Employee_Id _Fld(fk) Order_Amount_Items_Fld Order_Total_Price_Fld Order_Missing_Items_Fld Order_Status_Fld Product_code_Fld(fk) Product_Produce_Comp_Fld(fk) D Shift_Name_Fld(fk) Date_Fld(fk) Hour_Start_In_Day_Fld Hour_End_In_Day_Fld Employee_Id_Fld_(pfk) Shift_Name_Fld(pfk) Date_Fld(pfk) 2 3 D Repair _Code Fld (pk) Customer _Id _Fld(fk) Employee_Id_Fld (fk) Repair_Send_Date _Fld Repair_Return_Date _Fld Repair_Reason_Fld Repair_Status_Fld Repair_Place_Of_Repair_Fld Product Code Fld(fk) Product_Produce_Comp_ Fld(fk)