BIData 201A: Assignment 08: Create the Data Warehouse script and add it to your BI solution

Create the Data Warehouse (Due by class 9)

In this milestone, you need to create the Data Warehouse script and add it to your BI solution. The steps to do this covered in the 4th module of this class. 

·       Module 4: Building the Data Warehouse (Ch4 and 5)

You will need to turn in a SQL database creation script, and backup and restore script, and a database backup file, in addition to your previous files from Milestone 01; similar to the ones shown here:

NOTE: I recommend you start your ETL script directly after creating the database so that you will have a head start on Milestone 03. You have been warned!

Build the Data Warehouse

Below is the script I ran to build it

GO
CREATE DATABASE [DW_Project01] ON PRIMARY
( NAME = N'DWPubsSales'
, FILENAME = N'C:\BIData201B\Assignment08TimPauley\DatabaseBackup\DW_Project01.mdf'
, SIZE = 10MB
, MAXSIZE = 1GB
, FILEGROWTH = 10MB )
LOG ON
( NAME = N'DWPubsSales_log' ,
FILENAME = N'C:\BIData201B\Assignment08TimPauley\DatabaseBackup\DW_Project01_log.LDF'
, SIZE = 1MB
, MAXSIZE = 1GB
, FILEGROWTH = 10MB)
GO
EXEC [DW_Project01].dbo.sp_changedbowner @loginame = N'SA'
, @map = false
GO
ALTER DATABASE [DW_Project01] SET RECOVERY BULK_LOGGED
GO

Next I created the tables