Do you know a good source to learn how to design SQL solutions? Beyond the basic language syntax, I'm looking for something to help me understand: What tables to build and how to link them How to ...

Jan 7, 2010 · Database Design For Revisions Best design for a change log auditing database table Ideas on database design for capturing audit trails I have also stumbled upon this interesting article …

To make your job easier, you could use an existing scheduler for the scheduling part. In Java there are for example Quartz or a library I wrote myself, db-scheduler. db-scheduler is easily embeddable, and …

I need to create a database table to store different changelog/auditing (when something was added, deleted, modified, etc). I don't need to store particularly detailed info, so I was thinking somet...

Aug 23, 2012 · The system must be able to capture the history of the actions taken. What is the best way to design it? Should I create a common table to store the approval information and remarks. …

Of course I realize that there's no one "right way" to design a SQL database, but I wanted to get some opinions on what is better or worse in my particular scenario. Currently, I'm designing an or...

Nov 18, 2008 · A database schema is the collection of relation schemas for a whole database. A table is a structure with a bunch of rows (aka "tuples"), each of which has the attributes defined by the …

Apr 13, 2013 · This is the first time I'm trying to store a more complex object into a database. I need some help with the design of the database. The recipe Object I want to store and regenerate from …

May 14, 2014 · The possibility to design this was asked in Database design - Similar Contact Information for multiple entities Now, in my database I leave a possibility to have a multiple addresses, multiple …

Aug 2, 2016 · The following actions might require a table to be re-created: Adding a new column to the middle of the table Dropping a column Changing column nullability Changing the order of the …