Till Now and Current Problem Being Investigated

• So far, Scott Ambler and Pramod Sadagale have come up with a best practices technique to handle changes in a database design

• So there are some techniques that describe the algorithms for implementing these changes

• However, there are limitation

• No automation

• DBA must be involved

• There is no notion of dependency between structure and query

• Thus, the current problem being investigated and solved is that once the normal forms and functional dependency changes have been made in a DBMS, we need to change the schema which will trigger changes in queries also, all automatically. We need to, first, establish the dependency structure and query and implement (using IntelliJ Idea IDE) them to create a tool for management of SQL queries.