Routing is a fundamental function of a network. Routing is the process of selecting paths in a network along which to send network traffic. In many ways, routing is analogous to the postal mail delivery. The routing on the Internet and many other computer networks is based on IP addresses, although routing could use other information such as services. Assume that you are the designer of a new network scheme that does not depend on the current TCP/IP protocols.

Post the following to the Discussion Board:

What information do you think is best used for routing? Explain.

Since each computer has a Media Access Control (MAC) address for its network interface, what would be the biggest downside to using the computer’s MAC address for routing?

What is the most significant benefit to using IP addresses for routing? What is the primary technical goal you could meet because of this benefit?

Assignment: this due in 3days

A topology is a high-level blueprint of the network. It is a map that indicates network segments, interconnection points, and user communities. Its purpose is to show the logical organization of the network, not its physical geography or technical implementation. It depicts where routing and switching will occur and where security policies are to be applied. As a result, the topology is often different from the geographical map of sites. A network topology is normally derived from the network technical requirements. In this Application, you will further refine the network design you started the previous week. The following represents the network’s technical requirements:

Separate the subnets for the control office and for the stadium. Give each subnet its own separate IP address.

The two subnets are connected with the campus network.

There are different terminal devices: Console (computer), video cameras, temperature sensors, and mobile handsets.

The network requires both wired and wireless (WiFi) media technologies.

Submit a 2–3-page paper that includes the following:

Describe the two types of topology models covered in your readings in this week.

Evaluate each model by examining the advantages and disadvantages of each.

Select the model you believe is the best fit for these technical requirements and explain how your choice satisfies the technical requirements.

Create a network topology diagram for the Sports Management Division’s network that uses the model you selected. Include this as an appendix to your paper.

Show the layering and IP addressing allocation. Be sure to have the WiFi network represented.

To get credit for this assignment:

1. Your TA should be able to open your file by clicking on its link.

1. Requirements:Excel TablesThe Orders worksheet shows orders from a SuperStore. Some research needs tobe done to locate a group of information.
   1. Convert the Orders dataset into an Excel Table (remember you only need to selectone cell to create excel table)
   2. Then, locate the records of the Orders dataset that comply with all thefollowing characteristics:
      1. City is San Antonio or Chicago.
      2. Segment is Consumer.
   3. Format the Sales and Profit to be currency ($)
   4. Enter customer (or customers) name with the most distinct product ids from thisPage 1 of 2

filtered set into cell A306

1. E Add a Total row and use the properties of the Total Row to calculate:
   1. the sum of quantity.
   2. the sum of profit.
2. F Apply the Blue, Table Style Medium 9 to the table.

Pivot Tables and Pivot Charts

Pivot Table 1 :

1. Use the Orders worksheet and create a Pivot Table on new worksheet with afilter on Category, row of Sub-Category, and sum of Quantity, Sum of Sales,Sum of Profit
2. Filter the information so that only “Furniture” is displayed.
3. Which sub-category of Furniture has the most sales revenue? Answer in cell J1 ofthis sheet.
4. Format the Sum of Sales and Profit column to be currency ($)
5. Rename the PivotTable’s worksheet: Pivot Table 1.

Pivot Table 2 & Pivot Chart:

1. Use the West Coast Coffee worksheet and create another Pivot Table thatdisplays the average of Sales $ organized by: Month and Product as row labels(in that order) and State as column labels. Format all sales numbers as currency($)
2. In cell J1 of this sheet put in the state that has the lowest average coffee sales $
3. In cell J2, for the state with the most coffee sales ($)(Be careful, this means youneed the sum of sales), what is the highest sales ($) month?
4. Collapse the Product rows and create a 3D Clustered Column Pivot Chart.
5. Apply Chart Style 5 and Quick Layout 3.
6. Enter as Title of the Chart: Average Sales Totals.
7. Rename the PivotTable’s worksheet: Pivot Table 2.
8. Move the Pivot Chart to its own worksheet. Rename this new worksheet asPivot Chart.

Choose one of the data warehousing / data mart dimensional models listed below. Copy the data model into a MS Word document. In your MS Word document. (You can copy the data model graphic by right-clicking on it. On PCs, the keyboard combination of ctrl-V is the shortcut command for pasting.)

In the MS Word document,

1) identify the fact table 

2) identify the dimension tables, 

3) for each dimension table, identify the attribute(s) that would be matched to an attribute in the fact table, and 

4) list four queries that could be produced from this data model. For example, the queries from a data model of real estate sales that could typically be produced by matching a fact table to one or more dimension tables include: a) list of properties sold by each real estate agent, b) total properties sold by state, c) types of properties sold by month and year, d) dollar value of properties sold by each real estate company, e) total homes sold by real estate agent by company by year.

• DataMart for FX Deals (Links to an external site.)
• Insurance Data Warehouse / Dimensional Model (Links to an external site.)
• Dimensional Model for Logistics & Shipments (Links to an external site.)
• Star Schema Dimensional Data Model (Links to an external site.)
• Advertising Dimensional Model (Links to an external site.)
• A Retail Bank Dimensional Model (Links to an external site.)
• Dimensional Data Model for eCommerce (Links to an external site.)
• A Dimensional Model for Activity-Based Costing (Links to an external site.)
• Investment Banking Model (Links to an external site.)
• Dimensional Data Model for Logistics (Links to an external site.)

Design the data warehouse for Restaurants ABC

Restaurants ABC restaurant company supplies equipment to 55 different restaurants in 20 cities across US. They have 2 product lines: front of house equipment and kitchen equipment. For front of house equipment, they have products such as tables, chairs, tablecloths, napkin holders, cutlery and so on. For kitchen equipment, they have products such as saucepans, knives and chef clothing.

An operational database is used to support day-to-day operation. In the operational database, they record the following data:

For each customer, they record data such as Customer Name, Contact No, City and State.

For each product, they record data such as Product Name, Product Line. A product line contains many products.

For each transaction, they record data such as Order Date, Customer Name, Product Names, Sales, Cost, Profit, Salesperson Name. A transaction may contain many products.

For each Salesperson, they record data such as Salesperson Name, YearsWithABC, Department. A department has many salespersons.

Now they wish to construct a data warehouse and BI solution to help them analyze the performance in terms of sales, cost and profit. The data will be extracted from the operational database, transformed and loaded to the data warehouse. Your task is to design the structure of the data warehouse to meet the following requirements.

They wish to analyze the sales, cost, and profit by product and customer. They also would like to analyze the sales, cost and profit ratio by product line and time period (day, month, year). Last, they also wish to analyze the sales, cost and profit ratio by city and state. They also need to analyze the sales, cost, and profit by salesperson.

Questions:

What are the facts/measures in this case? How many dimension tables do we need in the data warehouse?

Design the fact table and dimension tables. Use a star schema.

1. What is the grain of the fact table?
2. Convert the star schema to a snowflake schema by normalizing the product table.
3. Your Turn:
4. Based on the current snowflake schema, further normalize the salesperson table.

Assignments:
In the research assignment, you have to research and prepare a presentation on one cybersecurity tool of your choice from the provided list:

– Antiviruses:
a. Norton Security
b. Windows Defender
c. ESET NOD32 Antivirus
d. Kaspersky Antivirus

– Firewalls:
a. Windows Firewall
b. ZoneAlarm

Assignment Description:

?? Please read the instructions carefully, especially the underlined

In this assessment component you have to study, research, prepare a tutorial, and present to the class ??((one topic))?? of your choice. Your presentation should include the analysis and a tutorial on a specified tool. In your presentation, only a few slides and a few minutes should be spent on a general discussion with the most time devoted to a particular tool tutorial. Try to include a short tool’s demo into your presentation too. It is better if the tutorial and the presentation contain a few practical examples, which usually help to make the presentation content more demonstrative, interesting, entertaining, and easy for understanding.
In the presentation, it is important to emphasize your analysis and conclusions. Do not forget to add references to the sources

OUTLINE FOR A PRESENTATION:

1. Introduction.
a. What is this talk about?
b. Why does it matter? What applications does it have or might
have?
c. What will you cover? (Show a short outline of the talk)
d. What is the connection to other topics in this course

e. Discuss the tool’s advantages and disadvantages,
2. References.
a. What did you read or study?
b. Where did you find it?
3. Main topic. Tell about this subject in some depth. This is the longest
part of the talk. If you provide a tool demonstration, it should go here.
4. Analysis.
a. What do other experts think about this?
b. What do you think and why?