Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 7
Impact
~8k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
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?