M6 Flashcards by Issa Estrellado

referring to the hardware, software,
computer system connections, information, information system users, and the
building where its located.

information system

How well did you know this?

Not at all

Perfectly

The

most common types of information systems are

transactions processing or TPS,
Management Information Systems or MIS, Decision Support Systems, and Executive
Information System.

How well did you know this?

Not at all

Perfectly

The six elements of a Computer Based Information

System (CBIS) are:

Hardware, software, data, procedures,

people, and communication.

How well did you know this?

Not at all

Perfectly

refers to the computers themselves, along with
any and all peripherals, including servers, routers,
monitors, printers and storage devices.

hardware

How well did you know this?

Not at all

Perfectly

tells the hardware how to function

software

How well did you know this?

Not at all

Perfectly

the information part of an information system

data

How well did you know this?

Not at all

Perfectly

Rules, descriptions and instructions for how things are

done.

procedures

How well did you know this?

Not at all

Perfectly

who design and operate the software, input the
data, build the hardware and keep it running, write the
procedures and it is ultimately people who determine the
success or failure of a CBIS.

people

How well did you know this?

Not at all

Perfectly

The components that allow one computer to communicate

with another are hardware and are controlled by software.

communication

How well did you know this?

Not at all

Perfectly

a collection of data organized in a manner that allows access, retrieval,
and use of that data.

database

How well did you know this?

Not at all

Perfectly

A list of related information in columns and rows

table

How well did you know this?

Not at all

Perfectly

a database object that can be used to extract or

show information in Datasheet view.

query

How well did you know this?

Not at all

Perfectly

is a database object that you can use to enter, edit,

or display data from a table or a query

form

How well did you know this?

Not at all

Perfectly

is another database object which can be use to

summarize information from a table or query.

report

How well did you know this?

Not at all

Perfectly

can be used to create an action or set of actions

that can be used to automate a task

macro

How well did you know this?

Not at all

Perfectly

is a field or set of fields in your table that

acts as a unique identifier for every row.

primary key

How well did you know this?

Not at all

Perfectly

is a situation that exists between two
relational database tables when one table has a foreign
key that references the primary key of the other table.

relationship

How well did you know this?

Not at all

Perfectly

relationship

One-to-One relationship

How well did you know this?

Not at all

Perfectly

exist when a primary record from the primary table

is related to many records in the related table.

One-to-Many relationship

How well did you know this?

Not at all

Perfectly

exist when a primary record from the primary
table is related to many records in the related table AND a related record in the related table is also related to many records in the primary table

Many-to-Many relationship

How well did you know this?

Not at all

Perfectly

A _________ stores data about engineering, architectural, and scientific designs.

COMPUTER – AIDED DESIGN (CAD) DATABASE

How well did you know this?

Not at all

Perfectly

Most __________ database products for servers and mainframes include SQL.

relational

How well did you know this?

Not at all

Perfectly

A(n) __________ program interacts with a DBMS, which in turn interacts with the database.

FRONT END

How well did you know this?

Not at all

Perfectly

________ is processed data; that is, it is organized, meaningful, and useful.

— INFORMATION

How well did you know this?

Not at all

Perfectly

In a database, a field __________ uniquely identifies each field

primary key

The developer of a relational database refers to a file as a(n) __________

relation

In managing a company’s database, the database __________ requires a technical inside view of data.

— ADMINISTRATOR

The developer of a relational database refers to a record as a(n) __________.

— TUPLE

In a database, a(n) __________ is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses

field

For a database, the field __________ defines the maximum number of characters a field can contain.

— SIZE

A(n) __________ is an item that contains data, as well as the actions that read or process the data.

— OBJECT

A data _________ is a collection of related records stored on storage media such asa hard disk, CD, or DVD.

— file

For a database, the field __________ defines the maximum number of characters a field can contain.

— SIZE

A(n) __________ is an item that contains data, as well as the actions that read or process the data.

— OBJECT

A data _________ is a collection of related records stored on storage media such as a hard disk, CD, or DVD.

file

A user of a relational database, refers to a record as a __________.

row

A major weakness of a lot of file processing systems is that __________.

— THEY HAVE REDUNDANT DATA AND THEY ISOLATE DATA

The advantage of a multidimensional database is that __________.

— IT CAN CONSOLIDATE DATA MUCH FASTER THAN A RELATIONAL

A(n) __________ stores data in objects.

— OODB

In a relational database, each row __________.

— HAS A PRIMARY KEY AND EACH COLUMN HAS A UNIQUE NAME

Compared with relational databases, object-oriented databases __________.

— ALL OTHER CHOICES ARE CORRECT

In a relational database, users can set up a relationship between tables at any time, but the tables must have a common __________.

— column

A(n) __________ database is an application appropriate for an object-oriented database that contains text, graphics, video, and sound.

— HYPERMEDIA

__________ is a process designed to ensure the data within the relations (tables) contains the least amount of duplication.

— NORMALIZATION

In managing a company’s database, the data ________ focuses on the meaning and usage of data.

— modeler

In a relational database, a __________ is a connection within the data.

— RELATIONSHIP

Popular data models in use today include all of the following except ___________.

— HIERARCHICAL

It is the process of comparing data with a set of rules or values to find out if the data is correct.

— VALIDATION

Validation ____________ reduce data entry errors.

— RULES

A multidimensional database stores data in multiple dimensions, sometimes known as a(n) __________, that allow users to access and analyze any view of the database data.

— HYPERCUBE

In a relational database, the only data redundancy exists in the __________.

— FIELDS

In a typical file __________ system, each department or area within an organization has its own set of files.

— PROCESSING

The advantage of a multidimensional database is that __________.

it can consolidate data much faster than a relational database

A(n) __________ digit is a number(s) or characters that is appended to or inserted into a primary key field.

— CHECK

A data __________ is a huge database that stores and manages the data required to analyze historical and current transactions.

— WAREHOUSE

File __________ refers to the procedures that keep data current.

— MAINTENANCE

Data __________ identifies the quality of data in a database.

— INTEGRITY

A __________ stores documents such as schedules, calendars, manuals, memos, and reports.

— GROUPWARE DATABASE

_________, is a query language that allows users to manage, update, and retrieve data.

SQL or STRUCTURED QUERY LANGUAGE

A(n) __________ stores data in objects.

— OODB

A(n) __________ stores data in dimensions.

— MULTIDIMENSIONAL

A user of relational database refers to a file as a __________.

— column

Object-oriented and object-relational databases often use a query language called __________ to manipulate and retrieve data.

— OQL

_________ is a collection of unprocessed items, which can include text, numbers, images, audio, and video.

— DATA

When a company uses that __________ approach, many programs and users share the data in a database.

— DATABASE

Many databases programs perform a validity __________ that analyzes entered data to help ensure that it is correct.

— CHECK

A user of relational database, refers to a field as a __________.

— table

few operating systems include utility programs

false

_____ is a set of data related for a specific purpose or topic

database

What kind of relationship is observed in the situation: Suppliers to products

many-to-many

it is a collection of unprocessed information

data

A company can use thousands of computer system in a single computer-based information system

true

it is the most overlooked element of a CBIS

people

a file _____ utility is a utility that transforms the contents of a file or data from one format to another.

conversion

With an operating system, _____ can include fixes to bugs, enhancements to security, modifications to devices drivers, and the like.

automatic updates

a device dependent program runs on computers provided by a variety of manufacturers

false

because virtual memory is faster than RAM, users may notice the computer speeding up while it uses virtual memory

false

when users press a key or move the mouse, a screen saver disappears, and the screen returns to the previous state

true

_____ is an element of an information system which refers to the physical component of a computer system

hardware

this element of a CBIS tells hardware how to function

software

_____ software assists people in becoming more effective and efficient while performing their daily business activities

business

a(n) _____ operating system is an operating system that organizes and coordinates how multiple users access and share resources on a network

server

even if users are working on multiple programs simultaneously, it is impossible to run out of RAM

false

a(n) _____ is a window on the screen that provides areas for entering or changing data in a database

form

_____ software provides a means for sharing, distributing, and searching through documents by converting them into a format that can be viewed by any user

document management

what kind of relationship is observed in the situation: A customer to products that can be ordered

one-to-many

stand-alone utilities typically offer improvements over those features built into an operating system or provide features not included in an operating system

true

_____ is software that acts without a user's knowledge and deliberately alters a computer's operations

malware

a(n) _____ is a rectangular area of the screen that displays data and information

window

when computer users _____ a document, the computer transfers the document from the memory to a store medium

save

the _____ is a small symbol displayed on the screen that moves as a user moves the mouse

pointer

word processing software includes a(n) _____, which reviews the spelling of individual words, sections of a document, or the entire document

spelling checker

when using spreadsheet software each worksheet can have more than ___ cells

17 billion

Linux is _____ software, which means its code is provided for use, modification and redistribution

open source

____ software helps companies records and reports their financial transactions

accounting

_____ software consists of programs designed to make users more productive and/or assist them with personal tasks

application

a program called a print _____ interprets documents to be printed from the operating system and places them in the queue

spooler

_____ is a multitasking operating system developed in the early 1970s by scientists in bell laboratories

unix

the kernel is memory _____, which means it remains in memory while the computer is running

resident

In addition to being a stand-alone operating system, UNIX also is a network operating system

true

two types of system software are _____.

operating systems and utility programs

during a cold boot on a personal computer, the POST results are compared with the data in a _____ chip

CMOS

a spyware _____ is a program that detects and deletes spyware and other similar programs

remover

it is a n element of CBIS that is responsible in disseminating information to other people faster and safer

communications