"> (Answered) Complete the following steps:
1

Question Details

(Answered) Complete the following steps:

Brief item decscription

Question: 

Use the credit card database from the Week One Individual

Assignment, "Data Warehouse Project, Part I," as a basis for the creation of a data warehouse.

Complete the following steps:

  1. Define the business requirements, objectives, and deliverables.
  2. Declare the grain.
  3. Choose dimensions.
  4. Identify fact duration
  5. Identify facts.

Technical Design of Document that includes a description of the five steps above and the results of completing the steps for the credit card data warehouse


Item details:

 

 

 

 

 

 

 

 

1

 

2

 

3

 

4

 

5

 

6

 

7

 

8

 

9

 

10

 

11

 

12

 

13

 

14

 

15

 

16

 

17

 

18

 

19

 

20

 

21

 

22

 

23

 

24

 

25

 

26

 

27

 

28

 

29

 

30

 

31

 

32

 

33

 

34

 

35

 

36

 

37

 

38

 

39

 

40

 

41

 

42

 

43

 

44

 

45

 

46

 

47

 

48

 

49

 

50

 

51

 

52

 

53

 

54

 

55

 

56

 

57

 

58

 

59

 

60

 

61

 

62

 

63

 

64

 

65

 

66

 

67

 

68

 

69

 

70

 

71

 

72

 

73

 

74

 

75

 

76

 

 

 

--Create Customer table

 

CREATE TABLE "CUSTOMER" (

 

  "CUSTOMERID" BIGINT PRIMARY KEY,

 

  "CUSTOMERNAME" VARCHAR(1000) NOT NULL,

 

  "DATEOFBIRTH" DATETIME NOT NULL,

 

  "GENDER" VARCHAR(1000) NOT NULL,

 

  "FICOSCORE" BIGINT NOT NULL

 

);

 

 

 

--Create Table VENDOR

 

CREATE TABLE "VENDOR" (

 

  "VENDORID" BIGINT PRIMARY KEY,

 

  "VENDORNAME" VARCHAR(1000 ) NOT NULL,

 

  "VENDORTYPE" VARCHAR(1000 ) NOT NULL,

 

  "VENDORADDRESS" VARCHAR(1000 ) NOT NULL,

 

  "VENDORPHONE" VARCHAR(1000 ) NOT NULL

 

);

 

 

 

--Create Table Account

 

CREATE TABLE "ACCOUNT" (

 

  "ACCOUNTID" BIGINT PRIMARY KEY,

 

  "ACCOUNTTYPE" VARCHAR(1000 ) NOT NULL,

 

  "INTERESTRATE" DECIMAL(12, 2) NOT NULL,

 

  "CREDITLIMIT" BIGINT NOT NULL,

 

  "MINIMUMPAYMENT" BIGINT NOT NULL,

 

  "AMOUNTDUE" BIGINT NOT NULL,

 

  "LASTPAYMENTAMOUNT" BIGINT NOT NULL,

 

  "DATEACCOUNTOPENED" DATETIME NOT NULL,

 

  "DATEACCOUNTCLOSED" DATETIME NOT NULL,

 

  "CUSTOMERID" BIGINT NOT NULL,

 

  "VENDORID" BIGINT NOT NULL

 

);

 

ALTER TABLE "ACCOUNT" ADD CONSTRAINT "FK_ACCOUNT__CUSTOMERID" FOREIGN KEY ("CUSTOMERID") REFERENCES "CUSTOMER" ("CUSTOMERID");

 

 

 

ALTER TABLE "ACCOUNT" ADD CONSTRAINT "FK_ACCOUNT__VENDORID" FOREIGN KEY ("VENDORID") REFERENCES "VENDOR" ("VENDORID");

 

 

 

--Create Table TRANSACTION

 

CREATE TABLE "TRANSACTION" (

 

  "TRANSACTIONID" BIGINT PRIMARY KEY,

 

  "DATE" DATETIME NOT NULL,

 

  "TIME" VARCHAR(30)  NOT NULL,

 

  "AMOUNT" BIGINT NOT NULL,

 

  "AUTHORIZATIONCODE" VARCHAR(1000 ) NOT NULL,

 

  "ACCOUNTID" BIGINT NOT NULL

 

);

 

 

 

ALTER TABLE "TRANSACTION" ADD CONSTRAINT "FK_TRANSACTION__ACCOUNTID" FOREIGN KEY ("ACCOUNTID") REFERENCES "ACCOUNT" ("ACCOUNTID");

 

 

 

 

 

--Insert into Customer Table

 

insert into CUSTOMER values(1,'David','12-Aug-1989','Male',69);

 

insert into CUSTOMER values(2,'Joe','12-Mar-1989','Female',45);

 

insert into CUSTOMER values(3,'John','13-Aug-1989','Male',80);

 

insert into CUSTOMER values(4,'Smith','15-Aug-1989','Male',90);

 

insert into CUSTOMER values(5,'Harry','12-Jun-1989','Male',69);

 

 

 

--Insert into VENDOR Table

 

insert into VENDOR values(101,'David Smith','HDFC','12-Havelock, UK','12456789');

 

insert into VENDOR values(201,'Martin Smith','ICICI','24- Birhana, UK','12456799');

 

insert into VENDOR values(301,'LO Jack','SBI','13-South wales, UK','12456779');

 

insert into VENDOR values(401,'Sithia','RBS','134-South wales, UK','12456709');

 

insert into VENDOR values(501,'Fresar','RBI','136-South wales, UK','12789789');

 

 

 

--Insert into Account Table

 

insert into Account values(1,'Saving',12,300000,12000,2000,3000,'12-Mar-2001','13-Mar-2017',1,101);

 

insert into Account values(2,'Current',13,350000,14000,7000,8000,'14-Jun-2001','16-Jun-2017',2,201);

 

insert into Account values(3,'Saving',7.5,200000,15000,6000,9000,'12-May-2001','12-May-2017',3,301);

 

insert into Account values(4,'Current',6,280000,16000,5000,6000,'13-Aug-2001','18-Mar-2017',4,401);

 

insert into Account values(5,'Saving',12,370000,17000,4000,5000,'12-Dec-2001','16-Dec-2017',5,501);

 

 

 

--Insert into Transaction Table

 

insert into Transaction values(1,'12-Mar-2001',to_dsinterval('0 07:39:33'),2000,'ARR001',1);

 

insert into Transaction values(2,'14-Mar-2001',to_dsinterval('0 07:40:33'),3000,'ARR002',2);

 

insert into Transaction values(3,'15-Mar-2001',to_dsinterval('0 07:50:33'),4000,'ARR003',3);

 

insert into Transaction values(4,'16-Mar-2001',to_dsinterval('0 07:46:33'),5000,'ARR004',4);

 

insert into Transaction values(5,'17-Mar-2001',to_dsinterval('0 07:29:33'),6000,'ARR005',5);

 

 

 







About this question:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Aug 28, 2019

PRICE: $50

Solution~000102736.zip (18.37 KB)

Buy this answer for only: $50

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.
SiteLock

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now
WP2Social Auto Publish Powered By : XYZScripts.com