Information System and Database

Question 1

refers to a collection of multiple
pieces of equipment involved in the dissemination of
information.

Answer 1

information system (IS)

Question 2

Parts of IS

Answer 2

1. hardware
2. software
3. computer system connections and information
4. information system users
5. system’s housing

Question 3

is the study of complementary
networks of hardware and software that people and organizations use to collect, filter, process, create and distribute data.

Answer 3

information system (IS)

Question 4

are combinations of hardware, software, and telecommunications networks that people build and use to collect, create, and distribute useful data,
typically in organizational settings.

Answer 4

information system (IS)

Question 5

Types of Information Systems

Answer 5

• Transaction processing systems
• Management information systems
• Decision support systems
• Executive information systems

Question 6

The six elements of a Computer Based Informations System (CBIS) are:

Answer 6

• Hardware
• Software
• Data
• Procedures
• People
• Communication

Question 7

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

Answer 7

Hardware

Question 8

may use a single computer or thousands.

Answer 8

CBIS

Question 9

tells the hardware how to function.
It gathers, organizes and manipulates data and carries out instructions.

Answer 9

Software

Question 10

This is the information part of an information system, and whether that is statistical data, sets of instructions, lists of names or even graphics and animations, it is all key to a CBIS.

Answer 10

Data

Question 11

Just as hardware cannot function without software, software cannot function without data.

Answer 11

Data

Question 12

Rules, descriptions and instructions for how things are done.

Answer 12

Procedures

Question 13

Frequently covered in instruction or user manuals that describe how to use the hardware, software and data.

Answer 13

Software

Question 14

are the most often overlooked and most important part of a computer-based information system.

Answer 14

People

Question 15

It is 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.

Answer 15

People

Question 16

is left out of some lists of CBIS elements, because parts of it are covered under hardware.

Answer 16

Communication

Question 17

The components that allow one computer to communicate with another are hardware and are controlled by software.

Question 18

If communication between people is included in this element, though, it is an important element.

Answer 18

Communication

Question 19

Its an organized collection of information which can easily be retrieved.

Answer 19

Database

Question 20

Example of a Database:

Answer 20

• Telephone Book
• Mailing List
• Address List

Question 21

related for a specific purpose or topic.
It includes tools needed to work with data

Answer 21

Set of Data

Question 22

Example of Set of Data

Answer 22

• Sorting
• Filtering
• Extracting
• Summarizing

Question 23

A list of related information in columns and rows

Answer 23

Table

Question 24

Each Row in a table is considered a

Answer 24

Record

Question 25

Each Column in the table is a category or a Field

Answer 25

Table

Question 26

is a database object that can be used to extract or show information in Datasheet view.

Answer 26

Query

Question 27

The tables or queries from which a query gets its data are referred to as

Answer 27

Record Source

Question 28

is another database object which can be use to
summarize information from a table or query

Answer 28

Report

Question 29

You can create a macro to perform a specific series of actions

Question 30

can be used to create an action or set of actions
that can be used to automate a task.

Answer 30

Macro

Question 31

can be contained in macro objects or they can be embedded into the forms and reports.

Answer 31

Macros

Question 32

is a field or set of fields in your table that
acts as a unique identifier for every row.

Answer 32

Primary Key

Question 33

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.

Answer 33

Relationship

Question 34

allow relational databases to split and store data in different tables, while linking disparate data items.

Answer 34

Relationship

Question 35

Three types of Relationships

Answer 35

• One to One
• One to Many
• Many to Many

Question 36

exist when a primary record from
the primary table has only one related record in the related
table.

Answer 36

One to One Relationship

Question 37

one relationship to divide a table
with many fields, to isolate part of a table for security
reasons, or to store information that applies only to a
subset of the main table

Answer 37

One to One Relationship

Question 38

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

Answer 38

One to Many relationship

Question 39

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.

Answer 39

Many to Many relationship

Question 40

One item of data, such as your phone number in the
phone book is called a

Answer 40

Data value

Question 41

can get its data from one or more tables, from existing queries, or from a combination of the two.

Answer 41

Query

Question 42

is a database object that you can use to enter, edit, or display data from a table or a query.

Answer 42

Form

Question 43

and you want to analyze or
summarize those queries so that they can be ready for printing.

Answer 43

Report

Question 44

can be contained in macro objects or they can be embedded into the forms and reports.

Answer 44

Macro