NanaERand DSDVer01 ppt PastriesERDandDSDver01 ppt bakery goods marketing
Nana_ER_and _DSD_Ver_01. ppt Pastries_ERD_and_DSD_ver_01. ppt מעבדה לעיבוד נתונים bakery goods marketing. Entity Relationships Diagram Suppliers B Supplier_ID_(PK) Products Supply Supplier_ID_(PK) Orders from suppliers D B Costumer_ID (PK) Orders from Costumers Order_ID (PK) D Returns from Costumers Deliver Order_ID (PK) Manages Employees B Costumers Order B Employee_ID (PK) D Legend Entity Basic Entity Dependant Entity Primary Key Foreign Primary Key Relation Deliver 1: 1 1: N N: M Self Relationship Mandatory Optional Entity prime_key(PK) B D PK FPK Relation
Nana_ER_and _DSD_Ver_01. ppt Pastries_ERD_and_DSD_ver_01. ppt Costumers_Tbl bakery goods marketing. Data Structures Diagram D Products_Tbl Costumer_Code_Fld (PK) Buissnes_Name_Fld C_contact_Number_Fld Buissnes_Address_Fld Buissnes_E-Mail_Fld Orders_From_Costumers_Tbl C_Order_Code _Fld (FPK) Costumer_Code_Fld (FPK) Costumer_Credit_Fld Return_Date_Fld Product_code_Fld (FK) Return_Quantity_Fld Employee_ID Fld (FK) Suppliers_Tbl Employees_Tbl B B B Employee_ID Fld (PK) Employee_First_Name_Fld Employee_Last_Name_Fld Employee_Address_Fld Employee_Phone. Number_Fld B Orders_From_Suppliers_Tbl B S_order_Code _Fld (PK) S_order_Date_Fld Supplier_Code_Fld (FPK) Product_code_Fld (FK) S_product_Quantity_Fld Supplier_Payment_Fld Employee_ID Fld (FK) Legend Employees_1_Tbl Employee_ID Fld (PK) B Supplier_Code_Fld (PK) Supplier_Name_Fld Supplier_Address_Fld Scontact_Name_Fld Scontact_Number_Fld Supplier_Fax. Number_Fld Supplier_E-Mail_Fld Product_code_Fld (PK) Product_Name_Fld Product_Price_Fld C_Order_Code _Fld (PK) Costumer_Code_Fld (FPK) Costumer_Payment_Fld C_Order_Date_Fld Product_code_Fld (FK) C_product_Quantity_Fld Employee_ID Fld (FK) Returns_From_Costumers_Tbl מעבדה לעיבוד נתונים Xxx_Tbl B D A PK FK PFK Table Basic table Dependant Table Association Table Primary Key Foreign Key Primary Foreign Key 1: 1 1: N N: M
Nana_ER_and _DSD_Ver_01. ppt Pastries_ERD_and_DSD_ver_01. ppt Costumers_Tbl Costumer_Code_Fld (PK) Buissnes_Name_Fld C_contact_Number_Fld Buissnes_Address_Fld Buissnes_E-Mail_Fld D bakery goods marketing. Data Structures Diagram 2 Orders_From_Costumers_Tbl Products_Tbl Employees_Tbl B Returns_From_Costumers_Tbl 1 B Employees_1_Tbl B Employee_ID Fld (PK) Orders_From_Suppliers_Tbl 1 3 B S_order_Code _Fld (PK) S_order_Date_Fld Supplier_Code_Fld (FPK) Product_code_Fld (FK) S_product_Quantity_Fld Supplier_Payment_Fld Employee_ID Fld (FK) 2 Legend Xxx_Tbl B D A 3 B Supplier_Code_Fld (PK) Supplier_Name_Fld Supplier_Address_Fld Scontact_Name_Fld Scontact_Number_Fld Supplier_Fax. Number_Fld Supplier_E-Mail_Fld 2 Employee_ID Fld (PK) Employee_First_Name_Fld Employee_Last_Name_Fld Employee_Address_Fld Employee_Phone. Number_Fld 3 Suppliers_Tbl B Product_code_Fld (PK) Product_Name_Fld Product_Price_Fld C_Order_Code _Fld (PK) Costumer_Code_Fld (FPK) Costumer_Payment_Fld C_Order_Date_Fld Product_code_Fld (FK) C_product_Quantity_Fld Employee_ID Fld (FK) C_Order_Code _Fld (FPK) Costumer_Code_Fld (FPK) Costumer_Credit_Fld Return_Date_Fld Product_code_Fld (FK) Return_Quantity_Fld Employee_ID Fld (FK) מעבדה לעיבוד נתונים PK FK PFK Table Basic table Dependant Table Association Table Primary Key Foreign Key Primary Foreign Key 1: 1 1: N N: M
- Slides: 4