Every company dataset I have worked with stores history as scalar columns: founded_year INT ceo_name TEXT headquarters TEXT revenue BIGINT Every one of those is a point-in-time fact pretending to be a permanent one. The moment you need to answer "who was in charge when this happened", the schema...
Source: [Dev.to](https://dev.to/corpdigest/your-companies-table-is-lying-to-you-about-when-things-happened-ge3)