If you store the same information in multiple places in a database then you run the risk of updating that information in one spot in the database and not updating it in another and then ending up with inconsistent information in the database. To avoid this happening we need to design our database properly in [...]

All relational databases support the same basic structured query language commands to access and update the database. Of course some of them also have custom extensions to the SQL as well. In this article I look at the basic SQL required for adding, updating, and deleting records in any relational database.
Adding, Replacing, and Deleting Records