Ask DBMS Expert


Home >> DBMS

Assessment

Instructions:

This is a group assignment and all students are expected to contribute evenly. A peer review form must be signed by each student indicating the contribution percentage.

THE SCENARIO

The XYZ is a new retail company with its Head Quarters building in the city, and with branches in Strathfield, North Sydney and Parramatta. In addition there are two small home offices in Hornsby and Penrith. There are WAN connections between each site and Head Office, with all Internet access through the Head Office site.

The XYZ company is planning a restructuring of its network to allow for an expected 100% expansion over the next 5 years. Whilst the numbers of sites are expected to remain the same, the number of employees, and so end computing devices, is expected to double. However, the server farm, currently 4 servers, is expected to be adequate for the foreseeable future.

REQUIREMENTS

You must design the network requirements for the XYZ company. As the network consultant you will be required to develop a plan for the company network, including all costs, for all of the following:

1. The type of media you propose to use. This must be adequate to allow for a 100% expansion of the company network within 5 years, and must be sufficient for all bandwidth requirements for each company site. It should also be sufficient for increased bandwidth needs in the future. Whilst the actual lengths of media chosen are not required, the cost of media chosen should be included as a cost per metre price. You must justify your choice of media. Remember this might include copper, fibre and wireless options. The serial links between each site will be supplied by the company's ISP and are therefore not to be included in the above media requirements.

2. You are required to subnet the company's network IP Address as appropriate. You will be required to provide summary tables with IP Address ranges for all hosts in your network. When allocating addresses you must allow enough addresses for the 100% expected future expansion of hosts for the. As well, you need to allocate one (1) printer per site. Printers will have the last usable address for the subnet to which they belong. The servers will be located in a separate subnet, and must be allocated static IP Addresses within that network. The number of servers is not expected to grow.

3. You must detail the hardware (bridges, switches, routers) that the XYZ company will require. This must include full reasons for selecting particular hardware, which must be adequate for the XYZ company requirements. Again, consideration must be made with regard to future expansion and bandwidth requirements. The details about computers, servers and printers are not required.

4. You must justify the type of network topology you propose to use at each XYZ company location. A topology diagram for each location should be included in your report.

5. Communication on the Internet is essential. Select and fully justify the type of Internet access you propose to have for this company. This must be scalable to allow for future growth and needs.

IP Addressing

The XYZcompany has purchased the IP Address 200.100.48.0/22 from its ISP for addressing all hosts within its network. Subnet this IP Address to provide addresses for all required hosts. This addressing scheme should allow for the 100% expected growth. Complete the table below and add the required WAN links.

Subnet Name Subnet

Address Subnet

Mask Host Range of Addresses Broadcast Address

Head Office

Strathfield

North Sydney

Parramatta

Hornsby

Penrith

Server Network

WAN Links

Additional Information

1. Apart from the IP Addresses, you are not required to supply any WAN link information. This included serial cables, VPN connections, or any security issues relating to those links.

2. Number of hosts required for each site are as follows:

a. Head Office 120

b. Strathfield 60

c. North Sydney 35

d. Parramatta 20

e. Hornsby 10

f. Penrith 5

3. There will be a Server Network, with 4 Servers, for the entire Company. This will be situated in a separate LAN in the Head Office building. It is expected that the 4 servers will be sufficient for the next 5 years, and so will not be subject to the 100% growth requirement.

4. All branch offices and Home Offices can be considered an extension of the Head Office network, and so the IP Addresses allocated must be reflected in the overall addressing scheme for the company. The only media requirements required are those internal for each site.

5. Hardware (such as routers and switches) should reflect expected usage. Therefore, low usage environments such as those for the Home Offices, would require different hardware than high usage areas, such as those of the Head Office.

6. Internet Access for the entire company, the Point of Presence (POP), is through the Head Office. This connection should be sufficient for all current users, and scalable to allow for the expected increase over the next 5 years.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91615575

Have any Question?


Related Questions in DBMS

Data mining assignment -in this assignment you are asked to

Data Mining Assignment - In this assignment you are asked to explore the use of neural networks for classification and numeric prediction. You are also asked to carry out a data mining investigation on a real-world data ...

Sql query assignment -for this assignment you are to write

SQL Query Assignment - For this assignment you are to write your answers in a word document. This assignment is in three parts: Part A (reporting queries), Part B (query performance), Part C (query design). For this assi ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

Objectivethe objective of this lab is to be familiar with a

OBJECTIVE: The objective of this lab is to be familiar with a process in big data modeling. You're required to produce three big data models using the MS PowerPoint software. This tool is available on UMUC Virtual Deskto ...

The relation memberstudentid organizationid roleid stores

The relation Member(StudentId, OrganizationId, RoleId) stores the membership information of student joining organization. For example, ('S1', 'O2', 'R3') indicates that student with Id 'S1' joined the organization with i ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Relational database design a given the following business

Relational Database Design A) Given the following business rules, identify entity types, attributes (at least two attributes for each entity, including the primary key) and relationships, and then draw an Entity-Relation ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As