Database Test 2

Front 1

Activities

Back 1

Part of a business process which transforms inputs into outputs.

Front 2

Business process-

Back 2

A set of activities that transform inputs into outputs.

Front 3

Component design step

Back 3

A process that starts with the approved user requirements as its input, and produces a final system design as its output.

Front 4

Database design

Back 4

Note that one deliverable in the system design.

Front 5

Input →process→ output-

Back 5

The process chain apart of the business process.

Front 6

Outputs

Back 6

The production of useful information, usually in the form of documents and reports)

Front 7

System definition step

Back 7

A process that starts with the need for an information system to support a business process as its input, and produces a project plan as its output.

Front 8

System maintenance step

Back 8

A process that starts with the implemented system as its input, and produces an updated system or a request for system modification using the SDLC as its output.

Front 9

Implementation step

Back 9

A process that starts with the final system design as its input, and produces a final system as its output.

Front 10

Inputs

Back 10

Using a computer on-screen form, a user will input data into the system. Such as how many parts have been taken out of the raw materials inventory to build a wheel barrow.(The activity of gathering Data)

Front 11

Requirements analysis step

Back 11

A process that starts with the project plan as its input, and produces a set of approved user requirements as its output.

Front 12

Operational activities

Back 12

Activities implemented after a competitive strategy is created. These activities include:
• Inbound logistics: receiving,
storing and distributing product inputs.
• Manufacturing operations: transforming inputs into the final product.
• Outbound logistics: collecting, storing, and distributing the product to buyers.
• Sales and marketing: convincing customers to buy the product and selling it to them.
• Customer service: assisting the customers in their use of the product.

Front 13

Support activities

Back 13

Support of the operational activities.
These include:
• Procurement: managing supplier relationships and buying the product inputs.
• Technology management: product research and development and new procedures, methods and techniques.
• Human resources management: managing employee resources.
• Firm infrastructure management: general management of the firm, finance, accounting, legal services, and government affairs.

Front 14

System design

Back 14

A deliverable for component design. It specifies what must be purchased (hardware and possibly software), what must be created (the database) and how the business must adjust its operations (procedures and job responsibilities) to actually implement that information system.

Front 15

Table

Back 15

A tool in Access where all data is stored and they are organized into vertical columns and horizontal rows.

Front 16

Forms

Back 16

A tool in Access that is used for entering, modifying, and viewing records. Forms are used as a way to guide people into entering data correctly.

Front 17

Queries

Back 17

A way of searching for and compiling data from one or more tables. They are used in businesses to find the name and phone number of customers.

Front 18

Reports

Back 18

A way to present information and data in print.

Front 19

Information system

Back 19

A set of interrelated elements or components that collect (input), manipulate (process) and store, and disseminate (output) data and information and provide a feedback mechanism to meet an objective.

Front 20

Processing

Back 20

The activity of converting or transforming data into useful outputs.

Front 21

Feedback

Back 21

The output that is used to make changes to input or processing activities.

Front 22

Systems Development

Back 22

The activity of creating or modifying existing business systems.

Front 23

Systems Investigation

Back 23

To gain a clear understanding of the problem to be solved or opportunity to be addressed

Front 24

Systems Analysis

Back 24

Defines the problems and opportunities of the existing system.

Front 25

Systems Design

Back 25

Determines how the new system will work to meet the business needs defined during systems analysis

Front 26

Systems Implementation

Back 26

- Involves creating or acquiring the various system components (hardware, software, databases, etc.) defined in the design step, assembling them, and putting the new system into operation

Front 27

Systems Maintenance and Review

Back 27

Check and modify the system so that it continues to meet changing needs of today’s organizations

Front 28

Database

Back 28

A self-describing collection
of related records.

Front 29

Database management
system

Back 29

A computer program used
to create, process, and
administer the database;
serves as an intermediary
between database
applications and
the database

Front 30

ID column

Back 30

A unique identifying number on each row.

Front 31

Metadata

Back 31

Problems with the list involving redundancy and
multiple themes.

Front 32

Modification problem

Back 32

Changes to the list that comes with deletion
problems, update problems, and insertion problems.

Front 33

Null Value

Back 33

A row with incomplete values; missing values

Front 34

Referential integrity constraint

Back 34

Ensure that the values of a column in one table are
valid based on the values in another table

Front 35

Relational model

Back 35

A database model used to solve the problems of using
lists

Front 36

Self-describing

Back 36

The database itself contains the definition of its
structure

Front 37

Structured Query Language

Back 37

An international standard for creating, processing and
querying databases and their tables

Front 38

Table

Back 38

Holds data about one and
only one theme.

Front 39

Update

Back 39

To add new/recent
information to a row.

Front 40

Insert

Back 40

To add information to a
row.

Front 41

Delete

Back 41

To completely remove
information; data lost.

Front 42

Autonumber

Back 42

The only number in the data column; indicates Access
will automatically provide a sequential number.

Front 43

Primary key

Back 43

Column value used to identify each row.

Front 44

Surrogate Key

Back 44

Computer generated unique
numbers used to identify
rows in a table.