Merged 3NF solution: product [ prod_code, prod_desc, um, dept_cd (FK), supplier_id (FK), cost, markup ]dept [ dept_cd, dept_name, aisle_no ]supplier [ supplier_id, supplier_name ]
