EmployeesTbl CAREMARKET Supermarket store Management System Data Structured
Employees_Tbl CAREMARKET -Supermarket store Management System Data Structured Diagram B Employee ID Fld(PK) Employee_FName_Fld Customers_Orders_Tbl Employee_LName_Fld Suppliers Tbl D Supplier_Code_Fld (PK) Supplier_Name_Fld Customers_Tbl Customer_Fn. L_name_Fld Customers_ID_Fld (FK) Customer_Phone_Number_Fld Employee_ID_Fld(FK) Lines_In_Customer_Orders_Tbl Mail_Customers_Tbl Supplier_Address_Fld Employees_to_Mail_Customer s_Tbl A Supplier_Phone_Number_Fld Customer_Mail_code Fld(FPK) Customer_MAIL_ID_Fld (PK) Supplier_Mail_Fld Employee ID Fld(FPK) Customer_Address_Fld Orders_From Suppliers D Order From Suppliers Code Fld(PK) Lines_In_Sup_Orders_Tbl B Customer_ID_Fld (PK) Order_Code_Fld (PK) B Product_Code_Fld (FPK) Customer_Mail_code Fld(PK) B Products_Tbl A Order Code Fld(FPK) Order_Charge_Fld Order_Date_Fld B Product_Code_Fld (PK) Supplier_Code_Fld (FPK) Product_Code_Fld (FPK) Employee ID Fld (FK) Order From Suppliers Code Fld(FPK) Product_Name_Fld Order_From_Suppliers_Date_Fld Order_Quantity_Fld Product_Category_Fld Submitted BY Alin Khononov 318366655 Osher Yeshayauh 318984168 Lishay Kroytoro 318296993 DSD_Ver_02 Compatible With ERD Ver 04 Product_Price_Fld Product_Quantity_Fld A
CAREMARKET -Supermarket store Management System Data Structured Diagram B Employee ID Fld(PK) 1 Employees_Tbl Employee_FName_Fld Customers_Orders_Tbl Employee_LName_Fld Suppliers Tbl D B 1 Customers_Tbl 2 Customers_ID_Fld (FK) Customer_Phone_Number_Fld Employee_ID_Fld(FK) Lines_In_Customer_Orders_Tbl Mail_Customers_Tbl Supplier_Address_Fld Supplier_Phone_Number_Fld Customer_Mail_code Fld(FPK) Customer_MAIL_ID_Fld 1(PK) Supplier_Mail_Fld Employee ID Fld(FPK) Customer_Address_Fld D Order From Suppliers Code Fld(PK) Supplier_Code_Fld (FPK) 2 Product_Code_Fld (FPK) 3 Product_Code_Fld (FPK) Customer_Mail_code Fld(PK) B 2 Lines_In_Sup_Orders_Tbl Products_Tbl A Order Code Fld(FPK) Order_Charge_Fld Order_Date_Fld B Product_Code_Fld (PK) Employee ID Fld (FK) Order From Suppliers Code Fld(FPK) Product_Name_Fld Order_From_Suppliers_Date_Fld Order_Quantity_Fld Product_Category_Fld Submitted BY Alin Khononov 318366655 Osher Yeshayauh 318984168 Lishay Kroytoro 318296993 B Customer_Fn. L_name_Fld Employees_to_Mail_Customer s_Tbl A Orders_From Suppliers 1 Customer_ID_Fld (PK) Order_Code_Fld (PK) Supplier_Name_Fld DSD_Ver_02 Compatible With ERD Ver 04 Product_Price_Fld Product_Quantity_Fld 2 A 3
- Slides: 2