TommCatt questions

TommCatt answers

• DB design for sensor data (lots and LOTS of data)
• Oracle Database: how to restrict a user to see only his/her own data?
• 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