meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 8 months |
| seen | Apr 19 at 21:32 | |
| stats | profile views | 2 |
|
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? |
