Advertisement
Promo

Become a member of the ZDNet UK community

nico5038

View blog's RSS Feed

Knowledge can't be divided, only multiplied

It's the quality of the team that makes a Q&A site work

Sunday 2 November 2008, 11:52 AM

Ab-normalization at Experts Exchange - Part 1

Posted by nico5038

I'm always disappointed when beginners are pointed the wrong way.

The first glance at a table design like:

Table A - ID, LAstname, First Name, Year
Table B - ID, LAst Name, First Name, Year, accepted status

Triggers for me the question "Why two tables with almost identical fields?"

But as the beginner asks for how to delete rows in both tables when the [accepted status] holds a certain value, he's helped by an "expert" without even asking for the reason of this "design". Even the possibility of a Cascade Delete isn't mentioned...

It's obvious that this beginner should start with redesigning his database structure and should be pointed to an article about database normalization. Having this "process driven table design" will cause a lot of additional questions and coding, thus generating more "expert points" for this "would be expert". So it's obvious that it's not in the interest of this "expert" to point this beginner in the right direction and this (paying) experts exchange member is fooled by this "expert" as he thinks his problem is solved, while it just has started.

This bad service to a paying experts exchange "premium" member is even more embarrassing when you know that this "would be expert" even proudly states in his profile that he's an MVP....

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Q_23762363.html and for those without member access a copy can be found at: http://www.altict.nl/Q_23762363.html )

Comments on this post

roger andre

This comment has been deleted at the users request

Updated by roger andre on Mar 13, 2009 11:46 AM

nico5038

Hi Roger,

To make sure you can read the page I've added it to my geocities page:
http://www.geocities.com/nico5038/Q_23762363.html

Experts-Exchange just likes to receive $$'s for viewing content that's posted by volunteers...

Nic;o)

Posted by nico5038 on Nov 2, 2008 6:15 PM

roger andre

This comment has been deleted at the users request

Updated by roger andre on Mar 13, 2009 11:47 AM

nico5038
  • nico5038
  • IT Consultant
  • Member since: March 2007

Site Activity Rating 1

Contacts

Number of Contacts: 0

Contacts' Latest Discussions

Number of Tracked Discussions: 0

Contacts' Latest Blogs

Number of Contacts Blogs: 0


Skip Sub Navigation Links to CNET Brand Links

Help

Become part of the ZDNet community.

Newsletters