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