Comments on: ROUTINE_PRIVILEGES implementation https://shlomi-noach.github.io/blog/mysql/routine_privileges-implementation Blog by Shlomi Noach Mon, 27 Jun 2011 11:48:01 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/routine_privileges-implementation/comment-page-1#comment-44820 Mon, 27 Jun 2011 11:48:01 +0000 https://shlomi-noach.github.io/blog/?p=3764#comment-44820 Shai,

Thanks. Please continue nitpicking

]]> By: Shai https://shlomi-noach.github.io/blog/mysql/routine_privileges-implementation/comment-page-1#comment-44786 Mon, 27 Jun 2011 00:02:29 +0000 https://shlomi-noach.github.io/blog/?p=3764#comment-44786 Hi Shlomi,

A nitpick: 2nd normal form requires that each attribute be dependent on “the whole key”; so actually, the fact that the attribute is_grantable depends only on part of the key makes the table _not_ 2NF (and consequently, of course, not any higher NF).

(according to Chris Date, the fact that these tables contain nulls makes them not even 1NF, but I believe most people disagree there).

]]>