Implementing the sales_demo Dimensional Database

This section shows the SQL statements that you can use to create a dimensional database from the data model in Building a Dimensional Data Model. You can use interactive SQL to write the individual statements that create the database or you can run a script that automatically executes all the statements that you need to implement the database. The CREATE DATABASE and CREATE TABLE statements create the data model as tables in a database. After you create the database, you can use LOAD and INSERT statements to populate the tables.