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