MIS-589 Week 6 WANs, MANs, and the Internet - iLab

Week 6: WANs, MANs, and the Internet - iLab

iLab 4: Web Report

Connect to the iLab here.

Submit your assignment to the Dropbox located on the silver tab at the top of this page.

(See "Due Dates for Assignments & Exams" in the Syllabus for due dates.)

i L A B O V E R V I E W

Scenario/Summary

In this lab, you will be evaluating the performance of two traffic contracts. In your scenario, you are utilizing a small ATM network. The two contracts are CBR (constant bit rate) and ABR (available bit rate).

Deliverables

Item

Points

Step 1: Web Report (opening existing LAN Model) - Analysis of Simulation

10

Step 2: Screenshot

20

Total Points

30

i L A B S T E P S

STEP 1: Web Reporting (opening existing LAN Model)

For this lab, you will be working with an existing LAN model. First, you will need to download the your_initials_web_report.zip file from Doc Sharing. Unzip the file on your computer and extract it to a location on your computer. Remember where you extract this file; you will need to unzip the file and then be able to browse to the extracted folder and copy it to the Citrix server.

Next, log in to the citrix lab.

Now, locate the Windows Explorer program you will use to copy the web report you downloaded to the Citrix server.

When receiving the following plug-in prompt, be sure to select "Yes."

You will next need to browse for the location on your computer where you downloaded the web report. The drive that represents your computer should be similar to the C$ designated number 1 in the picture, and the folder you unzipped should be named as demonstrated below. Click on the folder so that it is highlighted as shown.

From the Edit menu, select the copy command (or press Ctrl + C).

Browse for the op_models directory on the F: drive server. The location should be similar to that shown in the picture. Click on op_models so it is selected (highlighted).

From the Edit menu, select paste (or Ctrl + V) to paste the web report to your op_models directory.

Start IT Guru 15 and open the project named your_initials_web_report from your op_net models directory. Below is a screenshot of what the folder structure might look like on Citrix.

Select the project your_initials_web_report.prj and click open.

Next save the project with your initials. Make sure this is in your op_models directory. The folder directory should be as shown below.

You should now have the web report saved in your op_model's directory and be ready to proceed to step 2, the web reporting analysis.

STEP 2: Web Reporting Analysis

The following tutorials will lead you through opening an existing network model (see step 2) and generating a web report that you can use to evaluate two traffic contracts.

Open the IT Guru 15tutorials Expand the tutorials link Expand the basic tutorials link Expand the Web Reporting link. In step 1, you have completed the getting started through step 5, which was to open and save the existing report to your op_models directory. Continue with finishing the rest of the web reporting tutorial (Overview, the rest of Getting Started, Specifying and Generating a Web Report, General Report Format, and Results by Node and Statistic).

STEP 3: Screenshot

After completing the IT Guru 15 Web Reporting tutorial, take a screenshot using Ctrl + prtsc or another screen capture utility. Arrange the screen so that all items can be seen. The screen should contain the following:

Main screen of the web report with the Top Nodes and Links -> By Node being displayed.

Click on image to enlarge.

Screenshot Example

Paste screenshot into a Word document.

Include in the Word document containing your screenshot of the web report your analysis on the two contracts:

What were the results for the FTP? What were the results for Voice? What conclusions might you reach from the web report?

Submit your completed Word document to the weekly iLabDropbox. For instructions on how to use the Dropbox, read these Step-by-Step Instructions or watch this Dropbox Tutorial.

See "Due Dates for Assignments & Exams" in the Syllabus for due date information.

MIS-589 Week 7 Quiz 100% Correct Answers

1.

Question :

(TCO E) _________ controls stop a person from acting.

Student Answer:

detective

mitigating

corrective

preventative

2.

Question :

(TCO E) A _________ is a situation in which a hacker attempts to disrupt the network by sending messages to the network that prevent normal users’ messages from being processed.

Student Answer:

denial-of-service attack

virus

spamming

man-in-the-middle attack

3.

Question :

(TCO E) Your organization has decided to host a web server that will be accessible by the public. Organizational leadership is concerned about the web server being compromised and thus allowing the remaining network to be compromised. You want to come up with a solution to host the secure the web server internally, but still protect your network. What should you do?

Student Answer:

use a firewall

put the web server on the DMZ

put the web server in front of the firewall.

chassis based switch

4.

Question :

(TCO F) The traditional network design approach does not work well for _________ networks.

Student Answer:

slowly evolving

rapidly growing

static

modestly growing

5.

Question :

(TCO F) Which of the following would not be a type of circuit that needs to be considered when planning for technology design capacity?

Student Answer:

1000 Mbps

Ethernet

10 Mbps

100 Mbps

6.

Question :

(TCO F) Which of the following are not costs that are generally considered during the cost assessment stage of the network design process?

Student Answer:

cost of advertising brochures for new products to be offered by an organization

internetworking devices cost

network management costs

circuit costs

7.

Question :

(TCO G) ____________ refers to keeping track of the operation of network circuits to make sure they are working properly.

Student Answer:

Network monitoring

Fault tolerance

Fault management

Firefighting

8.

Question :

(TCO G) _____________ is a simple method that can help identify computers/devices or communication circuits that have higher-than-average error or usage rates.

Student Answer:

Quality control charting

Quality of servicing

Service leveling

Electronic software distributing

9.

Question :

(TCO G) A __________ is an organizational department that is responsible for monitoring and fixing overall network problems.

Student Answer:

mission critical area

fault tolerance department

network operations center

mullion delimiter agency

10.

Question :

(TCO G) Service Level Agreements (SLA) are significant for what reason?

Student Answer:

they ensure that the network will stay up 100% of the time

they are contracts outlining exact type of performance and fault conditions acceptable

they create redundant network links

they exclude compensation that must be provided by service providers

MIS-589 Weeks 1-7 Homework Exercises

Week 1 - Homework

Textbook Questions and Mini Cases

These activities are found at the end of each chapter after the Summary section.

· Chapter 1: Questions 7, 14, and 17

· Chapter 2: Mini Case 1: Deal-R-Us Brokers (Part 1)

Week 2 - Homework

Textbook Questions and Mini Cases

These activities are found at the end of each chapter after the Summary section.

· Chapter 3: Questions 1, 3, and 6

Week 3 - Homework

Textbook Questions and Mini Cases

These activities are found at the end of each chapter after the Summary section.

· Chapter 4: Questions: 1, 10, and 26

· Chapter 4: Mini Case 1 – Smith, Smith, Smith, and Smith

Week 4 - Homework

Textbook Questions and Mini-Cases

These activities are found at the end of each chapter after the Summary section.

· Chapter 5: Questions 3, 4, and 8

· Chapter 5: Mini Case 2 - Central University

Week 5 - Homework

Textbook Questions and Mini-Cases

These activities are found at the end of each chapter after the Summary section.

· Chapter 7: Questions 3, 7, and 23

· Chapter 8: Exercises 8-3

Week 6 - Homework

Textbook Questions and Mini-Cases

These activities are found at the end of each chapter after the Summary section.

· Chapter 9: Questions 9, 19, and 29

· Chapter 10: Mini-Case 1 - Cathy's Collectibles

Week 7 - Homework

Textbook Questions and Mini Cases

These activities are found at the end of each chapter after the Summary section.

· Chapter 11: Mini Case 1 – Belmont State Bank

· Chapter 12: Mini Case 1 – Computer Dynamics

MIS-589 All 7 Weeks Discussions

w1 dq1 - Technology and Evolution

w1 dq2 - The Application Layer

w2 dq1 - LAN Topology

w2 dq2 - Communication Media

w3 dq1 - Media Access Control

w3 dq2 - Data Link Layer

w4 dq1 - IPv4 versus IPv6

w4 dq2 - Network and Transport Layer Protocols

w5 dq1 - Backbone Network Components

w5 dq2 - Wireless Local Area Networks

w6 dq1 - Internet Architecture

w6 dq2 - Comparing WAN Architectures

w7 dq1 - The Wild, Wild Web

w7 dq2 - Cost Justification

MIS 589 Final Exam

TCO A) Organization XYZ has just been granted access to the LAN of the ABC organization to access Web-based applications over the Internet. Organization ABC has established what type of access?

(TCO B) The ________________ is a WAN network that includes hundreds of thousands to millions of machines and users worldwide

(TCO B) Which of the following is considered a component of a network

(TCO C) Which is true about a network hub?

(TCO C) Hubs and switches also act as __________ to help prevent attenuation

(TCO D) A ___________ connect(s) two similar networks having the same network protocol and chooses the best route between two networks when there are multiple paths

(TCO D) In the case of Internet operation, a network access point is ______.

(TCO E) Your organization has been the victim of a recent DoS on one of your public websites. Your CIO wants this problem to have minimal impact on your organization in the future. What is the best technology to deploy to quickly detect and take action on a DoS attack once it starts

(TCO E) Your organization has decided to host a web server that will be accessible by the public. Organizational leadership is concerned about the web server being compromised and thus allowing the remaining network to be compromised. You want to come up with a solution to host and secure the Web server internally but still protect your network. What should you do

(TCO F) The building block design approach is sometimes called ______.

(TCO F) Your company is new and finally has acquired an operating facility. You are in change of designing the network. Organizational leadership has explained to you that they want a network that is simplistic, standardized, and that can be implemented in less than one year. What design option would best suit the needs of the organization

(TCO G) __________ policies attempt to allocate costs associated with a WAN or a mainframe to specific users

(TCO A) Discuss and describe three trends in communications and networking

(TCO B) Discuss and support your opinions of why combining voice and data is a major organizational challenge. Include your thoughts on its possible impacts on the organization in terms of competitive advantage, internal organization, and so forth

(TCO C) Switched Ethernet networks dominate the landscape of computer networks today. What improvements do Switched Ethernet networks have over its predecessor Shared Ethernet networks? Be specific and answer in details

(TCO C) What are the preferred technologies used in the three technology layers in backbone design? Describe each of the technologies in detail

(TCO D) What are the principal organizations responsible for Internet governance, and what do they do

(TCO E) Viruses and worms are issues that any networking professional must face. Compare and contrast viruses and worms. Be n

(TCO F) What are some major problems that can cause network designs to fail? Provide the problems in detail

(TCO G) The total cost of ownership (TCO) is a measure of how much it costs per year to keep one computer operating. TCO includes the cost of support staff to attach it to the network, install software, administer the network (e.g., create user ids, backup user data), provide training and technical support, and upgrade hardware and software. It also includes the cost of time “wasted” by the user when problems occur or when the user is attempting to learn new software.
Discuss in detail at least three approaches that can be used to reduce network costs

MIS 582 iLab 1 SQL Queries Using Access

iLab 1: SQL Queries Using Access

NOTE: Access 2010 is required for this project. Please ensure you can run Access

i L A B O V E R V I E W

Scenario and Summary

This week, you will learn to create and run SQL SELECT queries in the Access database. You will need to

download the Lab_1_SQL.accdb database from Doc Sharing and be able to run Access 2010, either through Citrix or installed on your workstation or laptop.

Deliverables

Rename the Lab_1_SQL.accdb database using your first initial, last name, and assignment number as the file name (e.g., JSmith1.accdb). Create and save your SQL queries in your database. When you are done, submit

i L A B S T E P S

STEP 1

Download the Lab_1_SQL.accdb database from Doc Sharing.

Rename the Lab_1_SQL.accdb database with the following naming convention: Lab1_FirstinitialLastname as the file name (e.g., Lab1_JSmith.accdb).

STEP 2

Using the data in the Student table in the database, create a SQL query to satisfy each of the tasks below.

Save each SQL query using the name associated with the task in the table below.

Name Task

Query1 Write a SQL statement to display Students' First and Last Name.

Query2

Write a SQL statement to display the Major of students with no duplications.

Do not display student names.

Query3

Write a SQL statement to display the First and Last Name of students who live

in the Zip code 88888.

Query4

Write a SQL statement to display the First and Last Name of students who live

in the Zip code 88888 and have the major of Biology.

Query5

Write a SQL statement to display the First and Last Name of students who live

in the Zip code 88888 or 88808. Do not use IN.

Query6

Write a SQL statement to display the First and Last Name of students who

have the major of Biology or Math. Use the SQL command IN.

Query7

Write a SQL statement to display the First and Last Name of students who

have the Status greater than 1 and less than 10. Use the SQL command

BETWEEN.

Query8

Write a SQL statement to display the First and Last Name of students who

have a last name that starts with an S.

Query9

Write a SQL statement to display the First and Last Name of students having

an a in the second position in their first names.

Query10

Write a SQL expression to display the Status and a sum of the Status of each

Status value as SumOfStatus. Group by Status and display the results in

descending order of SumOfStatus.

STEP 3

Upload the following files to the Week 1: Course Project Dropbox.

Lab1_FirstInitialLastName.accdb

Submit your assignment to the Dropbox located on the silver tab at the top

of this page.

(See Syllabus "Due Dates for Assignments & Exams" for due dates.)

Rubrics

Queries that are correct will be awarded the number of points shown below:

6 points: Query 1

7 points: Query 2 - Query 5

8 points: Query 6 - Query 9

9 points: Query 10

The following rubrics will be used for incorrect queries:

0 points: Query was not turned in with the assignment.

-5 points: Query would not run.

-4 points: Query runs but is incorrect because query required a Where clause to meet requirements which was not included.

-3 points: Query runs but is incorrect because Where clause contained errors, gives popup for user input, or only meets partial requirements.

MIS 582 iLab 2 Data Modeling Using Visio

iLab 2 :Data Modeling Using Visio (100 Points)

(See Syllabus "Due Dates for Assignments & Exams" for due dates.)

NOTE: Visio 2010 is required for this project. Please ensure you can run Visio 2010 via Citrix or by having it installed on your computer.

i L A B O V E R V I E W

Scenario and Summary

In this assignment, you will learn to create a physical database model in Visio from business requirements. To complete this assignment, you will need to be able to run Visio 2010, either through Citrix or installed on your workstation or laptop.

Deliverables

Name your Visio file using Lab2_, your first initial, and your last name (e.g., Lab2_JSmith.vsd). Create and save your database model in your Visio file.

i L A B S T E P S

STEP 1

Read the following business requirements closely to determine the entities and relationships needed to fulfill the requirements. The nouns in the paragraph will tell you the entities that will be needed. The verbs in the paragraph will help you determine the relationships between the entities.

Muscles Health Club Database Requirements:

The Muscles Health Club needs a database to keep track of its members, their personal trainers, and the fitness classes they are taking. Employees can act as personal trainers for members. However, only certified employees can act as personal trainers. A member can work with only one personal trainer at a time. Members can take multiple fitness classes. Fitness classes are taught by employees who can teach multiple classes. Fitness classes are taught in one of the classrooms at one of Muscles Health Club's several locations. Each fitness classroom is designed for a different type of class (e.g., spinning, aerobics, water aerobics, weight training, etc.). It is necessary to track what fitness classes are being held in each of the different Muscles Health Club locations.

STEP 2

# Run Visio 2010 either via Citrix or on your workstation.

# Click on the Software and Database Template group in the main window.

# Double-click on the Database Model Diagram Template to open a new file.

# Save the file with a name containing Lab2_, your first initial, and your last name as the file name (e.g., Lab2_JSmith.accdb). You will need to click the computer icon in the Save As window to see the different drives. Be sure to save the file to a local drive so it will be on your workstation.

STEP 3

Add an entity for each entity you identified in the requirements.

# Drag the entity icon onto the drawing area in Visio.

# In the Database Properties window, add a physical name to identify it.

STEP 4

For each entity, create a list of attributes you think would be useful to describe the entity.

# Select an entity in the drawing area of Visio.

# In the Database Properties window, select the Columns category.

# Use the table to add your attributes to the selected entities.

# Select one of the attributes to be the primary key (PK).

STEP 5

Set the diagram to use crow's feet notation.

# On the Database tab, in the Manage group, click Display Options.

# In the Database Document Option dialog, select the Relationship tab.

# Select the Crow's Feet check box, and then click OK.

STEP 6

Draw relationships between your entities.

# Drag the relationship icon onto a blank part of the drawing area.

# Connect the two ends to each of the two entities in the relationship. The parent entity must have a PK defined. The entity will be outlined in bold red lines when it connects to one end of the relationship.

STEP 7

Set the cardinality of your relationships.

# Select a relationship line in the drawing area that is connecting two entities.

# In the Database Properties window, select the miscellaneous category.

# Select the cardinality for the selected relationship.

STEP 8

When you are done, save the file on your local hard drive and upload it to the Course Project Drop box. Your file should have the following filename format: Lab2_FirstInitialLastName.vsd.

Submit your assignment to the Drop box located on the silver tab at the top of this page.

(See Syllabus "Due Dates for Assignments & Exams" for due dates.)

Grading Rubrics

Each query is worth 10 points. Points for each query will be awarded according to the following rubrics.

# 20 Points: Visio drawing: E-R model is provided as a Visio diagram.

# 20 Points: Entities: A minimum of four entities is present

# 20 Points: Attributes: There are more than two attributes per entity; in most cases there should be several.

# 20 Points: Relationships: A minimum of three relationships is present.

# 20 Points: Cardinality is specified on each relationship with crow's foot notation.