Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Multiple sets of identical tables - normalized? Wrong? Why?

    Hi,

    first time post here...

    Trying to help a friend out, but struggling to articulate why design is poor.

    She has set up her database where each company has a set of tables (each set are identical but uniquely named).

    I initially thought this was not normalized, but questioning that assumption now. A single group of tables is normalized...but she has lots of groups of these tables. Can't find one of the 1/2/3/4 Normal form rules that it breaks. Am I missing something?

    I'm struggling to communicate WHY she should go back and "normalize" everything.

    Can anyone help articulate this?

    thanks!
    Last edited by wildcatz; 01-21-12 at 18:14.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by wildcatz View Post
    I'm struggling to communicate WHY she should go back and "normalize" everything.
    ask her to write a query which obtains the average sales for all companies, or even just the company with the largest sales amount
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    A database with multiple identical tables won't necessarily violate any Normal Form. It probably will violate the Principle of Orthogonal Design however. You ought to avoid such designs because they give rise to ambiguous, potentially inconsistent data and lead to redundancy and complexity in your data manipulation code.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •