NOOR Restaurant DSDVer01 ppt Compatible with ERD Ver
NOOR _Restaurant _DSD_Ver_01. 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 Deliveries_Tbl Delivery_Code_Fld (PK) Del_Emp_Code_Fld (FK) Del_Date_Fld 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 job_title_Code_Fld(PK) job_title_Name_Fld Orders_From_Suppliers_Tbl D Sup_Order_Code _Fld (PK) Sup_Order_Date_Fld Sup_Order_Recived_Date_Fld Supplier_Code_Fld (FK) Employee_ID_Fld (FK) Products_Suppliers_Orders_Tbl A Deliveries_Customers_Tbl A Products_Tbl Customer_Code_Fld (FPK) Delivery_Code_Fld (FPK) Del_Leaving_Time_Fld Del_Arrival_Time_Fld Job_Title_Tbl B B Product_Code_Fld (PK) Product_Name_Fld Product_Price_Fld Deleviry_Time_Fld Supplier_Code_Fld (FK) B Supplier_Code_Fld(FPK) Product_Code_Fld (FPK) Quantity_Fld Prod_Measur_Unit_Fld Legend 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 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 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 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 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 2 D Deliveries_Tbl Delivery_Code_Fld (PK) Del_Emp_Code_Fld (FK) Del_Date_Fld 3 job_title_Code_Fld(PK) job_title_Name_Fld 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 Products_Tbl 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 3 B Product_Code_Fld (PK) Product_Name_Fld Product_Price_Fld Deleviry_Time_Fld Supplier_Code_Fld (FK) 4 B 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 Customer_Code_Fld (FPK) Delivery_Code_Fld (FPK) Del_Leaving_Time_Fld Del_Arrival_Time_Fld Job_Title_Tbl 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
- Slides: 2