IS exam 2

new information technology that first emerges in the consumer market spreads into business organizations

BYOD and its relationship with consumerization of IT

Client/server computing has extended computing to departments, workgroups, and other parts of business that could not be served by a centralized architecture

Client/Server computing (advantage over traditional centralized mainframe)

Grid computing

Connecting geographically remote computers into a single network to create a "virtual supercomputer" (SETI)

Cloud infrastructure as a service

Customers use processing, storage, and networking, and other computing resources from cloud service providers to run their information systems. ex.Amazon uses the spare capacity of its IT infrastructure to provide a broadly based cloud environment selling IT infrastructure services. storing customers' data and running their applications

Cloud software as a service

Customers use software hosted by the vendor on the vendor's cloud infrastructure and delivered over a network. ex. google apps

HTML 5

Enables multimedia embedding without 3rd party add-ons such as Flash

Word processing software (word) • Spreadsheet software (excel) • Data management software (Microsoft Access) • Presentation graphics (powerpoint) • Software suites (microsoft office) • Web browsers (internet firefox)

Examples of Application software

C C+ Visual Basic Java

Examples of programming languages

data mining

Finds hidden patterns and relationships in large databases and infers rules from them to predict future behavior

a key field

In a relational database _____ is used to uniquely identify each record for retrieval or maniplulation

an attribute or a field

In a relational database each column/table represents

a record

In a relational database each row represents

row

In a table for customers, the information about a single customer would reside in a single:

row

In the table for invoices, the information about a single invoice would reside in a single

Lan: up to half a mile, an office or building CAN: a college campus or corporate facility, a mile MAN: a city or metropolitan area WAN: A transcontinental or global area

LAN vs. CAN vs. MAN vs. WAN

HTML was originally designed to create and link static documents composed largely of text

Main purpose of the development of HTML

• Client computer • Server computer • Network interfaces • Connection medium • Network operating system(NOS) • Hub or switch

Major components of a computer network

Chrome, Android, iOS, Windows Phone

Mobile operating systems

Windows (Windows 8) Mac (OSX Lion) UNIX Linux (open source)

PC operating systems

more efficient use of network's communications capacity

Packet Switching (advantage over traditional circuit switching)

HTML

Page description language for specifying how elements are placed on a Web page and for creating links to other pages and objects

A public cloud is owned and maintained by a cloud service provider such as Amazon Web services and made available to the general public or industry group A private cloud is operated solely for an organization

Public vs. Private Cloud

each table should contain data on an entity and its attributes

Requirements of a table in a relational database

Mashups

Software applications that combine different components of online software applications are referred to as ex.Zip Realty uses GoogleMaps andZillow.com

DBMS

Specific type of software for creating,storing, organizing, and accessing data from a database

System software manages the resources and activities on the computer Application software is programs written for a specific application to perform functions specified by end users

System software vs. Application software

False

T/F A hub is networking device that connects network components and is used to filter and forward data to specified destinations on the network

False

T/F A network operating system must reside on a dedicated server computer in order to manage a network

True

T/F DBMS simplify how end users work with databases by separating the logical and physical views of the data

True

T/F Every record in a relation table should contain at least one key field

True

T/F In a client/server network, a network server provides every connected client with an address so it can be found by others on the network

False

T/F KiloBytes and Kilobits both measuring transmission speed and are equivalent to each other

VoIP

Technology delivers voice information in digital form using packet switching, avoiding the tolls charged by local and long-distance telephone networks.

One to many

The department entity and the college entity has a

a router

The device that forwards packets of data through different networks ensuring the data gets to the right address is called

Client/server computing Packet Switching and a set of communications standards for linking networks and computers

The internet is based on which 3 key technologies?

packet switching

The method of slicing digital messages into parcels transmitting them along different communications paths and reassembling them at their destinations is called

many to many

The patient entity and doctor entity has a

Normalization

The process of streamlining data to minimize redundancy and awkward many to many relationships is called

is to interpret java programming code for that machine

The role of Java Virtual Machine

operating system

The system software that manages and controls the computer's activities is called

True

Traditional telephone networks are fundamentally different from computer networks, but voice, video and data communications are increasingly being transmitted usinf internet technology

referential integrity

Used by relational databases to ensure that relationships between coupled tables remain consistent. • For example: when one table has a foreign key that points to another table, you may not add a record to the table with foreign key unless there is a corresponding record in the linked table.

On demand self-service Ubiquitous network access Location independent resource pooling Rapid elasticity Measured service

What are 5 characteristics of Cloud computing

Workstations has more powerful mathematical and graphics-processing capabilities than a PC (advanced design or engineering work) Servers computers are specifically optimized to support a computer network, enabling users to share files,software and peripheral devices, they provide hardware for mainframes is a large capacity high performance computer that can process large amounts of data very rapildy keeping track of hundreds of thousands or even millions of records and transactions

What are the differences between PC, workstation, mainframe, server

Application, transport, Internet, and network interface

What are the four layers of the TCP/IP reference model?

Computer Hardware Computer Software Data management technology Networking and telecommunications technology Technology services

What does IT infrastructure consist of?

difference between the highest and lowest frequencies that can be accommodated on a single channel.

What does bandwidth measure?

VMware

What is an example of virtualization

The entity Customer with the attributes Address

Which of the following best illustrates the relationship between entities and attributes?

The entity CUSTOMER with the attribute ADDRESS

Which of the following best illustrates the relationship between entity and attributes

Primary

Which of the following cannot contain duplicate values

Android

Which of the following is an open-source operating system designed for mobile devices?

Fiber-Optic Cable

Which of the following transmission media offers the fastest maximum transmission speed

Analog

Which signal types are represented by a continuous waveform? -Telephone line, cable system, wireless media, analog device

LAN

Which type of network is most suitable for the employees in the ISCS department at UTSA to exchange files?

database

a collection of related files containing records on people, places, or things.

ISP

a commercial organization with a permanent connection to the internet that sells temporary connections to retail subscribers

Modem

a device that translates digital signals into analog form (and vice versa) so that computers can transmit data over analog networks such as telephone and cable networks.

foreign key

a field that serves as the primary key in an associated table. can contain duplicated value

web services

a set of loosely coupled software components that exchange information with each other using universal web communication standards and languages

protocol

a set of rules and procedures governing transmission of information between two points in a network

Digital

binary WAVEFORM type signal -computer

The Domain Name System (DNS)

converts domain names to IP addresses.

physical view

how data are actually structured and organized

data warehouse

is a database that stores current and historical data of potential interest to decision makers throughout the company

Linux

is an operating system created by the open source community

Java

is an operating system-independent, processor-independent, object-oriented programming language that has become a leading interactive programming environment for the Web.

open source software

is free software created and updated by a worldwide community of programmers.

HTTP

is the communications standard used to transfer pages on the web

GUI

makes extensive use of icons, buttons, bars and boxes to perform taskes

logical view

presents data as they would be perceived by end users.

network operating system

routes and manages communications on the network and coordinates network resources - can reside on every computer in the network, or it can reside primarily on a dedicated server computer for all the applications on the network

VPN

s a private network of computers linked using a secure "tunnel" connection over the Internet. It protects data transmitted over the public Internet by encoding the data and "wrapping" them within the Internet Protocol

DSL

technologies operate over existing telephone lines to carry voice, data, and video at transmission rates ranging from 385 kbps all the way up to 40 mbps, depending on usage patterns and distance

URL

tells the browser software exactly where to look for the information

TCP/IP

was developed during the early 1970s to support U.S DARPA efforts to help scientists transmit data among different types of computers over long distances

primary key

A field identified in a table as holding the unique identifier of the table's records is called the:

Foreign key

A field identifies in a table as holding the unique identifier of the tables record is called

client/serving computing

A model for a computer that splits the processing between clients and servers on a network, assigning functions to the machine most able to perform the function

Two short mark

A one to one relationship between two entities is symbolized in a diagram by a line that ends in

Network operating system

A special software that routes and manages communications on the network and coordinates network resources

Join Table

A table that links two tables that have a many to many relationship is called

Hubs connect computers in a LAN, but hubs are unable to tell one computer from another, hence all data are sent to all computers connected to the hub. Switches, connect computers or segments of a LAN, unlike hubs, know which device the information is intended for and send it there. Routers can send packets between LANs, while also assigning IP addresses, acting as a switch and protecting your LAN (when a firewall is included).

Differences between Hubs, Switches, and Routers