Return From Customers D Shoe store Management System

Return From Customers D Shoe store Management System Entity Relationships Diagram Contain Receipt Number(Pf. K) ERD_Ver_05 Orders From Suppliers Becomes a D Order Code (PK) Contain D Customer's Purchases Make Supplied from Receipt's Number(PK) B Products Customers Products_ Code (PK)) B Make Customer ID (PK) Includes Supplier Name (PK) Ask for Make D Repairs Send to Contain Customer’s Orders Suppliers Provide Repair Code (PK) D Order Code (PK) Make Employees B Employee ID (PK) Have a Shifts Shift Name (PK) B BB

DSD_Ver_04 Customers_Purchases_Tbl Shoe store Management System Data Structured Diagram Customers_Returns_Tbl Item_Sold. By_Store_Tbl A B Products_Tbl Line_In_Customers_Orders_Tbl B Customer Id Fld (pk) Customer_First_Name_Fld Customer_Last_Name_Fld Customer_Phone_Fld Customer_Email_Fld Customers_Orders_Tbl D Order_Code_Fld_(pk) Order_Where_Invited_From_Fld Employee_Id __Fld (fk) Order_date_Fld Customer _Id _Fld (fk) Order_Required_date_Fld Order_Actual_date_Fld Order_Payment_Amount_Fld Order_Status_Fld Product Code Fld (pk) Product_Name_Fld Product_Price_Fld Product_Color_Fld Product_Size_Fld Supplier_Name _Fld(fk) Product_Units_In_Stock_Fld A Order_Code_Fld_(pfk) Product _Code_Fld(pfk) Remarks_Fld Line_In_Suppliers_Orders_Tbl Oreder_Code_(pfk) Product _Code_Fld(pfk) Remarks_Fld Employees_Tbl 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 B A Shifts_Tbl Employee_Id_Fld_(pfk) Shift_Name_Fld(pfk) Date_Fld(pk) Shift_Number_Of_Hours_Fld Suppliers_Tbl A B Supplier_Name _Fld (PK) Supplier_Phone _Fld Supplier_Contact_Name_Fld Supplier_Contact_Phone_Fld Supplier_email_Fld B Shift_Name_Fld(fk) Hour_Start_In_Day_Fld Hour_End_In_Day_Fld Shift _Length_In_Hours_Fld Shifts_Of_Employees_Tbl D Supply_Orders_Tbl Order code Fld (pk) Supplier_Name_Fld(fk) Order_date_Fld Order_Estimate_date_Fld Order_Actual_date_Fld Order_Amount_Items_Fld Order_Missing_Items_Fld Order_Status_Fld Product _Code_Fld(pfk) Nomber_Receipt_(pfk) Item_Amount_Fld Date_Fld Nomber_Receipt_(pk) Purchase_Date_Fld Purchase_Item_Amount_Fld Customer_Id_Fld(fk) Amount_Products_Fld D Receipt_Number_Fld_(pfk) Customer_Id _Fld(fk) Product_Code_Fld(fk) Date_Of_Return_Fld Customer_Tbl D Repairs_Tbl 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) D

DSD_Ver_04 3 Shoe store Management System Data Structured Diagram 4 Customers_Returns_Tbl Customer_Tbl D Product _Code_Fld(pfk) Nomber_Receipt_(pfk) Item_Amount_Fld Date_Fld Nomber_Receipt_(pk) Purchase_Date_Fld Purchase_Item_Amount_Fld Customer_Id_Fld(fk) Amount_Products_Fld Line_In_Customers_Orders_Tbl B Customer Id Fld (pk) Customer_First_Name_Fld Customer_Last_Name_Fld Customer_Phone_Fld Customer_Email_Fld Order_Code_Fld_(pfk) Product _Code_Fld(pfk) Remarks_Fld 4 Line_In_Suppliers_Orders_Tbl Customers_Orders_Tbl D Order_Code_Fld_(pk) Order_Where_Invited_From_Fld Employee_Id __Fld (fk) Order_date_Fld Customer _Id _Fld (fk) Order_Required_date_Fld Order_Actual_date_Fld Order_Payment_Amount_Fld Order_Status_Fld Oreder_Code_(pfk) Product _Code_Fld(pfk) Remarks_Fld Employees_Tbl 4 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 B A Shifts_Tbl 1 Suppliers_Tbl Shift_Name_Fld(fk) Hour_Start_In_Day_Fld Hour_End_In_Day_Fld Shift _Length_In_Hours_Fld Employee_Id_Fld_(pfk) Shift_Name_Fld(pfk) Date_Fld(pk) Shift_Number_Of_Hours_Fld 2 A 1 B Supplier_Name _Fld (PK) Supplier_Phone _Fld Supplier_Contact_Name_Fld Supplier_Contact_Phone_Fld Supplier_email_Fld B Shifts_Of_Employees_Tbl D Supply_Orders_Tbl B Product Code Fld (pk) Product_Name_Fld Product_Price_Fld Product_Color_Fld Product_Size_Fld Supplier_Name _Fld(fk) Product_Units_In_Stock_Fld A 3 Order code Fld (pk) Supplier_Name_Fld(fk) Order_date_Fld Order_Estimate_date_Fld Order_Actual_date_Fld Order_Amount_Items_Fld Order_Missing_Items_Fld Order_Status_Fld 4 2 Products_Tbl 3 A Item_Sold. By_Store_Tbl D Receipt_Number_Fld_(pfk) Customer _Id _Fld(fk) Product_Code Fld(fk) Date_Of_Return_Fld 1 Customers_Purchases_Tbl Repairs_Tbl 3 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) D