You have been assigned to develop a data warehouse for a credit card company.The data source for
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Auditing a business risk appraoch
ISBN: 978-0324375589
6th Edition
Authors: larry e. rittenberg, bradley j. schwieger, karla m. johnston
Posted Date: