MIS 450 CSU Database and Data Warehouse Creation Project OPTION #1: DATABASE AND DATA WAREHOUSE CREATION AND DATABASE CONNECTIONS Select this option if yo

MIS 450 CSU Database and Data Warehouse Creation Project OPTION #1: DATABASE AND DATA WAREHOUSE CREATION AND DATABASE CONNECTIONS

Select this option if you have decided to complete Option 1 for the Portfolio Project.The purpose of this assignment is to introduce you to the technologies and processes needed to complete your Portfolio milestone and final project.

There are three parts to this assignment:

Create a new database and new data warehouse in PostgreSQL.
Establish database connections between the Jigsaw Operational Database and Jigsaw Data Warehouse.
Write a brief paper explaining key learnings and how they impacted your plan created in the Portfolio Project milestone for Module 3.

Note: See link at the bottom of the page to access the instructions.

Assignment Deliverables:

Output screenshots from each transformation
A paper describing key learnings from each of the major steps (database creation, database population, and ETL transformations), and how these learnings impacted your plan created in the Portfolio milestone for Module 3

Your paper must meet the following requirements:

Be 2-3 pages in length, not including the cover and references pages.
Follow the CSU-Global Guide to Writing & APA (Links to an external site.). Your paper should include an introduction, a body with at least two fully developed paragraphs, and a conclusion.
Be clearly and well written using excellent grammar and style techniques. Be concise and logical. You are being graded, in part, on the quality of your writing. If you need assistance with your writing style, you can find many writing resources in the CSU-Global Writing Center (Links to an external site.).
Be supported with at least two peer-reviewed, scholarly references. The CSU-Global Library (Links to an external site.) is a great place to find these resources.

ALL needed sql files are in the attached zip file