M6 Flashcards
referring to the hardware, software,
computer system connections, information, information system users, and the
building where its located.
information system
The
most common types of information systems are
transactions processing or TPS,
Management Information Systems or MIS, Decision Support Systems, and Executive
Information System.
The six elements of a Computer Based Information
System (CBIS) are:
Hardware, software, data, procedures,
people, and communication.
refers to the computers themselves, along with
any and all peripherals, including servers, routers,
monitors, printers and storage devices.
hardware
tells the hardware how to function
software
the information part of an information system
data
Rules, descriptions and instructions for how things are
done.
procedures
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
The components that allow one computer to communicate
with another are hardware and are controlled by software.
communication
a collection of data organized in a manner that allows access, retrieval,
and use of that data.
database
A list of related information in columns and rows
table
a database object that can be used to extract or
show information in Datasheet view.
query
is a database object that you can use to enter, edit,
or display data from a table or a query
form
is another database object which can be use to
summarize information from a table or query.
report
can be used to create an action or set of actions
that can be used to automate a task
macro
is a field or set of fields in your table that
acts as a unique identifier for every row.
primary key
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
relationship
One-to-One relationship
exist when a primary record from the primary table
is related to many records in the related table.
One-to-Many relationship
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
A _________ stores data about engineering, architectural, and scientific designs.
COMPUTER – AIDED DESIGN (CAD) DATABASE
Most __________ database products for servers and mainframes include SQL.
relational
A(n) __________ program interacts with a DBMS, which in turn interacts with the database.
FRONT END
________ is processed data; that is, it is organized, meaningful, and useful.
— INFORMATION
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
