Follow @DBDebunk Follow @ThePostWest

Can you identify all the fallacies and misconceptions in the following online exchange? What is the elephant in the room?

Q: “I have done data normalization on dummy data and would like to know if I did it correctly. If it is done correctly, I would also like to ask two things below, because it is about 3NF.

1NF: This table should be 1NF. 

2NF: I selected composite key (userID and Doors) as they represent minimal candidate key and got three tables applying FD rule.

 

3NF: Applying the rule of transitive dependency on 1st table in 2NF, I got out 4 tables (showing only first two, because the last two remain unchanged).

Questions: Is this database normalisation correct? If not could you point me where I did mistake? If answer on first question is True: Should the last table in 3NF be transformed into two tables, given it is not in correct Third normal form. Two non-key atributes have FD keycode -> accessGroup.”

------------------------------------------------------------------------------------------------------------------

SUPPORT THIS SITE
DBDebunk was maintained and kept free with the proceeds from my @AllAnalitics column. The site was discontinued in 2018. The content here is not available anywhere else, so if you deem it useful, particularly if you are a regular reader, please help upkeep it by purchasing publications, or donating. On-site seminars and consulting are available.Thank you.

LATEST POSTS

NEW   NOBODY UNDERSTANDS DATABASE DESIGN (sms)

08/25 NOTHING TO DO WITH RELATIONAL (t&n)

08/20 DATABASE RELATIONS, DATABASE DESIGN & CORRECTNESS (sms)

08/14 THE VOCIFEROUS IGNORANCE HALL OF SHAME (t&n)

UPDATES

08/20 Added Logic and databases course to LINKS page.

LATEST PUBLICATIONS (order from PAPERS and BOOKS pages)
- 08/19 Logical Symmetric Access, Data Sub-language, Kinds of Relations, Database Redundancy and Consistency, paper #2 in the new UNDERSTANDING THE REAL RDM series.
- 02/18 The Key to Relational Keys: A New Understanding, a new edition of paper #4 in the PRACTICAL DATABASE FOUNDATIONS series.
- 04/17 Interpretation and Representation of Database Relations, paper #1 in the new UNDERSTANDING THE REAL RDM series.
- 10/16 THE DBDEBUNK GUIDE TO MISCONCEPTIONS ABOUT DATA FUNDAMENTALS, my latest book (reviewed by Craig Mullins, Todd Everett, Toon Koppelaars, Davide Mauri).

USING THIS SITE
- To work around Blogger limitations, the labels are mostly abbreviations or acronyms of the terms listed on the FUNDAMENTALS page. For detailed instructions on how to understand and use the labels in conjunction with that page, see the ABOUT page. The 2017 and 2016 posts, including earlier posts rewritten in 2017 were relabeled accordingly. As other older posts are rewritten, they will also be relabeled. For all other older posts use Blogger search.
- The links to my AllAnalytics columns no longer work. I re-published only the 2017 columns @dbdebunk, and within them links to sources external to AllAnalytics may or may not work.

SOCIAL MEDIA
I deleted my Facebook account. You can follow me @DBDdebunk on Twitter: will link to new posts to this site, as well as To Laugh or Cry? and What's Wrong with This Picture? posts, and my exchanges on LinkedIn.
------------------------------------------------------------------------------------------------------------------

A: “Re "is this right?": Show the steps of your work following your reference/textbook, with justification -- not all terms/notations are standard & we don't know exactly what algorithm/method you are following & we want to check your work but not redo it & we need your choices when a process allows them & otherwise we can't tell you where you went right or wrong & we don't want to rewrite your reference... Where & how are you 1st stuck/unsure in what process you quote? PS We don't normalize to 3NF by going through lower NFs. "1NF" has many meanings --quote yours. What textbook/reference are you following -- name & edition? You don't give FDs but they drive the process. A CK is a (so-called) minimal superkey, "minimal CK" doesn't mean anything. Don't know what "FD rule" or "apply a FD rule" mean.”

Q: “Thank you for your comments, but I won't apply anything or explain anything to you anymore. If you feel I didn't provide enough information or violated any rules, feel free to close the topic. But then I am closing my StackOverflow account as as well, naming you as a reason.”

A: “I have only written helpful, appropriate & neutral comments & I explained & justified why I commented. After informing yourself re how the site works, if you think I have been inappropriate, besides flagging a post or comment for a moderator you can consider asking an on-topic question about your questions and/or my comments at Meta Stack Overflow (but beware "meta effect" attention you will get on your questions). See help & Q&A there & at Meta Stack Exchange re how the sites work. Good luck.”

Q: “I would appreciate it if you don't comment on my posts anymore. I won't follow any of your requests. Thank you.”