Beginning with Blackboard Learn 9.1 Service Pack 1, Blackboard enabled a Building Block (B2) to create database tables in the Blackboard Learn schema and insert records into those tables when the Building Block is deployed to the Blackboard Learn application server (ref. 1). This makes it simpler for B2 applications that need to store data in database tables, especially if those tables should contain foreign keys to other Blackboard tables.
The documentation available on how to setup a Building Block so it creates the tables and inserts records into the tables is very limited (at least what I could find) and confusing. After I learned how to do this I thought a tutorial and example on how to have a B2 create tables and insert records that are part of the Blackboard Learn database schema would be useful for other B2 developers.