Assignment Details

Jan 4, 2016 12:05 AM

Yes

100.0

No

Yes

Part 1

Assignment Instructions

You should select a data storage problem of your interest and identify the various pieces of data that should be stored in a database. Then, in the actual Term Project, take it through the normalization process and design the actual database tables (see Assignment Term Paper for complete details of this).

You should submit your term project proposal in Week 5 for approval by the instructor and submit the completed work in the final week.

A go or no-go decision will be made for the term project subject area.

The Proposal for the Term Project, MS Word doc - 500 words minimum, should include:

1) Name and main idea of the project
2) Purpose and goal of the project
3) Possible users and administrators
4) How is this work being done now, without the database and how will the database specifically improve the process
5) Data elements to be involved: entities, attributes (identify at least 3 entities (tables) and 1 relationship you feel at this point should exist between two of those entities).
6) Platform to be used: what type of database. (i.e. Short term will use MS Access, for ease of use and prototyping but long term will switch to a more robust platform like MS SQL, or Oracle, or remain in MS Access)
7) Other related points

HINT: Review the examples on pages 4-7, consider subsets or smaller, simpler projects of your own that would require 3 tables and one relation between those tables. Keep your project contained and small – it does not need to be a project for a large company or for a large database. Three entities would be sufficient.

The submission must be a Word compatible file, attached to this assignment box.

 

Part 2

 

Topic: Transmission cabling and techniques-350words count

The foundation of LANs and all networks is the transmission medium. Transmission media fall into 3 categories: metallic, optical fiber and the open space. Metallic media are in 2 legacy types: coax and twisted pair, with a 3rd emerging type: powerline. Transmission media are characterized primarily by two factors: raw bandwidth (in Hertz), and noise/interference, which in turn determine the transmission capacity in bits/sec. Transmission capacity of a medium also depends on the  signaling technique (e.g., modulation) used to transmit the signal.  Discuss the evolution of transmission media up to now, and prediction of such evolution into the future, as the demand for bandwidth keeps rising.  Also explore signal handling techniques, such as modulation, OFDM, and MIMO, particularly used in wireless systems.   

 

 

Contribute a significant main post, and respond to two classmates at least. 

Complete this forum thread by Sunday of Week 6.

 

Forum Grading Criteria

 Forum Grading Criteria	Maximum Points
 Appropriate use of terms, correct spelling and grammar	 0.25
 Uses external resources validating position with applicable knowledge	 0.25
Participation in forum with well-formed answers and conclusions	 1.5
Posting to fellow classmates	 0.5
 Total Points:	 2.5