Data Warehouse Project

You have been assigned to develop a data warehouse for a credit card company. The data source for the data warehouse will be a relational database consistin" rel="nofollow">ing of four tables as specified below: Account Account Type Interest Rate Credit Limit Min" rel="nofollow">inimum Payment Credit Limit Amount Due Last Payment Amount Date Account Opened Date Account Closed Customer Customer Name Date of Birth Gender Fico Score Transaction Date Time Amount Authorization Code Vendor Vendor Name Vendor Type Vendor Address Vendor Phone Complete the followin" rel="nofollow">ing usin" rel="nofollow">ing Microsoft® SQL Server® 2014: Write SQL scripts in" rel="nofollow">in Microsoft® SQL Server® for OLTP that in" rel="nofollow">includes: A Data Defin" rel="nofollow">inition Language (DDL) script creatin" rel="nofollow">ing the four tables with appropriate data types, primary and foreign keys. Data Manipulation Language (DML) scripts that in" rel="nofollow">inserts a min" rel="nofollow">inimum of five records in" rel="nofollow">into each table. Select scripts showin" rel="nofollow">ing the full contents of each table. 2. Write and run a test script for Step Two. Save a screenshot of the results. Create a 6-slide PowerPoin" rel="nofollow">int® presentation that in" rel="nofollow">includes the SQL scripts in" rel="nofollow">in Microsoft® SQL Server, test script, and screenshots. Submit your presentation to the Assignment Files tab.