Mis Midterm 2

Front 1

Tell me about LANs

Back 1

A network that interconnects computers and communications devices within an office or Local Area Network: series of offices; typically spans a distance of a few hundred feet to several miles.

Front 2

Tell me about MANs

Back 2

Metropolitan Area Network: A Network that transmits data and information over citywide distances and at greater speeds than a LAN.

Front 3

Tell me about WANs

Back 3

Wide Area Network: A Network that connects sites dispersed across states, countries, or continents.

Front 4

Tell me about Data Warehouses

Back 4

A large data store, designed for inquiries, that combines details of both current and historical operations, usually drawn from a number of sources.

Front 5

Tell me about Enterprise Databases

Back 5

Large multiuser database systems developed and maintained by IT professionals.

Front 6

Compare a Spreadsheet to a Database

Back 6

-Spreadsheet is good for "what if" finanical analyses & Forcasts; Recording Accounts Payable in Spreadsheet for Small Businesses.

-Database is good for collecting, storing, and retreving data items that are structured in a particular way; ability to maintain the relationships among data items; Maintaining Accounts Payable for Large Businesses; Protection of sensitive Data/Information.

Front 7

Explain DBMs

Back 7

Database Management Systems: A Program that makes it possible for users to manage the data in a database in order to increase accessibility and productivity.

Front 8

Explain Database Primary & Foreign Keys

Back 8

-The primary key of any table is any candidate key of that table which the database designer arbitrarily designates as "primary". The primary key may be selected for convenience, comprehension, performance, or any other reasons.

-Foreign keys are columns on one table that are inherited from the primary key of another table by means of a dependent or independent relationship.

Front 9

Explain Database Schema

Back 9

It's the structure of the Database.

Front 10

Explain System Development Life Cycle

Back 10

1). Preliminary (conceptual) Design.

2). Prototyping

3). Detailed(Physical)Design.

Front 11

Explain Circuit Switched Networks

Back 11

The complete set of public access networks, so named because the telephone company operates and maintains the switching centers that make it possible to transmit data and information.

Front 12

Explain Packet Switched Networks

Back 12

A Network communication method in which messages are divided into packets. Each packet is then transmitted individually and can even follow different routes to its destination.

Front 13

Explain segments of electronic commerce(B2C and B2B)

Back 13

B2B (business-to-business) customers are other companies while B2C customers are individuals. Overall, B2B transactions are more complex and have higher security needs.

Front 14

Explain Portals(search engines too)

Back 14

Web portals are sites on the World Wide Web that typically provide personalized capabilities to their visitors.

Front 15

Search Engines

Back 15

A search engine is a program designed to help find information stored on a computer system such as the World Wide Web, or a personal computer.

Front 16

Effects of IT Applications

Back 16

1). Activities are completed more quickly.

2). More activities are completed in a particular period of time.

3). Activities are completed with fewer resources.

Front 17

Personal System Advantages

Back 17

An IT System used by only 1 person. A system that stands alone and is not interconnected with other comapnies or shared by other people. Also called Single-User System.

Front 18

OSI Model

Back 18

7 Layers.

Application
Presentation
Session
Transport
Network
Datalink
Physical

Front 19

Compare Servers and Personal Computers.

Back 19

Servers are A computer or device on a network that manages network resources.

PCs are A small, relatively inexpensive computer designed for an individual user.

Front 20

Horizontal Exchange vs. Vertical Exchange

Back 20

-Horizontal Exchange seeks to simultaneously serve the interests of companies across different industries. Customers seek their services because of functional expertise rather than industry expertise.

-Vertical Exchange is Structured to serve members of a specific industry.

Front 21

Application

Back 21

User Interface

Front 22

Presentation

Back 22

Cryptography

Front 23

Session

Back 23

Session

Front 24

Transport

Back 24

Segment

Front 25

Network

Back 25

Packets(IP Address)

Front 26

Datalink

Back 26

Frames

Front 27

Physical

Back 27

Bits

Front 28

Database Views

Back 28

A Subset of 1 or more databases, created either by extracting copies of records from a database or by merging copies of records from multiple databases.