Local Area Networks: tracking the physical layer via a web database

Public Deposited
Analytics

Downloadable Content

Download PDF
Request Version for Screen Reader
Last Modified
  • February 28, 2019
Creator
  • King, L. Scott
    • Affiliation: School of Information and Library Science
Abstract
  • This project analyzes the computer networking information system at the Kenan-Flagler Business School (KFBS) at the University of North Carolina at Chapel Hill. The goal of this project is to optimize the information system in order to facilitate network troubleshooting and network provisioning. The Local Area Network at KFBS is comprised of over 100 Ethernet network switches and provides data network connectivity to over 2500 data ports and 2000 users. The purpose of a network information system is to track the various components of the system, which include items such as client IP addresses, data ports, room numbers, usernames, switch IP addresses, switch ports, telecommunication closets, MAC addresses, and computer names. The current system used to track and administer the computer data network at KFBS is incomplete and ineffective, mainly because it uses several sources to store the data. These sources include a DHCP database containing limited information such as IP addresses, usernames, and MAC addresses and several additional spreadsheets. This project proposes a single relational database management system to replace the current system. A comprehensive database is designed in Microsoft Access and a detailed discussion of the development process includes an entity relationship diagram, database schema, and data dictionary. Lastly, a password-protected Web interface is designed and implemented in Cold Fusion. This database-driven Web site provides simple, secure access to dynamic and searchable network information via the Internet.
Date of publication
Subject
DOI
Resource type
Rights statement
  • In Copyright
Advisor
  • Newby, Gregory B.
Degree granting institution
  • University of North Carolina at Chapel Hill
Language
Extent
  • 47 p.
Access right
  • Open access
Date uploaded
  • December 10, 2010

Relations

Parents:

This work has no parents.

Items

Thumbnail Title Date Uploaded Visibility Actions
file details Local Area Networks: tracking the physical layer via a web database 2019-05-13 Public Download