Shared Flashcard Set

Details

Exam 2 - IT
Flashcards for IT Exam 2016
63
Computer Science
Undergraduate 3
11/09/2016

Additional Computer Science Flashcards

 


 

Cards

Term
data
Definition
unprocessed items, raw facts
Term
database
Definition
collection of data organized in a manner that allows access, retrieval, and use of data
Term
information
Definition
processed organized data
Term
a database
Definition
allows users to pick and choose to obtain information
Term
relational database
Definition
stores information about both the data and how it is related
Term
hierarchy of data
Definition
data - tables (data files) - records (rows) - fields (columns) - byte - Bit
Term
Metadata
Definition
data about data
Term
datatype
Definition
specifies the kind of data a field can contain and how the field is used. Ex: datatype is text, so it can only contain text/numeric characters
Term
primary keys
Definition
uniquely identifies each record in the table
Term
Foreign keys
Definition
a column/group of columns in a relational database table that provides a link between data in two tables
Term
relationships
Definition
between two database tables when one table has a foreign key that references the primary key of another table
Term
referential integrity
Definition
requires every value of on attribute (Column) of a relation (table) to exist as a value of another attribute (column) in a different or the same relation (Table)
Term
entity relationship diagram (ERD) data model
Definition
shows what will be in the database, relationships between entites
Term
entities
Definition
something we want to track. EX: peoples names, task name
Term
attributes
Definition
describes something in ways of elements, fields, files
Term
Computer network
Definition
a collection of computers and devices connected together via communications devices and transmission media.
Term
telecommunication medium
Definition
any material substance that carries an electronic signal to support communications between a sending and receiving device
Term
Network Protocols and why are they needed
Definition
sets of rules for exchanging information. Without protocols computers couldn't communicated efficiently over the internet
Term
wired (IEEE 802.3)
Definition
signals are guided along a solid medium
Term
Wireless (IEEE 802.11)
Definition
Signals are broadcast over airwaves as a form of electromagnetic radiation
Term
LAN
Definition
is a network that connects computers and devices in a limited geographical area.
Term
WAN
Definition
is a network that covers a large geographical area
Term
MAN
Definition
is a larger network that usually spans several buildings in the same city or town
Term
Network Architecture
Definition
the design of communication network. (Answer question on how data flows in a network)
Term
Server
Definition
sets rules of communication for network and provides every client with an address so others can find it on the network
Term
P2P (Peer to Peer)
Definition
an network on which users access each other’s hard disks and exchange files over the network
Term
Network Topology
Definition
the study of the arrangement or mapping of the elements (links, nodes, etc.) of a network.
Term
Ring (Topology network)
Definition
workstations/devices are looped together.
Pros: organized
Cons: If one goes down they all go down
Term
Bus Network
Definition
An arrangement in a local area network (LAN) in which each node (workstation or other device) is connected to a main cable or link called the bus. connected to a common backbone.
Pros: cheap to setup
Cons: security isn't good
Term
Tree network
Definition
joins multiple star topologies together onto a bus
Term
star
Definition
every node (computer workstation or any other peripheral) is connected to a central node.
Term
intranet
Definition
a network where employees can create content, communicate, collaborate, get stuff done, and develop the company culture.
Term
extranet
Definition
It connects parts of the intranets of different organizations and allows secure communications among business partners
Term
Important ISP functions
Definition
1. Provide a legitimate Internet address
2. Gateway to the Internet
3. Pay for the Internet by collecting money from customers and paying access fees and other charges to telecom
Term
T1 Carriers
Definition
the internet is built by T1 carriers. ex: AT&T, Verizon, etc
Cost about $1,000 a month
Term
T3 line
Definition
expensive. cost$3,000 a month. used to build the core of a business/headquarters.
Term
Packetswitching
Definition
has no fixed path is created between the communicating devices

Term
Circuitswitching
Definition
sets up a circuit between the sender and receiver before any communications can occur
i.e. phone call
Term
modem
Definition
is a telecommunications hardware device that converts communications signals so they can be transmitted over the communication media
Term
router
Definition
connects multiple computers or other routers together and transmits data to its correct destination on a network
Term
Hubs/Switches
Definition
A hub or switch connects several devices in a network together

Term
network interface card (NIC)
Definition
enables a computer or device to access a network
EX:
Term
The Domain Name System (DNS)
Definition
Converts IP addresses to domain names,
Hierarchical structure,
Top-level domains
Term
IPv4
Definition
32 - Bit. IP addresses are running out
Term
IPv6
Definition
128 - Bit. The internet is moving towards this. provides for many more devices.
Term
Private IP Addresses
Definition
Identify a particular device on a private network (www.jmu.edu/parking)
Term
Public IP Addresses
Definition
Identify a particular device on public Internet,
Public IP addresses must be unique, worldwide (www.jmu.edu)
Term
Channel bandwidth
Definition
refers to the rate at which data is exchanged
Term
A client/server system
Definition
is a network that connects a user’s computer (a client) to one or more host computers (servers)
Term
database application
Definition
is a collection of forms, reports, queries, and programs that process a database
Term
data model
Definition
describes the data and relationships that will be stored in a database
Term
WiMax
Definition
operates like WiFi, only over greater distances and at faster transmission speeds
Term
HTML
Definition
is the standard page description language for Web pages
Term
XML
Definition
A markup language designed to transport and store data on the Web
Term
database model
Definition
describes the data and relationships that will be stored in a database
Term
HTML
Definition
is the standard page description language for web pages
Term
XML
Definition
is a markup language designed to transport and store data on the web
Term
WiMax
Definition
operates like WiFi, only over greater distances and at faster transmission speeds
Term
The Web
Definition
consists of server and client software, the HTTP, standards, and markup languages that combine to deliver information and services over the internet.
Term
ARPANET
Definition
Ancestor of the Internet,
Project started by the U.S. Department of Defense (DoD) in 1969
Term
Web 2.0
Definition
the Web as a computing platform that supports software applications and the sharing of information among users
Term
File Transfer Protocol (FTP)
Definition
supports file transfers between a host and a remote computer
Term
VPN (virtual private network)
Definition
a secure connection between two points on the Internet
Supporting users have an ad free experience!