Data Warehouse Project Essay Dissertation Help

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 consisting of four tables as specified below:
Account
Account Type
Interest Rate
Credit Limit
Minimum 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 following using Microsoft® SQL Server® 2014:
Write SQL scripts in Microsoft® SQL Server® for OLTP that includes:
A Data Definition Language (DDL) script creating the four tables with appropriate data types, primary and foreign keys.
Data Manipulation Language (DML) scripts that inserts a minimum of five records into each table.
Select scripts showing 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 PowerPoint® presentation that includes the SQL scripts in Microsoft® SQL Server, test script, and screenshots.
Submit your presentation to the Assignment Files tab.

find the cost of your paper

The question first appeared on Write My Essay

The post Data Warehouse Project Essay Dissertation Help appeared first on Write my Essay | I need help with my School Assignment.

 
Looking for solution of this Assignment?

WHY CHOOSE US?

We deliver quality original papers

Our experts write quality original papers using academic databases.  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay