SQLite will assume an explicitly named integer primary key is just an alias for the rowid if the type is spelled out as "INTEGER" rather than "INT." I can simply change my create table statement as ...

Learn how to add and remove Primary Keys from an Access database table. The primary key's purpose is to promptly associate data from multiple tables and combine that data.

SQL (Structured Query Language) is a programming language used to communicate with and manipulate databases. Learn its history and when to use it.

When working on a multidimensional design, every fact table within scope should be handled with care. In an ideal world, each low-level fact table represents the metrics related to a business event.