I have a database that contains a number of individual tables for each sales agents.
This design flaw is called attribute splitting. Would you have “Male_Personnel” and “Female_Personnel” tables or a single “Personnel” table? Pretty obvious, isn't it? ...
That is really bright idea! Actually, taking in count progress of the west civilization in whole, you need at least three tables:
“Male_Personnel”, “Female_Personnel” and "Unknown_Personnel"
Actually the attribute splitting may not be a flaw, but done on purpose. One of the common places where you can see this kind of picture is data warehouses (non-conformed dimensions).
There are other design patterns where attribute splitting is a feature - not a flow.
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)How to post your question to get the best and quick help