Tags: %TAGME{ tpaction="" web="Main" tag="" }% view all tags

DatabaseDesignSolution

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 ]
Topic revision: r1 - 2020-01-22 - JimSkon
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback