Story Time Entity Relationships Diagram B Suppliers Supplier
“Story Time” Entity Relationships Diagram B Suppliers Supplier _Code (PK) brings B Items contains Item_Num (PK) Mem Order Num(PK) make ordered provides D Members Orders B Club Members D Supply Orders Member ID (PK) Sup Order_Num (PK) Legend Register makes Entity B D PK Employees Employee ID (PK) B Relation Entity Basic Entity Defendant Entity Primary Key Relation 1: 1 1: N N: M Self Relationship Mandatory Optional
“Story Time” Data Structures Diagram Member_Orders_Tbl Mem Order_Num (PK) Member_ID Fld (FK) Mem_order_date_Fld Mem_deliver_date_Fld Mem_payment_Fld Mem_arive_date_Fld Employee_ID_Fld(FK) Club_Member_Tbl B Member_ID Fld (PK) Member_First_Name_Fld Member_Last_Name_Fld Member_Birth_Date_Fld Member_mail_Fld Member_adress_Fld Member_phone_Fld Member_join_Date_Fld Items_Tbl B Item_Num Fld (PK) Item_Name_Fld Item_inventory_Fld Item_min_quantity_Fld Item_price_Fld Item_description_Fld D Supply_Orders_Tbl D Employees_Tbl B Sup Order_Num (PK) Supllier_code_Fld (FK) Sup_order_date_Fld Sup_deliver_date_Fld Sup_payment_Fld Sup_arive_date_Fld Employee_ID_Fld(FK) Employee_ID Fld (PK) Employee_First_Name_Fld Employee_Last_Name_Fld Employee_Birth_Date_Fld Employee_Fld Employee_start_Date_Fld Employee_adress_Fld Employee_mail_Fld Employee_phone_Fld Employee_role_Fld Mem_Item_Order_Tbl Mem Order_Num (PFK) Item_Num Fld (PFK) Mem_item_quantity_Fld Supllier_Tbl A B Supllier_Code _Fld (PK) Supllier_Name_Fld Supllier_Phone_Fld Supllier_adress_Fld Supllier_website_Fld Supllier_fax_Fld Supllier_contact_Fld Supllier_mail_Fld Legend Xxx_Tbl Sup_Item_Order_Tbl Sup Order_Num (PFK) Item_Num Fld (PFK) Mem_item_quantity_Fld A Supllier_Item_Tbl Supllier_Code _Fld (PFK) Item_Num Fld (PFK) Sup_item_cost_Fld A 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
- Slides: 11