Acc 361 Chapters 6-10

Front 1

Entity

Back 1

person, place, thing or event on which information can be obtained

Front 2

Attribute

Back 2

piece of information describing a particular entity

Front 3

Key field

Back 3

field in a record that uniquely identifies instances of that unique record so that it can be retrieved, updated or sorted. (Example: SSN, but not name because other people have the same name. Product number, but not product name)

Front 4

Database

Back 4

collection of data organized to service many applications efficiently by storing and managing data so that they appear to be in one location

Front 5

Database Management System (DBMS)

Back 5

special software that permits an organization to centralize data, manage them efficiently, and provide access to the stored data by application programs

Front 6

How does DBMS solve the problems of traditional file environment?

Back 6

1. reduce complexity of the IS environment 2. reduce data redundancy and inconsistency 3. eliminate data confusion 4. create program-data independence 5. enhance flexibility 6. reduce development and maintenance costs 7. centralized management of data

Front 7

Relational DBMS

Back 7

primary method for organizing and maintaining data today in information systems. It organizes data in 2-dimensional tables with rows and columns (relations). Each row represents a record and each column represents an attribute or field

Front 8

Database Warehouse

Back 8

database with archival, querying, and data exploration tools and is used for storing historical and current data of potential interest to managers throughout the organization and from external sources.

Front 9

Business Intelligence

Back 9

Tools that analyze and access information to see new patterns, relationships, and insights that can be used to make decisions (usually in the form of software)

Front 10

Data quality audits

Back 10

structured survey of the accuracy and level of completeness of the data in an IS.

Front 11

Data Cleansing

Back 11

activities for detecting and correcting data in a database that are incorrect, incomplete, improperly formatted, or redundant. Also enforces consistency among different sets of data

Front 12

Simple Network

Back 12

consist of 2 or more connected computers

Front 13

Basic network

Back 13

computers, network interfaces, connection, network operating system software, hub or switch

Front 14

Large company network infrastructure

Back 14

relies on public and private infrastructures, traditional telephone, mobile communication, wireless local-area networks, video conferencing, corporate websites, intranets, extranets, Internet

Front 15

Physical transmission media: Twisted wire

Back 15

up to 100 Mbps

Front 16

Physical transmission media: Microwave

Back 16

up to 600 Mbps

Front 17

Physical transmission media: Satellite

Back 17

up to 600 Mbps

Front 18

Physical transmission media: Coaxial cable

Back 18

up to 1 Gbps

Front 19

Physical transmission media: Fiber optic cable

Back 19

up to 6 Tbps

Front 20

Local Area Network (LAN)

Back 20

designed to connect personal computers and other digital devices within half a mile. Requires its own dedicated channel

Front 21

Components of LAN

Back 21

computers, NOS on dedicade server computer, cable connecting the device, NIC, switches or hubs, and a router