133 reputation
17
bio website
location Geneva, Switzerland
age 29
visits member for 2 years, 2 months
seen Jan 20 at 11:51

I work as an Information Security professional, solving problems like the ones on this website. If you need advisory or help, you can contact me.


Sep
24
awarded  Autobiographer
Jan
20
awarded  Scholar
Jan
20
accepted Is there a tool to check if my database is normalized to the third normal form?
Jan
7
awarded  Notable Question
Apr
18
awarded  Popular Question
Sep
23
awarded  Supporter
Sep
23
revised Is there a tool to check if my database is normalized to the third normal form?
deleted 7 characters in body; edited title
Sep
23
comment Is there a tool to check if my database is normalized to the third normal form?
@ypercube: Thanks for the tip, i'll take a look at Access.
Sep
23
comment Is there a tool to check if my database is normalized to the third normal form?
@Chris: yes, I was referring to ER diagrams for semantic analysis only.
Sep
23
revised Is there a tool to check if my database is normalized to the third normal form?
added 245 characters in body
Sep
23
comment Is there a tool to check if my database is normalized to the third normal form?
Thanks for this detailed answer. However, following your example, it should be possible for a tool that analyze sample data to detect that "instructor" values are repeated a lot, and also appears in another table, hence suggesting it might be candidate for foreign key or any other change that would make this table 3nf compliant, or am I missing something ?
Sep
23
awarded  Editor
Sep
23
revised Is there a tool to check if my database is normalized to the third normal form?
edited title
Sep
23
comment Is there a tool to check if my database is normalized to the third normal form?
Indeed there will be some manual review to do, I don't expect a tool to do it fully automatically. But I'm pretty sure most of the work can be automated by analyzing existing data in the DB (at least, samples of it), and/or fields name/type .
Sep
23
comment Is there a tool to check if my database is normalized to the third normal form?
Nice. I was indeed looking for both ways to analyze a schema (ER diagram and sample data analysis). Do you know of any other recent software than Visio ? I don't have (yet) a licence for it.
Sep
23
awarded  Student
Sep
22
comment Is there a tool to check if my database is normalized to the third normal form?
Does it mean normalization is not used in real ? I planned to use it as a starting point, and will consider denormalizing when it slows performance down.
Sep
22
awarded  Analytical
Sep
22
asked Is there a tool to check if my database is normalized to the third normal form?