What types of future payment products and services should be anticipated and prepared for by the EA group? What is your vision of how payments might work? If you were advising the CIO of American Express, what would you suggest his group prepare for?

/0 Comments/in /by

What types of future payment products and services should be anticipated and prepared for by the EA group? What is your vision of how payments might work? If you were advising the CIO of American Express, what would you suggest his group prepare for?

Your industrial supply company wants to create a data warehouse where management can obtain a single corporate-wide view of critical sales information to identify bestselling products, key customers, and sales trends. Your sales and product information are stored in two different systems: a divisional sales system running on a UNIX server and a corporate sales system running on an IBM mainframe. You would like to create a single standard format that consolidates these data from both systems. 1. Identify the primary key of MPD. Sales table. (10 points)

/0 Comments/in /by

Your industrial supply company wants to create a data warehouse where management can obtain a single corporate-wide view of critical sales information to identify bestselling products, key customers, and sales trends. Your sales and product information are stored in two different systems: a divisional sales system running on a UNIX server and a corporate sales system running on an IBM mainframe. You would like to create a single standard format that consolidates these data from both systems.

1. Identify the primary key of MPD. Sales table. (10 points)

2. Using Figure 5.10 in your text as an example, create a SQL Select Query to pull Product_ID, Product_Description and Units_Sold for Product 85773 from the CSS.Sales table. Hint: do not use the CSS prefix in your query. (10 points)

3. Identify the data problems that must be resolved as you determine the system of record for each of the attributes in the proposed data warehouse. Who should make those decisions, the database specialist or the business manager leading this data warehouse project? Why? (10 points)

4. What business problems are created by having two disparate sales systems? (10 points)

5. List and describe how each of the five business intelligence reports covered in section 10.2 of your text will leverage the information below to provide actionable information. (10 points)

After reading the Video Case file for this module, answer both of the following questions: 1. What is a data warehouse and why is REI building one? 2. What are some of the risks or concerns surrounding the creation of a data warehouse?

/0 Comments/in /by

After reading the Video Case file for this module, answer both of the following questions:

1. What is a data warehouse and why is REI building one?

2. What are some of the risks or concerns surrounding the creation of a data warehouse?

Your response should be in a Word document at least one page long, double-spaced and following APA guidelines for formatting and references. A cover page is not required, but be sure that your name is in the header of the document. Attach your completed assignment to this content area.

o IBM DB2 Data Warehousing – REI

o EMIS10_CH05_Case2_DataWarehousingREI.pdf

You are the administrator of a large network.You would like to make a change that allows users to type one word into their web browsers to access a web site. For example, instead of typing , users could just type . how is this accomplished for the example given? 


/0 Comments/in /by

You are the administrator of a large

network.You would like to make a change that allows users to type one word into their

web browsers to access a web site. For example, instead of typing , users could just type .

how is this accomplished for the example given? 


2. What is the sequence in which domain names are resolved on a Windows machine? 


3. Entering the command will provide you with what information about the IP address? 


Use these key terms from the labs to complete the sentences that follow: Address Resolution Protocol (ARP) – ARP cache – cat – Domain Name System (DNS) -Dynamic Host Configuration Protocol (DHCP) – Gateway- host address – ifconfig – Internet Control Message Protocol (ICMP) – Internet Protocol (IP) – Ipconfig- Media Access Control (MAC) address – network address – ping (Packet Internet Groper) – resolv.conf – subnet mask time to live (TTL)- Transmission Control Protocol/Internet Protocol (TCP/IP) 1. The letters IP stand for ____________.

/0 Comments/in /by

Use these key terms from the labs to complete the sentences that follow:

Address Resolution Protocol (ARP) – ARP cache – cat – Domain Name System (DNS) -Dynamic

Host Configuration Protocol (DHCP) – Gateway- host address – ifconfig – Internet Control

Message Protocol (ICMP) – Internet Protocol (IP) – Ipconfig- Media Access Control (MAC)

address – network address – ping (Packet Internet Groper) – resolv.conf – subnet mask time to

live (TTL)- Transmission Control Protocol/Internet Protocol (TCP/IP)

1. The letters IP stand for ____________.

2. The ____________________ is the physical address of your network interface card that was

assigned by the company that made the card.

3. ipconfig /renew will renew an IP address obtained from the ____________________ server.

4. The four items needed to connect a machine to the Internet are the ____________________

address, the ____________________ address, the ____________________, and the

____________________ address.

5. The ____________________ is used to separate the host address and network address from

an IP address.

6. ____________________ is the file that contains DNS server addresses in Linux.

7. The ____________________ command is used to display the contents of text files in Linux.

8. The command used in this lab to test network connectivity is ____________________.

1. You have been called in to troubleshoot a client’s computer, which is unable to connect to the local area network. What command would you use to check the configuration? What information would you look for?

/0 Comments/in /by

1. You have been called in to troubleshoot a client’s computer, which is unable to connect to the

local area network. What command would you use to check the configuration? What information

would you look for?

I will use ipconfig command and look to the IP addresses to making sure that the network part in

the IP addressees are same

2. You have been called in to troubleshoot a client’s computer, which is able to connect to the

local area network but unable to connect to any other network. What command would you use to

check the configuration? What information would you look for?

3. If you needed to obtain a user’s MAC address as well as the user’s network configuration

information, what command and switch would you enter?

4. To use the Windows GUI utility to adjust IP settings, including DNS and gateway

information, what steps would you take?

5. You have just pinged a remote computer. You would now like to retrieve the MAC address of

the remote computer locally. How would you obtain the remote computer’s MAC address?

6. You are about to run some network traffic analysis tests. You need to clear your ARP cache.

How would you go about performing this task (for Windows and Linux)?

7. What information does ping return to the user?

8. How does a computer ensure that the replies it gets from an ARP broadcast are correct?