Hi
I have started working on automated normalization. I have written the detailed work flow for normalizing the relation to 1NF in my blog[1], I need your feedback/suggestions on the same. Just needed to know if the approach looks good.
Also for user interface, I'm thinking to keep options on db_operations and
tbl_operations page will be appropriate. The options will have
1. Normalize to 1NF,
2.
Normalize to 2NF (1NF + 2NF),
3. Normalize to 3NF (1NF+2NF+3NF).
On
select of an option, user shall be presented a dialogue which will
assist in normalizing the relation. Is it fine ? or should we keep these options somewhere else ?
[1]
http://smita786.blogspot.in/2014/06/gsoc14-coding-week-5-automated.html