Information System and Database Flashcards
refers to a collection of multiple
pieces of equipment involved in the dissemination of
information.
information system (IS)
Parts of IS
- hardware
- software
- computer system connections and information
- information system users
- system’s housing
is the study of complementary
networks of hardware and software that people and organizations use to collect, filter, process, create and distribute data.
information system (IS)
are combinations of hardware, software, and telecommunications networks that people build and use to collect, create, and distribute useful data,
typically in organizational settings.
information system (IS)
Types of Information Systems
- Transaction processing systems
- Management information systems
- Decision support systems
- Executive information systems
The six elements of a Computer Based Informations System (CBIS) are:
- Hardware
- Software
- Data
- Procedures
- People
- Communication
refers to the computers themselves, along with any and all peripherals, including servers, routers, monitors, printers and storage devices
Hardware
may use a single computer or thousands.
CBIS
tells the hardware how to function.
It gathers, organizes and manipulates data and carries out instructions.
Software
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.
Data
Just as hardware cannot function without software, software cannot function without data.
Data
Rules, descriptions and instructions for how things are done.
Procedures
Frequently covered in instruction or user manuals that describe how to use the hardware, software and data.
Software
are the most often overlooked and most important part of a computer-based information system.
People
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.
People
is left out of some lists of CBIS elements, because parts of it are covered under hardware.
Communication
The components that allow one computer to communicate with another are hardware and are controlled by software.
If communication between people is included in this element, though, it is an important element.
Communication
Its an organized collection of information which can easily be retrieved.
Database
Example of a Database:
- Telephone Book
- Mailing List
- Address List
related for a specific purpose or topic.
It includes tools needed to work with data
Set of Data
Example of Set of Data
- Sorting
- Filtering
- Extracting
- Summarizing
A list of related information in columns and rows
Table
Each Row in a table is considered a
Record
Each Column in the table is a category or a Field
Table
is a database object that can be used to extract or show information in Datasheet view.
Query
The tables or queries from which a query gets its data are referred to as
Record Source
is another database object which can be use to
summarize information from a table or query
Report
You can create a macro to perform a specific series of actions
can be used to create an action or set of actions
that can be used to automate a task.
Macro
can be contained in macro objects or they can be embedded into the forms and reports.
Macros
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
allow relational databases to split and store data in different tables, while linking disparate data items.
Relationship
Three types of Relationships
- One to One
- One to Many
- Many to Many
exist when a primary record from
the primary table has only one related record in the related
table.
One to One Relationship
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
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
One item of data, such as your phone number in the
phone book is called a
Data value
can get its data from one or more tables, from existing queries, or from a combination of the two.
Query
is a database object that you can use to enter, edit, or display data from a table or a query.
Form
and you want to analyze or
summarize those queries so that they can be ready for printing.
Report
can be contained in macro objects or they can be embedded into the forms and reports.
Macro
