Computer Partial IV

Database modeling

Database modeling

the process of strategically planning where to store each

piece of information you wish to include in your database.

Sorting

determines the order in which to display the records in the recordset.

Database management system

is a program such as Access, Oracle,SQL that stores,

retrieves, arranges, and formats information contained in a database.

Form

is a structured document with specific areas for viewing or entering data one record at a time

Query

is a request for a particular collection of data in a database.

Report

is a formatted collection of information organized to provide printed data on a specific subject.

Table

is  an arrangement of related information stored in columns and rows.

Relational database

is useful for maintaining and analyzing complex information stored in a number of tables.

Primary Key

is a field in a table whose value is uniquely identifies each record in the table.

One-to-one relationship

is a relationship between two tables in which for each

record in the first table, there is only one corresponding record in the related Table.

Record

is an individual listing of related information consisting of a number of related fields stored in a table. A record is also called a row in the datasheet.

characteristic of a field

that determines what kind of data it can store.

system

is a set of things working together as part of a mechanism or an interconnecting network; a complex whole.

information system

is a combination of software, hardware, and telecommunication networks to collect useful data, especially in an organization.

Data processing

occurs when data is collected and translated into usable information.

Information services

is a unit or department in an enterprise responsible for delivering information systems.

computer application

is the software you're probably the most familiar with using.

systems analyst

is an IT professional who works on a high level in an organization to ensure that systems, infrastructures and computer systems are functioning as effectively and efficiently as possible.

System Analysis

is the process of studying a procedure or business to identify its goal and purposes and create systems and procedures that will efficiently achieve them.

Systems design

is the process of defining the architecture, interfaces, and data for a system that satisfies specific requirements.

Information technology

is the study or use of systems (especially computers and telecommunications) for storing, retrieving, and sending information.

business analyst

 helps maximize a business's effectiveness through data-driven decisions.

application analyst

is responsible for the administration, monitoring and maintenance of software infrastructures and applications.

SYSTEM PROBLEM SOLVING

is a problem-solving approach that examines the relationships between functions in an organization.

SDLC

is where the team lays out the specifics of their project - from the requirements gathering to the timeline.

Systems development

is a systematic process which includes phases such as planning, analysis, design, deployment, and maintenance.

word System is derived from the Greek word

Systema

Systema

which means an organized relationship between any set of components to achieve some common cause or objective.

Organization implies structure and order

It is the arrangement of components that helps to achieve predetermined objectives.

Integration

is concerned with how system components are connected together. It means that the parts of the system work together within the system even if each part performs a unique function.