concept company in category sql

This is an excerpt from Manning's book SQL Server MVP Deep Dives Vol. 2.
In 2010, a company whose business is public safety ran into an issue on a table where they stored mass amounts of collected data. The company monitored locations of individuals by taking readings from a device that the individuals wear. Readings were taken repeatedly, tracking items such as whether the wearer had interfered with the device, where the wearer was located, and whether the device was operating correctly. The specifics on the table structure and exactly what data was stored were never released. But we could gather pieces of information based on press releases that show the design included an identity column. We could also discern that multiple rows were being inserted into this table for each individual that wore the aforementioned device. The information tends to point to a table design that looks like this:

This is an excerpt from Manning's book SQL Server MVP Deep Dives.
Itzik Ben-Gan is a Mentor and Co-Founder of Solid Quality Mentors. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning, and Programming. Itzik is the author of several books, including Microsoft SQL Server 2008: T-SQL Fundamentals, Inside Microsoft SQL Server 2008: T-SQL Querying, and Inside Microsoft SQL Server 2008: T-SQL Programming. He has written many articles for SQL Server Magazine as well as articles and white papers for MSDN. Itzik’s speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and Solid Quality Mentors’ events, to name a few. Itzik is the author of Solid Quality Mentors’ Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.