Design for file based with many events
Looking at your table structure means that while the actual row is small (many int values) there will be millions of rows. 

Yes you can use a database of your choice, MySQL, Oracle, SQL Server, PostGres for the raw data from the cameras. 

You can add partitioning by day which will create a partition for each day, and you may want to consider archiving data on an annual basis into a separate table for each year to make the table sizes manageable. 

I would recommend that you setup another set of summary tables for reporting which can be based on the partitions, and this can be done on a daily basis (per partition) and automated.

The actual design of the summary tables depends on the reports you need to run, but it will be necessary so that your queries do not run off the base data table which will be huger.