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:

1. Account 
2. Account Type
3. Interest Rate
4. Credit Limit
5. Minimum Payment
6. Credit Limit
7. Amount Due
8. Last Payment Amount
9. Date Account Opened
10. Date Account Closed
11. Customer 
12. Customer Name
13. Date of Birth
14. Gender
15. Fico Score
16. Transaction 
17. Date
18. Time
19. Amount
20. Authorization Code
21. Vendor 
22. Vendor Name
23. Vendor Type
24. Vendor Address
25. Vendor Phone

Complete the following using Microsoft^® SQL Server^® 2014:

1. 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.

SophiaPretty

(5)

Status NEW Posted 23 Nov 2017 01:11 PM My Price 8.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer