I don't believe AI is going to clean up bad data.  Humans can't even clean up dirty data.  I have seen situations where bad code created 750 duplicate entries for...

It will be interesting to see how many comments are made on this topic of database design.  It seems that action is what everyone wants to see and design is...

I have many years of experience in IT as an employee as well as a consultant.  As I see it you need to hire all of the above.

Hire inexperienced staff...

I retired in 2021 and figured it was a good time.  Database design was one of my favorite tasks and it appeared that no one was designing databases.  I agree...

• This reply was modified 3 weeks, 2 days ago by hmbacon.
• This reply was modified 3 weeks, 2 days ago by hmbacon.

Wow.  The silence indicates whoever reads these post has not given much thought to finances and retirement.  The sooner you think about it and make financial plans the better off...

I converted Jeff's algorithm for determining ISO dates to Oracle, but it was only a matter of translating the algorithm.  In the case of the splitter, the purpose was not...

Another excellent article.  I am currently working on a budgeting application in Oracle and decided to use these concepts in Oracle.  WARNING: For anyone else wanting to use these concepts...

As someone who has been around too long, I know the purpose of the semi-colon.  It is to define the end of a statement.  It is possible to put several...

Examples of CTE's with semicolons has always bothered me.  I started out in Oracle and the semi-colon is required and it only took about a year to finally include it...

I indicated that the need for a cursor is rare but you need to be willing to use them.  If you need to update 6 tables based on the data...

9. How many loops were used to determine duration and is it clock or cpu time.

10. Was the load on the system constant like in a stand alone database on...

I believe that the fast forward cursor of SQL Server is a great tool to use if, and only if, multiple actions need to be taken on each record returned. ...

I am sorry for the late response and don't know if you are still looking for an example.  By definition, a critical part of conceptual modeling is identifying the unique...

Since you are illustrating your process using a physical database, I think it would be instructive to include primary and foreign keys on your normalized tables to enforce your normalization. ...

Great article, Sucharita.  The explanation of these 4 normal forms is clear and concise.  As Scott said, normal forms are a conceptual construct but I believe this analysis is useful...