beE

NORMALIZATION

2009-05-03T12:46:00.007+08:00

ER-DIAGRAM

Normalization process model data :

Found the main entities in the model data
Found the relationship between each entity
Determine the attributes of each entity

Figure 1:
We must describe data in the ER-diagram into tables form

Figure2:
A table is in first normal form if all the key attributes have been defined and it contains no repeating groups.

Figure 3:
A table is in second normal form (2NF) if and only if it is in 1NF and every non key attribute is fully functionally dependent on the whole of the primary key (i.e. there are no partial dependencies).
As seen in the table of Pegawai, table of Pegawai has the transitive dependency between its entities.

Transitive dependencies:
NoPeg --> TglLah
TglLah --> Umur

Figure4:
A table is in third normal form (3NF) if and only if it is in 2NF and every non key attribute is non transitively dependent on the primary key (i.e. there are no transitive dependencies).

Database Design process

2009-04-26T12:21:00.011+08:00

Database Design process

Collecting user / business requirements
Developing E-R Model refer to user / business requirements
Converting E-R Model to relationship gatherings (table)
Normalizing relationship to remove anomalies
Implementation to database by make table for each relationship has been normalizatio

Database Normalization

Normalization is process to create database structure until a large of ambiguity can be removed.
Normalization phase is begin from lightest phase (1NF) until tightest (5NF)
Usually it’s just until 3NF level or BCNF because was enough is equal to result the good table qualified.

Why do normalization?

Optimizing table structures
Increase speed
Removing the same data input
More efficient in the use of storage media
Reduce redundancy
To avoid anomalies (insertion anomalies, deletion anomalies, update anomalies).
Increased data integrity

A table is called good (efficient) or normal if has 3 criteria as follows:

If there is table decomposition, then its decomposition should be secured safe (Lossless Join Decomposition). It’s mean, after that table is untied / decomposition becomes new tables, which new tables can result original tables equal with previously.
It’s petted dependable functional at the moment data change (Dependency Preservation).
Don't break Boyce Code Normal Form (BCNF)

If third criteria (BCNF) can't be accomplished, and then at least that table not breach third phase of Normal Form (3rd Normal Form/ 3NF).

Functional Dependency

Functional Dependency describes attributes relationship in one relationship

An attribute is called functionally dependant on another one if we use that attribute to determine the value of other attribute.

Symbol that used is -> for representing functional dependency.
-> read: functionally determines

Notation: A -> B
A and b is attribute of one table. In functionally A determines B or B depend to A, if and only if there are 2 data row appropriate with A, then B also have the same value.

Notation: A. -/-> B or A x -> B
Are opposite of the previous notation.

First Normal Form

A table on the form said to be normal 1 if it did not reside in the unnormalized form of a table, where there are multiplication in a same kind of field and field that allows there is null field (empty field)

Prohibited:

Multivalued attributes
Attributes composite or a combination of both.

And then:

Cost of the domain attribute must be atomic cost

Second Normal Form

Normal form 2NF met in a table if it meets the form of 1NF, and all the attributes except the primary key, have a full Functional Dependency on primary key.
A table does not meet 2NF, if there are attributes that it's dependency (Functional Dependency) are only partial (only depending on the part of the primary key)
If there are attributes that have no dependence on the primary key, then the attributes must be moved or removed
Functional dependency X->Y is said full if it is remove an attribute A from X . It is means that Y is no functionally dependent.
Functional dependency X -> Y is said partial if it is remove an attribute A from X . It is means that Y is functionally dependent.
Relation scheme R in 2NF if every non-primary key attribute A E R functionally depend on the full primary key of R.

This table following 1NF but not 2NF

Boyce-Codd Normal Form

Boyce-Codd Normal Form constraint has a stronger form of the Normal third. To be BNCF, relations must be in the form of 1NF and forced each of the attributes depends on the function in the super key attributes.

3NF Table

Seminat table is depend on one key attribute is not as super key as condition by BCNF. So
Seminar relations must be parsed into two namely:

Third Normal Form

Normal form 3NF met if the form meets 2NF, and if there are no non-primary key attribute that has a dependence on non-primary key attributes of the other (transitive dependencies).

This table following 2NF but not 3NF

Fourth and Fifth Normal Form

Relations in the fourth normal form (NF 4) if the relation in BCNF and dependency not contain many values. To remove the dependency of many values from a relation, we divide the relationship into two new relations. Each relation contains two attributes that have a lot of relationship value.

Relations in fifth normal form (5NF) deal with the property called the join without any loss of information (lossless join). Fifth normal form (the 5 NF also called PJNF (projection join normal form). The case is very rare and appear difficult to detect in practice.

DATABASE AND ER-DIAGRAM

2009-04-19T16:18:00.009+08:00

Database definition:

Database are collection of data that saved on magnetic disk, optical is disk or another secondary storage.
Coherent collection of mutually data of an enterprise (firm, government or private business)

Examples:

Manufacturing business: production planning data, current production data, ordering data significant, etc.
Hospital: patient data, doctor, nurse, etc.

DBMS (DATABASE MANAGEMENT SYSTEM)

A set of database with application software that base of database.
This application program are utilized to access and maintain the databases.
The main purpose of DBMS is provide an easy and efficient environment for data and information employing, pulling and saving.

Bit, Byte, Field

Bit constitutes a smallest part of data that valuably 0 or 1.
Byte is a set of bits that have a same type.
Field is a set of bytes that have a same type, in database it is called attribute.

Attribute/field

Attribute or field constitutes character or characteristic of an entity that provide detail explanations about those entity.
A relationship can also have attribute.

Example of Attribute:

COLLEGE STUDENT has attribute as: NIM, NAME, ADDRESS

CAR has attribute as: COLOR, TYPE, CC

Type of Attribute

Single vs Multi-valued

Single : just can be filled at most one value
Multi-valued : can be filled by more than one value with same type.

Atomic vs composite

Atomic : indiscrete into smaller attribute
Composite : constitute set of some attribute which smaller

Derived Attribute : attribute that has a value which gets from value of another attribute, for example : age is resulted by birth date attribute.

Null Value Attribute : Attribute that have no value for a record

Mandatory Value Attribute : Attribute that must has a value

Record/ Tuple

Constitute a data row in a relationship
Consist from a set of attribute where that attribute interactions to inform the entity or relationship comprehensively.

Entity/File

File constitutes set of record that have a same type, element and attribute but have a different value.

File type :

In application processing, file can be categorized as:

Parent file
Transactions file
Report file
History file
Protecting file
Job file

Domain

Domain constitutes set of values that can be in place on one or more attribute.
Each attribute in a relational database is defined as a domain.

Key of Data Element

Key is record element that is used to find record on access time or can also be used to identify each entity / record / row.

Key Type

Super Key:

Super key constitutes one or more attribute of a table that can be used to identify entity / record of table uniquely (are not all attribute can be super key).

Candidate Key:

Candidate Key is super key with minimal attribute. Candidate key may not contain attribute from the other table therefore candidate key is definitely super key but was obviously on the contrary.

Primary Key:

One of attribute from candidate key that can be used as primary key with three criteria as follows:

1. That key more natural to used as hint

2. That key is simple

3. The uniqueness of that key is guarantee.

Alternate Key:

Are attribute from candidate key that don't be chosen becomes primary key.

Foreign Key:

A foreign key also called a foreign keyword, in a database table is a key from another table that refers to a specific key, usually the primary key, in the table being used. A primary key ca be targeted by necessarily have to be the target of any foreign keys.

External Key:

Constitute a lexical attribute (or lexical gathering attribute) which its point identify one of instance object

Entity Relationship Diagram

ERD is a network model which use word structure that saved in a system abstractly.

The different between DFD and ERD:

DFD constitutes a logistic network model that will be performed by system

ERD constitutes data network model that emphasizes on structure and data relationship

Elements of ERD

Entity

On ER diagram Entity is figured with rectangle. Entity is something in real system and also abstract where data is saved or where data is exists.

Relationship

On ER diagram relationship can be figured by diamond.

Relationship Degree

Are total of entity who participates in one relationship. Degree that frequent being used in ERD.

Attribute

Are characteristic of every entity and also relationship.

Cardinality

Refer total of optimum tupel that relation with entity on another entity.

Relationship Degree

Unary Relationship

Are model relationships that occur between entities that come from same entity set.

Binary Relationship

Are model relationships that occur between 2 entities.

Ternary Relationship

Are relationships between instances of 3 entities types unilaterally.

Cardinality

There are three cardinality of relationships:

One to One:
Level one to one relationship with the one stated in the entity's first event, only had one relationship with one incident in which the two entities and in contras.

One to Many or Many to One:
Level one to many relationship is the same as the one to many depending on the direction from which the relationship is look. For an incident on the first entity can have any relationship with many incident on the second entity, if the one incident on the the second entity can only have one relationship with the incident on the first entity.

Many To Many:
Occur if each event on one entity has many relationships with event on another entity

Notation of ERD

Notation of ERD:

Rectangles: declare entity sets

Circle: declare attribute of entity

Diamonds: declare relationship sets

Lines as connection between relationship sets with entity sets and entity sets with its attribute.

Part 4 - DATA FLOW DIAGRAM

2009-04-05T12:05:00.010+08:00

DATA FLOW DIAGRAM (DFD)

Figuring system division into smaller module
Facilitate user that insufficiently understand about computer area to understands system that will be worked

CONTEXT DIAGRAM

Consist of one process and figures scope of a system.
Constituting supreme level from DFD that figure all of input and output of system.
System limited by boundary (figured by dotted line)
Stored is may not there

ZERO DIAGRAMS

Figuring the process of DFD
Giving view thoroughly hit handled system, pointing out function or aught main process, data flow and external entity
This level is enabled existence of data storage
For the process that do not elaborated again on succeeding level, then increased *' or P' symbol at the end of process numbers
Balance of input and output between zero diagram and context diagram should be maintained

DIAGRAM DETAILED

Diagram detail is diagram that describes what the process that available in zero diagram or level on it.
Numbering level of DFD:

In one level is better has no more than seven processes and maximal processes are nine, if it has more then has to done the decomposition.

SPECIFICATION PROCESSES

Each process on DFD should have process specification.
On top level, method that used to figure the process is by use descriptive sentence
On more detail level which on lower process (functional primitive) need the specification that more structured.
Specification process will be guidance for the programmer in makes program (coding)
Method that used in specification process: Breakdown of process in shaped story, decision table, and decision tree.

EXTERNAL ENTITY

Something that lie at beyond of the system, but it gives data into the system or gives data of system.
Symbolized with notation box
External entity excluding the part of system
Naming:

1.Terminal name is substantive as.
2.Terminal may not have same name except the object is same.

DATA FLOW

Data flow is a place to make a flow information.
Figured by straight line that linking the component of system
Data Flow is pointed out with arrow and line is named by data flow that is steaming.
Data flow is streaming among the process, data storage and shows the data flow of data that form the input for the system.

Name Application guidance:

Data flow’s name which consists from several word streams is linked by connected line.
No data flow that have name equality and name application shall reflect its content.
Data flow that consisting of many elements gets to be declared for by element group.
Avoid employing word “data” and “information” if we want to give name of data flow.
As much as can data flow name is written completely

Other Rule:

Data flow’s name that turns in at a process may not same by the name of data flow that turns out from the process.
Data flow that turn in at a data storage or turns out from data storage not necessarily been given name, if:
Data flow are simple and comprehensible
Data flow figures all of data item
No data flow from terminal to data storage or in the contras, because terminal is not part of system, terminal relationship with data storage shall pass through the process.

PROCESS

Process constitutes what the system done.
Process can process data or input data flow become output data flow.
Process has a function to transform one or many input data become one or many output data appropriate to specification that needed.
Each process has one or many input and resulting one or many output
Often process is called bubble

Guidance of Process Naming

Name of processes consisting of verb and noun that reflect that process function.
Don't use "process" word as part of name a bubble.
May not there many process that have same name
Process should be numbered. Number thread as much as can follow the flow or process thread, but thus number thread doesn't mean absolutely constitute chronologically process thread.

DATA STORAGE

Data storage aught data repository in system
Epitomized by a couple of equal line or two lines with single-sided sideways exposed.
Process can take data of or gives data to the database.
Name application guidance:
Name shall reflect the data storage
If its name more than one word then has to be hyphened

DATA DICTIONARY

Data dictionary have function in helping system user to interpret application in detail and organize all of data element that utilized by the system exactly until user and system analyst have same interpretation about input, output, storage and process.
When analysis phase, data dictionary is used as communication device between system analysts. Meanwhile at the system scheme phase, data dictionary is used to design input, report and database.
Data flow on DAD has global character and more detail information one can be seen on data dictionary.
Data dictionary is containing these things:

Name of data flow: have to record to make reader that requires more explanation about a data current can look for it easily.
Alias: alias or besides name of data can be written if available
Data form: It used for clustering data dictionary into its purpose in time of design system.
Data Flow: point out of which data is streaming and where its aim.
Explanation: giving explanation about meaning of data flow.

BALANCING IN DFD

Data flow that turns in at and turn out from one process have to equal with data flow that turns in at and turn out from details of process on level under it.
Data flow's name which turn in at and turn out from one process have to same with the name of data flow that turns in at and turn out from details of that process.
Total and name of extern entities of a process has to equal with total and name of extern entities of details of that process.
Things who shall be noticed on DFD who between one level and the next level.
Shall available balancing input and output between one level and next level.
Balance between level 0 and level 1 is seen on input / output of data flow goes to or goes out from terminal on level 0, meanwhile balance between level 1 and level 2 are seen on input / output of data flow goes to / or goes out from process that pertinent.
Name of data flow, data storage and terminal at every level should be same.

INTERDICTION IN DFD

Data flow may not from extern entity directly to another extern entity without through a process.
Data flow may not from data storage directly to another extern entity without through a process.
Data flow may not from data storage directly to another data storage without through a process.
Data flow from one process directly to the other process without going through the process of data storage should be avoided.

The SYMBOL use in DFD

2009-03-29T10:10:00.004+08:00

Fourth Quiz

Commencement Monitoring, Analysis Requirement

Concept of System Investigation

Gap between system purpose and the real conditions of system
Detection problem statement is not real:

The system purpose is too ideal
Less of resource or attitude
System measurement is not accurate
Using Out of date system purpose
Different between idle system and temporary system.

Problem solving:

Define the running system investigation with details specified
Obtain the consensus of ideal system
Developing several alternatives
Selecting the best alternative

The investigation purpose show problem that occurred.

Constraints on investigation system:

When we doing the investigation, there are several constraints that are appear, such as:

Time
Cost
Knowledge
Politic
Involved

Recommendation

The result of investigation is a recommendation that includes:

Take no action because the problem is not found
Doing system maintenance there are small problems
Increase the user ability or user skill
Consider about modify system totally

Settle the occurred problem into system development planning.

Investigation tactic

§ Why we need tactic for?

§ To find whole problem

§ To know the problem motive

§ To find the proper solution

§ It’s doing to make all of system element can accept the solution without annoy their activities.

§ Several Tactics that we can doing:

§ Listen to the opinion of system subject.

§ Don’t give the beginning of problem solving

§ Consider

§ Care about inconsistency logical problem

§ Direct :

§ Questionnaire

§ Answer and Question

§ Observation

§ Indirect :

§ Current procedure

§ Document learning

§ Sample

§ Tabular

§ Input

§ Output

§ File

§ Data Element

§ Volume of Transaction and action document

§ Data flow diagram

Analysis Requirement

Intensive interaction between system analyst and end user where system development team show their ability to get conception and user believe until we get best participation.

§ Four purposes which want to attain:

§ Explain the ideal system information

§ Encourage

§ Method

§ Answer and Question

§ Questionnaire

§ Observation

§ Analysis Procedure

§ Document observation

§ Resource constraint

§ Time

§ Money

§ Skill

§ Technology

§ External Factor

§ Analysis requirement document

§ Analysis Directive: relation with end user, process observation, problem in collect data.

§ User Requirement: Real requirement, statement requirement, training requirement and influence of new system.

§ System constraint: roll out consider of time and cost, skill, technology and external factor.

§ Document in the form of data collected, statistic consensus, logically and physically data flow, current data element in data set.

Generating System Alternatives

How to make the current system is like ideal system?

§ Make alternative to solve the information system problem

§ Applying the best alternative prudently

Strategy selection

§ Distributed versus centralized processing

The change of information decision from centralized data processing into decentralized end user responsibility center

§ Integrated versus dispersed database

System designer have to consider what the data that be included into data base and the data that be included into File.

§ Surround Strategy of System Development

Surroundings of strategy are important in business take over because information system from other business may different with current business.

§ Tactics Selection

Doing before operational design selection:

§ Operational design selection

Design selection could be categorized into:

§ Input

§ Online Vs Off Line Data Entry

§ Keyed Vs Machine Readable Data Entry

§ Centralized Vs Decentralized Data Entry

§ Processing

§ Batch Vs real time record update

§ Sequential Vs Direct Access to records

§ Single Vs Multiple User update of records

§ Output

§ Traditional Vs Turn Around Documents

§ Structured Vs Inquiry based reports

Selecting the Proper System

§ Consider tactics: system compared by cost and profit relatively. Three methods to say A system more excellent than other system are :

A have a cost more inferior than B and the profit of both are same
A have a cost more inferior than B and A result profit is more much than B.
A and B have a some cost but A's profit is more much

§ System comparison methods :

§ Break Even point Analysis

§ Payback Period

§ Discounted Pay Back period

§ Internal Rate of Return

§ Cost categories

§ Hardware

§ Software

§ People

§ Supplier

§ Telecommunications

§ Physical sites

§ Cost detailed:

Compare information system cost by system live, analyst forecasting the change of cost for future and there are three information system models, include: Linear, Exponential, and Step function.

§ Information System cost can happen in once and continuous.

§ Onetime cost is Information system cost that happens once and development cost that happen when system is developing.

§ Information system that happen continuously such as recurring cost and operational cost where this cost happen if information system is operated every day.

Information system Factor:

Qualitative factor that aim proper information system outcome are:

§ Fault decrease

§ Decrease the time for fault repair

§ Decrease perceptive time of alternative workstation

§ To Increase system security

§ To Increase the update of source of active record.

§ To Increase user satisfied

Business strategy factor

§ Consumer satisfied

§ The selling level raise

§ Consumer and vendor commitment

§ Information of Product Marketing

Presentation System Learning

§ Doing concise presentation

§ Decrease elaboration technique in presentation

§ Use visual auxiliary to define explicitly.

§ To make informative presentation, used auxiliary especially if we presentation with model.

§ Pressure the benefit of information system proposal with several alternative appropriate business conditions.

Decision to continue or not

§ If business makes a decision to develop the system, then information department will do the next process that is System Design Process.

§ In contrast, System Development Life Cycle is stopped.

§ Top Management will request to repeat the system study if problem with system study is found.

§ Model will explain about repeated phase and sometime information department will make decision to repeat the phase before explain about system study.

§ With Alternative, A decision to repeat System Development Life Cycle phase or not is called Go-No-Go Decision.

Third Quiz

2009-03-08T09:04:00.012+08:00

Part-2 System Development

The importance of developing an information system

System development is change the whole of old system to arrange the new system or just repair the present system. The old system need to repair is caused by several matters, such as:

1. Problems

There are several problems that appear in old system, such as:

− Disorganize

Disorganize in old system is caused the old system can't operate appropriately.

− The growth of organization

The growth of organization make we have to create the new system. The grown-up of organization such as:

a. The need for information is arise.

b. The advance of data manufacture

c. Differences of new accountancy principle

2. Opportunities

Increase the equipping of information until the information can used to make a decision.

The opportunities are like: market opportunity, costumer services.

3. Directives

There are some instructions from manager or alteration of government’s law.

The purpose or goal of developing an information system

1. Resolve the problems

2. Reach the Opportunities

3. Implementation the Directives

The organization’s expectations after implementing an information system

1. Performance

It's measured by throughput and response time.

2. Information

Increase the quality of information.

3. Economy

Increase the benefit and discharge the cost.

4. Control

Advance control to detection and do the corrective action.

5. Efficiency

It’s measured by output divide with input.

6. Services

Advance system services.

The principles of developing an information system

1. System is developing for management

2. System is the great investment

Investigate the entire alternative to minimize the lost opportunity cost and to find the great investment. The great investigation must be precious, the investment is has a value if the use of it more effective than the cost to had it. We can use cost-benefit analysis or cost-effectiveness to determine the precious of investment.

3. System need educated person

4. System development life cycle

Provides overall framework for managing systems development process.

5. System development process is must not in series

6. Don’t be afraid to canceled the project

7. System Documentation

System development life cycle models

1. The Waterfall Model

In the waterfall approach, the whole process of software development is divided into separate process phases.

The phases in waterfall model are:

− Requirement

All possible requirements of the system to be developed are captured in this phase.

− Design

Before us starting the actual coding, it is important to understand what we are going to create. The requirement specifications from first phase are studied in this phase and we can prepare the system design.

− Implementation

Activities in this phase: construct, test, train users, and install new system.

− Verification, include in this phase:

Testing: focus in internal logic of software and external function(find the fault and certain the input-output)

Coding is process convert design into language that machine is known use programming language.

− Maintenance: the meaning of maintenance is how we adapt to changes.

2. Iterative Model

1. Adopt sequential linier and prototype model.

2. The project is dividing into small parts. This allows the development team to demonstrate result earlier on in the process and obtain valuable feedback from system users.

3. With iterative model, work activities are repeated.

4. Each iteration refines previous result.

5. Starting from the model/requirements through to the testing/deployment

6. There are a series of mini project for each iteration.

3. Spiral Model

1. Spiral Model is developed to combine the best of the life cycle and prototyping models.

− Use an evolutionary approach suggested by the prototyping paradigm

− Maintains systematic stepwise approach of the life cycle model, but incorporates it in an iterative framework

2. This model adds risk analysis component to minimize risk during development

3. Four major activities in this model are:

− Determine objectives

Objectives are determined, possible obstacles are identified and alternative approach are weighed

− Risk analysis (Identify and resolve risk)

Possible alternatives are examined by the developer and associated risk or problems are identified. Resolution of the risk are evaluated and weighed in the consideration of project continuation.

− Development and Test

Detail requirement are determined and the software piece is developed.

− Planning the next Iteration

The costumer is given an opportunity to analyze the result of the version created in engineering step and to offer feedback to the developer.

Approaches of developing a system

Classical Approach vs Structured Approach

Classical Approach

1. Use System Development Life Cycle phase, but this approach not give the manual how to do the phase.

2. System User is not stay with.

3. The problems that appear if we use this approach are:

Difficult to expand, great of maintenance cost, minimum of success, complicate in implementation.

Structured Approach

1. Use tools like data flow diagram.

2. System user is stay with.

Piecemeal Approach vs Systems Approach

Piecemeal Approach

1. Emphasize in applications or activities.

Systems Approach

1. View the system as integrated element.

2. Emphasize to get a target

Bottom-up Approach vs Top-down Approach

Bottom-up Approach

1. Start from bottom level, which is operational level

2. Bottom approach is classical approach feature.

3. Known as data-analysis

Top-down Approach

1. Start from top level that is strategy planning level.

2. Top-down approach is structured approach feature.

3. Known as decision-analysis.

Total-system Approach vs Modular Approach

Total-system Approach

1. Expand the system together and comprehensive.

2. Total-system Approach is classical approach feature.

Modular Approach

1. Divide the system in simple a part.

2. That expand system is actual.

3. Modular Approach is structured approach feature.

Great-loop Approach vs Evolutionary Approach

Great-loop Approach

1. Expand the system at once using sophisticates technology.

2. High risk and cost.

Evolutionary Approach

1. Appling sophisticates technology for special application.

2. Developed with requirement.

3. Economical and go along with technology development.

The meaning of methodology, method and algorithm

Methodology

Methodology is methods that used in science or comprehensive guidelines to follow for completing every System Development activity.

Method

Method is a systematic way to do something.

Algorithm

Algorithm is the sequence of procedure to resolve the problem.

Three classifications of development methodology

Functional decomposition

Emphasize at dividing a system into small parts or subsystem. This make the system easy to learn, design and applied.

Data-oriented

This methodology emphasizes at characteristic of data that processing and classified at:

1. Data-flow oriented methodologies, based in dividing system into modules according a element data type and behavior of logic module. Include in this methodologies are: SADT (Structured Analysis and Design Technique), Composite Design and SSAD (Structured System Analysis and Design).

2. Data-structured oriented methodologies, emphasize at input-output structure. Include in these methodologies are: JSD (Jakson’s systems development) and Warnier/Orr (W/O)

Prescriptive

Include in these methodologies are:

1. ISDOS (Information System Design and Optimization System),

2. PLEXIS, transformation a statement of high level computer language into executable code.

3. PRIDGE, a complex software that used to analyze and design system, data management, project management and documentation.

4. SDM/70 (System Development Methodology/70)

5. SPECTRUM,

6. SRES (Software Requirement Engineering System) and SREM(Software Development System).

7. Other prescriptive methodologies : Chapin’s approach, DBO (Design By Objective), PAD (Program Analysis Diagram), HOS (Higher Order Software), MSR (Meta Stepwise Refinement) and PDL (Program Design Language).

Tools for developing a system

1. Graphic models

1. HIPO diagram, it’s used in HIPO methodology and other methodology.

2. Data flow diagram, it’s used in structured system analysis and design.

3. Structured chart, it’s used in structured system analysis and design.

4. SADT diagram, it’s used in SADT methodology.

5. Warnier/Orr diagram it’s used in Warnier/Orr methodology.

6. Jakson’s diagram it’s used in Jakson System Development.

2. Charting Tools

− Activity charting: drawing activity, such as:

1. System flowchart

2. Program flowchart

3. Paperwork flowchart

4. Form flowchart

5. Gantt chart

− Layout charting

− Personal relationship charting

Techniques used in developing a system

The techniques that used in developing a system is not only specifically for one methodology, but also it can used in all of methodologies. The techniques that can be used are:

1. Project Management Techniques,

Such as: CPM (Critical Path Method) and PERT (Program Evaluation and Review Technique). It can be used for project scheduling.

2. Fact Finding Techniques

Fact Finding Techniques are techniques can be used for collection data and finding fact in learning system activity. These techniques are:

-Interview

-Observation

-Questionnaires

-Sampling

3. Cost effectiveness analysis/ Cost benefit analysis

4. Meeting Techniques

5. Walkthrough Techniques

The differences of being a system analyst and a programmer

System analyst:

1. Learning the problem and determine the requirement of system user to identify solution of the problem.

2. Be a mediator between system user and programmer especially about their knowledge.

Programmer:

1. Programmer writing the code programs of the application according design which made by system analyst.

2. Programmer’s knowledge is limited by computing technology, computer system, utilities, and programming language.

The knowledge’s a system analyst should posses

1. Knowledge and skills about data manufacture method, computer technology, and computer programming.

2. Knowledge about business in generally

3. Knowledge about quantitative method

4. Problem solving skills

5. Interpersonal communication skills

6. Interpersonal relationship skills

The basic concept of system

2009-02-20T13:59:00.000+08:00

The basic concept of system

There are two approach to define system that emphasized with procedure and component.

• System is a working network from several procedures that operate together to archive a common purpose.
• System can defined as a collection of components that can interact to reach the objective.

Characteristics of system
•Components of system
The component of system is consist of a number of subsystem. One of system can have a big system that mention supra system.

• Bounds of System
Bounds of System defines difference between the environment and the system.

• Environment
The environment represents everything that is important to understand the function of the system, but is not part of the system. The environment can be ignored in the analysis except for its interaction with the system.
It includes: competition, people, technology, capital, raw materials, data, regulation and opportunities.

• Interface
Interface is the media which connect one of sub system with other sub system.
• Input
Input means all of resources that entered into the system
• Output
Output is result of input had been processed.
• Process
Process means change input to be output
• Goal and objective
Goal and objective means what for the system have been created and whose for the system have been created.

The Classification of system
First definition
In this definitions, system classified as abstract system and physical system.
Second definition
In this definitions, system classified as natural system and human made system.
Third Definition
In this definitions, system classified as deterministic system and probabilistic system.
Fourth definition
In this definitions, system classified as closed system and open system.

Basic concept of information
Before we explain the definition of information, I want you to know the meaning of data. Data are stream of raw fact representing event occur in organizations or the physical environment before they have been organized and arranged into a form that people can understand and use.
And information is data that have been put into a meaningful and useful context and communicated to a recipient who uses it to make decisions. An element of data may constitute information in a specific context.
for example, when you want to contact your friend, his or her telephone number is a piece of information. otherwise, it is just one element of data in the telephone directory.

The Quality of Information
Accurate
Accuracy is measured by comparing the data to actual events. The importance of accurate data varies with the type of decisions that need to be made. Payroll information must be exact. Approximations simply will not suffice. However, a general estimate of how much staff time was devoted to a particular activity may be all that is needed.
Timeliness
Timeliness refers to the currency of the information presented to the users. Currency of data or information is the time gap between the occurrence of an event in the field until its presented to the user (decision maker). When this amount of time is very short, we describe the information system as a real-time system.
Relevance
It means the information have meaningful and useful.
Information is relevant if it leads to improved decision making. It might also be relevant if it reaffirms a previous decision. If it does not have anything to do with your problem, it is irrelevant.

Value of Information
Information does not have an absolute universal value, but we can say the information have a value if the use of information more effective than the cost to have it.

Information System
After we describe the definition of system and information, then we can define the definition of information system.
An information system can defined technically as a set interrelated components that collect, process, store and distribute information to support decision making and control in an organization.

2009-02-20T13:41:00.000+08:00

hii...everyone..

this is my first time writing here...

i admit: i can't speak English well...

but.. i must do it...

so...

please correct me...

^o^ happy learning....