TommCatt questions

TommCatt answers

• How to best manage historical lookup values in a database?
• FK constraints may cause cycles or multiple cascade paths
• Is it good or bad practice to have multiple foreign keys in a single table, when the other tables can be connected using joins?
• Foreign key in MySql as composite primary key
• Fill in NULL column values with lag(N) values
• Should I use Effective Date or Start Date and End Date for historical recording?
• Can a foreign key reference another foreign key
• Ensure SQLite table only has one row
• How to select all the columns of a table except one column?
• Database design issue. Column value pointing to different tables