There are some modifications made to a system below by adding the orderdetail table. So whatsz the function of it and how will it work when a order is made. And does it follow the rules below. If not make changes to the tables or diagram. Thank You

- 1 customer can make many orders, but each order is only for 1 customer - 1 order can contain many products, and each product can be in many orders - 1 staff can process many orders, but each order is only processed by 1 staff

Before

After adding

TBL STAFFS 1 FLD STAFF_ID FLD STAFF NAME FLD STAFF_POSITION FLD STAFF SALARY FLD STAFF CONTACTNUM TBL COUNTRY FLD_COUNTRY_ID FLD COUNTRY_NAME TBL_PRODUCTS 1 FLD PRODUCT_ID FLD PRODUCT_NAME FLD_PRODUCT_PRICE FLD PRODUCT YEAR FLD PRODUCT_COUNTRY FLD PRODUCT SIZE FLD PRODUCT QUANTITY FLD PRODUCT DESCRIPTION TBL_ORDER FLD_ORDER_ID FLD ORDER DATE FLD_PRODUCT_ID FLD STAFF_ID FLD CUSTOMER ID FLD ORDER QUANTITY 8181 1 TBL CUSTOMERS 1 FLD CUSTOMER_ID FLD CUSTOMER NAME FLD CUSTOMER IC FLD CUSTOMER GENDER FLD CUSTOMER_CONTACTNUM TBL STAFFS 1 FLD STAFF_ID FLD STAFF NAME FLD STAFF_POSITION FLD STAFF SALARY FLD STAFF CONTACTNUM TBL PRODUCTS TBL COUNTRY 1 FLD COUNTRY_ID FLD COUNTRY NAME 00 FLD PRODUCT_ID FLD PRODUCT_NAME FLD PRODUCT PRICE FLD_PRODUCT_YEAR FLD PRODUCT COUNTRY FLD_PRODUCT_SIZE FLD_PRODUCT_QUANTITY FLD PRODUCT DESCRIPTION TBL ORDER 1 FLD ORDER ID FLD_ORDER DATE FLD_PRODUCT_ID FLD STAFF_ID FLD_CUSTOMER_ID FLD ORDER QUANTITY 18 18 TBL CUSTOMERS FLD CUSTOMER ID FLD CUSTOMER NAME FLD_CUSTOMER_IC FLD CUSTOMER GENDER FLD CUSTOMER CONTACTNUM TBL_ORDERDETAILS FLD PRODUCT_JD 1 FLD_ORDER_ID