NOOR Restaurant DSDVer02 ppt Compatible with ERD Ver

NOOR _Restaurant _DSD_Ver_02. ppt Compatible with ERD Ver 003 Suppliers_Tbl NOOR Restaurant - Data Structures Diagram Employees_Tbl B Employee_ID_Fld (PK) job_title_Code_Fld(FK) Employee_First_Name_Fld Employee_Last_Name_Fld Employee_Birth_Date_Fld Employee_Phone. Number_Fld Employee_Start_Day_Fld Employee_Manger_Code_Fld Employee_Job_Title_Tbl Deliveries_Tbl Delivery_Code_Fld (PK) Del_Emp_Code_Fld (FK) Del_Date_Fld A D Supplier_Code_Fld (PK) Supplier_Name_Fld Supplier_Connection_Time_Fld Supplier_Address_Fld Sup_Contact_Name_Fld Sup_Contact_Number_Fld Sup_Fax. Number_Fld Sup_EMail_Fld Products_Tbl Customer_Code_Fld (FPK) Delivery_Code_Fld (FPK) Del_Leaving_Time_Fld Del_Arrival_Time_Fld job_title_Code_Fld(PK) job_title_Name_Fld D Sup_Order_Code _Fld (PK) Sup_Order_Date_Fld Sup_Order_Recived_Date_Fld Supplier_Code_Fld (FK) Employee_ID_Fld (FK) B Product_Code_Fld (PK) Product_Name_Fld Product_Price_Fld Deleviry_Time_Fld Supplier_Code_Fld (FK) Sup_Order_Code _Fld(FPK) Product_Code_Fld (FPK) Quantity_Fld Prod_Measur_Unit_Fld Legend Customers_Tbl B Orders_From_Suppliers_Tbl Products_Suppliers_Orders_Tbl A Deliveries_Customers_Tbl A job_title_Code_Fld(FPK) Employee_ID_Fld (FPK) Employee_Expertise_Fld Job_Title_Tbl B D Customer_Code_Fld (PK) Cust_First_Name_Fld Cust_Last_Name_Fld Cust_Tel_Fld Cust_Area_Code_Fld Cust_Street_Fld Cust_House_Number_Fld Orders_From_Costumers_Tbl D Order_Code_Fld (PK) Costumer_Code _Fld (FK) Order_Date_Fld Order_Number_Fld Delivery_Code_Fld (FK) Employee_ID Fld (FK) Order_Cost_Fld Menu_Tbl Dish_Code_Fld (PK) Dish_Name_Fld Dish_Price_Fld B Cust_Order_Menu_Tbl Dish_Code_Fld (FPK) Order_Code_Fld (FPK) Quantity_Fld Notes_Fld Xxx_Tb B l D A PK FK PFK A Table Basic table Dependant Table Association Table Primary Key Foreign Key Primary Foreign Key 1: 1 1: N N: M

NOOR _Restaurant _DSD_Ver_01. ppt Compatible with ERD Ver 003 Suppliers_Tbl NOOR Restaurant - Data Structures Diagram B Employees_Tbl Employee_ID_Fld (PK) job_title_Code_Fld(FK) Employee_First_Name_Fld Employee_Last_Name_Fld Employee_Birth_Date_Fld Employee_Phone. Number_Fld. Em ployee_Start_Day_Fld 1 D Deliveries_Tbl Delivery_Code_Fld (PK) Del_Emp_Code_Fld (FK) Del_Date_Fld 3 Supplier_Code_Fld (PK) Supplier_Name_Fld Supplier_Connection_Time_Fld Supplier_Address_Fld Sup_Contact_Name_Fld Sup_Contact_Number_Fld Sup_Fax. Number_Fld Sup_EMail_Fld 1 Customer_Code_Fld (FPK) Delivery_Code_Fld (FPK) Del_Leaving_Time_Fld Del_Arrival_Time_Fld Job_Title_Tbl job_title_Code_Fld(PK) job_title_Name_Fld 2 B 1 Customers_Tbl D Customer_Code_Fld (PK) Cust_First_Name_Fld Cust_Last_Name_Fld Cust_Tel_Fld Cust_Area_Code_Fld (FK) Cust_Street_Fld Cust_House_Number_Fld 1 Orders_From_Suppliers_Tbl Sup_Order_Code _Fld (PK) Sup_Order_Date_Fld Sup_Order_Recived_Date_Fld Supplier_Code_Fld (FK) Employee_ID_Fld (FK) D 3 Products_Suppliers_Orders_Tbl A Deliveries_Customers_Tbl A Products_Tbl B Product_Code_Fld (PK) Product_Name_Fld Product_Price_Fld Deleviry_Time_Fld Supplier_Code_Fld (FK) 4 Employee_Job_Title_Tbl job_title_Code_Fld(FPK) Employee_ID_Fld (FPK) Employee_Expertise_Fld B 2 Orders_From_Costumers_Tbl D Order_Code_Fld (PK) Costumer_Code _Fld (FK) Order_Date_Fld Order_Number_Fld Delivery_Code_Fld (FK) Employee_ID Fld (FK) Order_Cost_Fld 4 B Menu_Tbl Dish_Code_Fld (PK) Dish_Name_Fld Dish_Price_Fld 1 Supplier_Code_Fld(FPK) Product_Code_Fld (FPK) Quantity_Fld Prod_Measur_Unit_Fld 4 Legend Xxx_Tb B l D A PK FK PFK Cust_Order_Menu_Tbl Dish_Code_Fld (FPK) Costumer_Code_Fld (FPK) Quantity_Fld Notes_Fld A 5 Table Basic table Dependant Table Association Table Primary Key Foreign Key Primary Foreign Key 1: 1 1: N N: M