Normalization Exercise

Posted in Uncategorized on May 3, 2009 by ibel69

ERD:

1

Settlement:

From the ERD, there are some explanations that are less about the cardinality relationship between the BAGIAN entity with PROYEK entity and between PROYEK entities to the ternary. So I assume that the relationship between the BAGIAN entity with PROYEK entity are 1 : N where one can have the many projects and one project is owned by only one part only. For PROJECT entities to ternary, I use cardinality N where an employee can have many projects and one project is owned by an employee only.

At the PEGAWAI entity, there is composite attribute that is address attribute. In the making of 1NF is each of the attributes may not be composite, So to write the ALAMAT attribute which is a fraction of the written that address attribute is ALM1 attribute and KDPOS attribute.

So the form of a normalization of ERD over as follows:

2

Form above is a form of Normalization 1NF. These fields obtained from the above attributes in the entity except KONTROLPEG field and PIMPINAN.  This field obtained from the relation of 1:1 PEGAWAI entity and from PEGAWAI entity to BAGIAN entity. Where a lot of employees that controlled by an employee and an employee just controlled by an employee. An employee can lead the section and only led by an employee of the course. FD is functional Dependency from attribute where the arrow means that the attribute designated by the arrow, The value depend from the point of attribute, for example in FD1 the attribute which point is NOPEG so that all attribute values are dependent upon the NOPEG.

From the 1NF form above and with Functional Dependency happen, then obtained a second 2NF normalization form as follows:

3

In 2NF form table has been separated in accordance with the Functional Dependency happens.

From the 2NF form above, then obtained the form of 3NF normalization as follows:

4

From the form above can be seen that 3NF form is equal with 2NF form because when it is created to 2NF form, a whole of attribute in table just depend from the only one attribute in that table. This is in accordance with the requirements of 3NF form that is in a table all of attributes must depend in an attribute that function as a primary key.

NORMALIZATION

Posted in Uncategorized on April 26, 2009 by ibel69

NORMALIZATION
Database Plan Process (Review)

  • Gather user/business need
  • Develop ER model based on user/business need
  • Conversion ER model to relation collection (table)
  • Relation normalization to cause the loss of anomaly
  • Implementation to database with make table for every relation that normalization

Data Base Normalization

Normalization process is the establishment of the database structure so that most of the ambiguity can be removed. Normalization process of decomposition is also a relationship that is still “bad” with break the attributes to build some relationships. Normalization stage, starting from the most mild (1NF) to most stringent (5NF). Normalization is usually only up to the level of 3NF or BCNF because already sufficient to generate the table-a table of good quality.

Why normalization done?

o        Table structures optimalization

o        Increase speed

o        Cause the loss of the same data entering

o        Efficienter in storage media use

o        Decrease redundancy

o        Avoid anomaly (insertion anomalies, deletion anomalies, update anomalies).

o        Data integrity that increased

  • A table is said good (efficient) or normal if fulfil 3 criterias as follows:
    • If there is decomposition (decomposition) table, then the decomposition will be guaranteed safe (Lossless-Join Decomposition). That is, after the table is described / in the decomposition into a new table-table, the table-table can generate a new table with the same exact.
    • Functional dependence when data change (dependency preservation) was kept.
    • No violate Boyce-Code Normal Form (BCNF)
  • If the third criteria (BCNF) can not be fulfilled, then at least the table does not violate the Normal Form of the third stage (3rd Normal Form / 3NF).

Functional Dependency

  • Functional Dependency describe a attributes connection in a relation
  • A attribute said functionally dependant in other attribute if we use attribute value to determine other attribute value.
  • Symbol that used is à for representing functional dependency.

§         Read : functionally to determine

Notation: A à B

A and B attribute from a table. That’s mean functionally A determine B or B depend on A, if and only if there 2 data lines which have a same value with A value , so B value also same.

Notation: A11 B or A à B

Is the contrary from previous notation.

Example :

2

Functional Dependency:

  • NRP à Nama
  • Mata_Kuliah, NRPà Nilai

Non Functional Dependency:

  • Mata_Kuliah à NRP
  • NRP à Nilai
  • Functional Dependency From Value Table
  • Nrp à Nama
  • because for every same Nrp value , so also same Nama value
  • {Mata_kuliah, Nrp } à Value
  • because Value attribute depend on Mata_kuliah and Nrp according to together. In other meaning for Mata_kuliah and same Nrp , so Value also same , because Mata_kuliah and Nrp is key (has unique).
  • Mata_kuliah 11Nrp
  • Nrp 11Value

First Normal Form – 1NF

  • A table is said present in normal form I if it doesn’t present in form unnormalized table, where happen multiplication of a kind field and there possible field that null (empty)
  • Forbidden of existence:
    • Attribute that have multivalue (multivalued attribute).
    • Composite attribute or combination of both.
  • So:
    • Value of domain attribute must be atomic value

Example 1:

Student university data example as follows:

3

Or

4

  • Tables above doesn’t up to standard in 1NF

Example 2 :

dekomposition be:

student university table:

6

Hobby table :

7

Second Normal Form – 2NF

  • Normal form 2NF has been fulfilled in a table if form 1NF has been fulfilled, and all attributes besides primary key, according to intact has functional dependency in primary key
  • A table doesn’t fulfil 2nf, if there is an attribute the dependence (functional dependency) has only partial (only depend on some of primary key)
  • If found attribute doesn’t has dependence towards primary key, so the attribute must moved or caused
  • Functional dependence X à Y is said full if wipe off a A attribute from X that’s mean Y not again depend on functional.
  • Functional dependence X à Y is said partial if wipe off a A attribute from X that’s mean Y still to depend on functional.
  • R relation scheme in the form of 2NF if every attribute non primary key A Î R depend on full according to fungsional in R primary key.

Example 1 :

Table follows to fulfil 1NF, but doesn’t belong 2NF :

8

Example 2 :

  • Doesn’t fulfil 2NF, because {NIM, KodeMk that assumed as primary key but:
    • {NIM, KodeMk}à NamaMhs
    • {NIM, KodeMk} à Alamat
    • {NIM, KodeMk} à Matakuliah
    • {NIM, KodeMk} à Sks
    • {NIM, KodeMk} à NilaiHuruf
  • That’s table necessary decompositioned be several tables that up to standard 2NF

Example 3 :

  • That’s Functional dependency as follows:
    • {NIM, KodeMk}à NilaiHuruf (fd1)
    • NIM à {NamaMhs, Alamat} (fd2)
    • KodeMk à {Matakuliah, Sks} (fd3)
  • Then :
    • fd1 (NIM, KodeMk, NilaiHuruf) à Tabel Nilai
    • fd2 (NIM, NamaMhs, Alamat) à Tabel Mahasiswa
    • fd3 (KodeMk, Matakuliah, Sks) à Tabel MataKuliah

Third Normal Form – 3NF

Normal form 3NF has been fulfilled if fulfil form 2NF, and if there is no non primary key attribute that has dependence towards non primary key attribute the other ( transitive dependence)

Example 1:

  • Student university table follows up to standard 2NF, but doesn’t fulfil 3NF

9

  • Because still found non primary key attribute (that is Kota and Provinsi) has dependence towards other non primary key attribute (that is KodePos):

kodepos à {Kota, Provinsi}

Example 2 :

  • so that the table necessary decompositioned be :
  • Mahasiswa (NIM, NamaMhs, Jalan, KodePos)
    • KodePos (Kodepos, Provinsi, Kota)

Boyce-Codd Normal Form (BNCF)

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

In this example : found Seminar relation, primary key is NPM + Seminar.

Student may take one or two seminars. Every seminar need 2 guides and every student is guided by one of between 2 seminar guides. Every guide only may take one seminar. In this example is NPM and seminar shows a guide.

Seminar Relation

10

Seminar relation form is third normal form, but not BCNF Because seminar code stills to depend on function in guide, if every guide can teach only one seminar. Seminar depend on one attribute not super key like condition in bcnf. So

Seminar relation must devided be two that is:

Guide Relation Seminar-Guide Relation

111

Normal Form Fourth And Fifth

Relations in fourth normal form (4NF) if the relation in BCNF and does not contain a lot of dependence 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 also called the 5 NF PJNF (projection join normal form). The case is very rare and appear difficult to detect in practice.

ERD

Posted in Uncategorized on April 19, 2009 by ibel69

DATABASE

Database is structured group of records (magnetic disk, optical disk, or other secondary store).

Database can indicate a group of interconnection data for venture (company, government institution).

Database example:

In School –> data of Student, Teacher, etc
DATABASE MANAGEMENT SYSTEM (DBMS)

Collection / database combined with software-based database applications. Application programmed are used to access and maintain databases The main purpose DBMS is to provide an environment that is efficient and easy to use, with draw and storage of data and information


BIT, BYTE, AND FIELD

Bit is a part of contain smallest data value 0 or 1. Byte is a collection of same bit.

1 byte = 8 bit.

Field is a group of same byte, in database used by attribute.


ATTRIBUTE / FIELD

It is the nature or characteristics of an entity that provides provide detail on these entities. A relation can have attribute too.

Attribute example:

Table MAHASISWA : NIM, NAMA, ALAMAT

Table PENDUDUK : NOMOR PENDUDUK, NAMA, AGAMA, JENIS KELAMIN

Table BUKU : ID, JUDUL, PENERBIT, PENGARANG
TYPE OF ATTRIBUTE

Single value Vs. Multi value Attributes

-          Single value –> only can fill at most one value. For example: NIM

-          Multi value –> can fill with interest from one value with same type. For example:
Dislike(Reading, Snake, Spider)

Composite Vs Atomic Attributes

-          Atomic –> can’t divide into smaller attribute. For example: NIM

-          Composite –> group from some smaller attribute. For example: Name ( First name, middle name, and last name)

Derived Attribute

-          Value of attribute result from other attributes value. For example: age from attribute date of birthday

Null Value Attribute

-          The Attribute that have not value to an record

Mandatory Value Attribute

-          Attribute must have value
RECORD / TUPLE

Record is a data line in a relation. Consist of attributes where there attribute can interface to fully information an entity / relation.

ENTITY / FILE

A group of same record and have same element, same attribute but different of each data value. Type File In application process, category of file such as:

-          File Mains

-          File Transaction

-          File Report

-          File History

-          File Protected

-          File Activity
DOMAIN

Domain is collection of values enabled to stay in one or more attribute. Each attribute in database relational defined as a domain.
KEY OF ELEMENT DATA

Domain is the set of values that are allowed to reside in one or more attributes. Each attribute in a database relational is defined as a domain

TYPE OF KEY

- Super Key is or more attributes of a table that can be used to identify entity / record of the table are unique (not all attributes can be super key).
- Candidate Key is a super key with minimal attributes. Candidate must not contain a key attribute of the table so that the other candidate key is certain super key but not necessarily vice versa.

- Primary Key One of the attribute from candidate key can be selected / to be determined to become primary key with three criteria:

1. The Key more natural to be used as reference

2. The Key more simple

3. The Key well guarantee
- Alternate Key is an attribute of the candidate key is not selected to be primary key.
- Foreign Key is any attribute subjecting to primary key at other tables. Foreign key will happened at one particular at a relation is owning many to one cardinality (one to many) or many to many. Foreign key usually put at table to many table.
- External Key is a lexical attribute (or set of lexical attributes) that values are always identifying an object instance.

ERD (ENTITY RELATIONSHIP DIAGRAM)

Entity relationship is a network that uses the order of the data stored in the abstract of the system. Entity-relationship model consists of elements of the entity and entity-relationship between these entities.

Differences between DFD and of ERD DFD represent a function network model to be executed by system, while ERD represent data network model emphasizing at structure and relationship data.

ELEMENT OF ERD

Entity
An entity is a concept which you want to store information. In ER Diagram, Entity draws with form a rectangle.


Relationship

Relationship illustrates how two entities share information in the database structure. Relationship is a natural relation between entities.
Relationship Degree

Relationship Degree is the number of entities participating in a relationship. Degree which is often used in the ERD.

Degree of relationship:

-          Unary Relationship
Model is the relationship between the entity originating from the same entity set.

-          Binary Relationship
Model is the relationship between 2 entities.

-          Ternary Relationship

Relationship between the instances of 3 types of entities is unilateral.


Attribute

Attribute is the collection of data elements that form an entity


Cardinality

Can showing optimum of record to relationship with entity at other entity.
There are three cardinalities, that is:

1. One-to-One (1: 1)

Both entities can participate in only one relationship instance.

2. One-to-Many, 3. Many-to-One (1: N, N: 1)

One entity can participate in many relationship instances and contrary.

4. Many-to-Many (N: M)

Both entities can participate in many relationship instance.
For Example:

How many Employees can work in a Department?

One employee can work in only one department

How many Employees can be employed by a Department?

One department can employ many employees

How many managers can a department have?

One department can have only one manager

How many departments can an employee manage?

One employee can have manage only one department

NOTATION OF ERD

Symbolic notation in ERD:

1. Rectangle express gathering of entity

2. Radian express attribute

3. Rhombic express relationship gathering

4. Line as link between relationship gathering with gathering of entity Gathering and

Entity with its attribute

PHASE DEVELOPMENT ER DIAGRAM

  • There are 2 groups of phasing the usual place, namely:
    1. Phase Diagram of making E-R initial (preliminary design).
    2. Phase Diagram optimize E-R (final design)
  • The first stage is to obtain the design minimal database that can accommodate the needs data storage to the system that is being reviewed.
  • The second phase, attention to aspects of efficiency, performance and flexibility.

MAKING ER DIAGRAM START
Technical steps:
1. Identify and define the entire set of entity.
2. Determining attribute-key attribute of each collective entities.
3. Identify and define the entire set of relations between the collective entity, the collective entity with no foreign-key it.
4. Determine the degree / cardinalities relation to each the collective.
5. Complete set of entities and collective relations with attribute-attribute descriptive (non-key).

CASE STUDIES
In the scope of the system indeed lecture (real word) there are many entities that we can involve such as Mahasiswa, Kuliah, Pratikum, Dosen, Asisten, Kelas, Literarur and others.

  • To step-1, Identify and define all set of entities that will be involved.
  • To Step-2, Determining attribute-key attribute of each set of entities.
  • To step-3, Identify and define whole set of relationships between the collective entity collective entities that have foreign-key with it.
  • To step-4, determining degrees / cardinalities relations for each set of relationships.
  • To step-5, Complete set of entities and set of relations with the attribute-descriptive attributes (non key).

ER DIAGRAM WITH THE DATA DICTIONARY

ER Diagram with the data dictionary is The bolt main objective of ER diagram is to show the objects (the collective entity) is just want to be involved in a data base and What’s going on in the relationship between objects it.

  • In the space of a system-wide and complex, drawing attributes-attributes in an ER diagram often even with the objective who want to achieve it.
  • separation attribute-attribute of ER diagram can be expressed in a Data Dictionary
  • The data dictionary contains a list of attributes that wedge in brackets brace.
  • Attribute that functions as a key to be the non-key attribute is the underline.

Data Dictionary:

  • Mahasiswa = { nim, nama_mhs, alamat_mhs, tgl_lahir }
  • Kuliah = { kode_kul, nama_kul, sks, semester }
  • Dosen = { nama_dos, alamat_dos }
  • Mempelajari = { nim, kode_kul, indeks_nil }
  • Mengajar = { kode_kul, nama_dos, waktu, tempat }

Data Flow Diagram

Posted in Uncategorized on April 5, 2009 by ibel69

Data flow diagram
Data Flow Diagram (DFD) is a graphic illustration of the system that uses a number of forms of symbols to describe how data flows through a process of inter-related. DFD can be a program with the algorithm using circle and arrow symbol to represent the flow of data in the design program. The use of notation in the data flow diagram is very helpful to understand a system. DFD will help the user understand the missing field to understand the computer system that will be done because DFD describes the flow of data in the system with a structured and clear.

Some symbols used in the DFD to represent:

1. External entity

2. Data Flow

3. Process

4. Data Storage

Context Diagram

-          The diagram which consists of a process and illustrate the range of a system.

-          The highest level of the DFD that describes the entire system to input and output of the system

-          System is limited by boundary

-          There is No storage

Zero Diagram

-          Diagram illustrating the process of the DFD. Giving view on the whole of system in which, showing the main function or process the flow of data and external entity.

-          At this level of data storage is possible.

-          To process in depth no longer on the next level then added the symbol ‘*’ or ‘P’ at the end of the process.

-          Input and output balance between 0 to diagram context, diagram should be maintained.

Detailed Diagram
Is a diagram that interpret what is the process in the diagram zero level or above. On this diagram, a clarification of the process above will be done in a play. In one level there should be less than 7 units and the maximum of 9, when more should be done in the disintegration.

Numbering of level at DFD:

Level Name Diagram Name Number of Process

0

Context

1

Diagram 0 1.0, 2.0, 3.0, …

2

Diagram 1.0 1.1, 1.2, 1.3, …

3

Diagram 1.1 1.1.1, 1.1.2, …

Specification process
Each process in the DFD must have a specification of the process, to explain the functioning of the process is in our system, the specification method used is the process of disintegration in the form of a sentence describe, decision table, decision tree. This specification will be a programmer for coding rule, because in this specification clearly visible flow process, and steps in each process. At the top level method is used to describe the process can use a sentence with descriptive and in a more detailed level, namely on the bottom (functional primitive) require a more structured specification.

Cash Data
Data flow in DFD is given an arrow symbol. This data flow indicates flow of data from the data that can be input to the system or the results of the processing system.

-          Flow data consist of a group of related data elements in a logical move from one process to another process.

-          Depicted with a straight line connecting the components of the system.

-          Flow data is shown with the direction arrows and the name on the flow of data that flows.

-          Cash flow of data between processes, saving data, the unit outside, and shows data flow from data in the form of inputs to the system.

Guidelines of the name:

  1. Name of the flow of data that consists of some words associated with the flow lines connect
  2. No flow data for the same and the name should reflect its content
  3. The flow of data that consists of several elements can be expressed with the group element
  4. Avoid using the word ‘data’ and ‘information’ to give a name to the flow of data
  5. Wherever possible the complete flow of data is written
  6. Name of the flow of data into a process may not be the same as the name of the data flow out of the process
  7. Data flow into or out of data storage does not need to be given a name if:

7.1.  The flow of data simple and easy to understand

7.2.  Data flow describe the entire data item

  1. There can be no flow of data from the terminal to the data storage, or vice versa because the terminal is not part of the system, the relationship with the terminal data storage must be through

Process

-          The process is what is done by the system

-          The process can process data flows or data entry into the flow of data out

-          The transform function of one or more of data input into one or more of the output data in accordance with the desired specifications

-          Each process has one or more inputs and produce one or more output

-          The process is also often called bubble

-          Guidelines of the process:

1.      Name of the process consists of a verb and noun, which reflects the function of the process

2.      Do not use the process as part of the name of a bubble

3.      May not have some process that has the same name

4.      The process should be given a number. Order number wherever possible to follow the flow of the process or sequence, but the sequence number does not mean that the absolute is a process in chronological order

DFD Symbols

DFD Symbol


v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
<!– /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:”"; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibri; mso-fareast-font-family:Calibri; mso-bidi-font-family:”Times New Roman”;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} –>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:”";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}

Data Storage
Savings is a savings of data from the data can be:
a. Database file
b. Archive
c. Table
Here, a process can take data from the savings of this data. explained with a pair of parallel lines or two lines with one of the side open.
Guidelines of the name:
1. Name should reflect the data storage
2. When his name more than one word must be marked with the number

Data Dictionary
Working to help the system to interpret the application in detail and organize all elements of the data used in the system precisely so that the system analyst and have a basic understanding of the same input, output, storage and process

1)      At the analysis stage, the data dictionary is used as a means of communication between the systems analyst with the

2)      At the system design, data dictionary is used to design input, reports and databases

3)      Flow data on the global DAD, further details can be seen in the data dictionary

4)      load the data dictionary as follows:

  • Name of data flow: must note that readers who need further explanation about a flow of data can find it easily
  • Alias: alias or other name of the data can be written when there is
  • Forms of data: used to segment the data dictionary to use when designing the system
  • Flow data: indicates from which data flows and where the data

Description: to give an explanation of the meaning of the data flow

Database
Work to help the system to interpret the application in detail and organize all elements of the data used in the system precisely so that the system analyst and have a basic understanding of the same input, output, storage and processing. At analysis, the data dictionary is used as a means of communication between system analysts and users with the system design phase, the data dictionary is used to design input, reports and databases. Flow data on the global DAD, further details can be seen in the data dictionary
Load the data dictionary as follows:
1. Name of data flow: must note that readers who need further explanation about a flow of data can find it easily
2. Alias: alias or other name of the data can be written when there is
3. Forms of data: used to segment the data dictionary to use when designing the system
4. Flow data: indicates from which data flows and where the data

Balancing In DFD
The flow of data into and out of a process must be the same as the flow of data into and out of the details of the process on the level / levels below it. This is not to be confusion in the process of the program, and the flow of data in accordance with the structure. Name of the flow of a process, must match the name of the details of the process flow diagram in the lower, the number and the name of an entity outside of the process, must be the same as the number and the name of the details of the process.
The issues that must be considered in the DFD which have more than one level:

1.            There must be a balance between input and output of one level and the next level. Do not until the input and output level of 0 does not exist in the level 1.

2.            Balance between level 0 and level 1 at the input / output of stream data to or from the terminal on level 0, while the balance between level 1 and level 2 is seen on the input or output of stream data to / from the process concerned

3.            Name of the flow of data, data storage and terminals at each level must be the same if the same object

Restrictions in DFD

  • Flow data may not be from outside the entity directly to other outside entities without going through a process
  • Flow data may not be from the savings directly to the data to outside entities without going through a process
  • Flow data may not be saving the data directly from the savings and other data without going through a process
  • Flow data from one process directly to the other without going through the process of saving data should / be avoided as much as possible

BEGINNING OBSERVATION AND REQUIREMENT ANALYSIS

Posted in Uncategorized on March 29, 2009 by ibel69

Investigation Concepts

The gap between system point and the real condition system, in other meaning what is the problem system be fail to reach the system purpose. Analyst system better do investigation to know things of causing a fail system before conducted action to repair a system.

Report from problem detection can be unreal. That Because:

  • The purpose too ideal.
  • Not enough resources and or attitude.
  • System measuring not enough accurate.
  • The purpose of system was expired.
  • The gap between the ideal and the temporary system.

Problem solving:

  • On the way system description à detailed investigation.
  • Get the ideal system consensus
  • Developing a couple of alternative.
  • Choose the best alternative.

Purpose of investigation is showing what the reality problem.

Constraint in system investigation

While investigating, some problem that often shows:

  • Time
  • Cost
  • Knowledge
  • Politics
  • Interference

Recommendation

Result of investigation is a recommendation, such as:

  • Not take action because there aren’t find problem.
  • Do maintenance system for small problem.
  • Improve the user capability or user skill.
  • Consider the modification system in a totally manner.
  • Put happen problem into the recent system development plan.

Tactics investigation

Tactics investigation required to find all problems. Why need the tactics? :

  • To find all of the problems.
  • To find out the reason.
  • To find the best solution.

Some tactics that can be do, such as:

  • Listen the suggestion from the system agent.
  • Don’t resolve the problem early.
  • Compare some system agents story toward the same case.
  • Look for reluctant responses.
  • Probe for logical inconsistency problems.

Technique of investigation

Direct:

  • Questionnaires.
  • Interview.
  • Observation.

Indirect:

  • Procedure flow.
  • Document review and collect critical document.
  • Sample
  • Tabular tools or matrix.

Recent description of system

  • Input
  • Output
  • File
  • Data element
  • Transaction volume and action document
  • Data flow diagram

Requirement analysis

Intensive interaction phase between system analyst with end user where system development team showed their skill to get comments and trust from user and get a good participation

Four goals in this phase:

  • Explain the system completely
  • Describe ideal information system
  • Bring ideal information system to recent condition by attention resource constrain.
  • Give motivation toward the user confidence into system development

Method

  • Interview, Some important factor in good interview, which is objective, audience, format, weighting, combining responses, and documentation.
  • Questionnaire,
  • Observation
  • Procedure Analysis
  • Document Survey
  • Sampling

Resource constraint

  • Time
  • Money
  • Skill
  • Technology
  • External factor

Document analysis requirement

  • Instruction analysis: Relation with the end user, probes the process, problem of collecting data.
  • User requirement: Real requirement, report requirement, train requirement, new system effect.
  • System constraint: Explain time constraint, cost, skill, technology and external factor, System Realistic
  • Documentation: Instrument data collecting, statistical consensus, data flow by logical, and physical data dictionary element

Generating systems alternatives

How to approach the recent condition with the ideal condition system?

  • Create the alternative to solve the problem of information system.
  • That best alternative applying wisely

Strategy selection

  • Distributed versus centralized processing: Change of information decision from centralized data processing to decentralized end user responsibility center.
  • Integrated versus dispersed databases: System designer must consider the data which in data base and incoming to file.
  • Surround strategy of system development: Area around strategy is important in the case confiscation of company because the information system from other company possible differ from company in this time.

Tactic Selection

Do before the selection operational plan

Operational plan selection:

a. Input

  • On-line versus off-line data entry.
  • Keyed versus machine-readable data entry.
  • Centralized versus decentralized data entry.

b. Processing

  • Batch versus real-time record update.
  • Sequential versus direct access to records.
  • Single versus multiple-user update of records.

c. Output

  • Traditional versus turnaround documents.
  • Structured versus inquiry-based reports.

Selecting the Proper System

- Equal tactic: equivalent system based on cost and profit relatively. There is 3 system, A called more excellent with other system if:

  • A have low cost then B and their profit same.
  • A have low cost then B and A produce profit more than B.
  • A and B have same cost but produce of profit A more than B.

- Several comparative method system

  • Break Even point analysis
  • Payback period
  • Discounted payback period
  • Internal rate of return

- Cost category

  • Hardware
  • Software
  • People
  • Suppliers
  • Telecommunications
  • Physical sites

- Cost details

Equal system information cost by means of life system, analyst projection several cost change for future and 3 cost model information system that is Linear, Exponential and Step Function.

- Information system cost happen in one time and be able happen continuous.

  • Information system cost happening in one time that is on-time cost and development cost while system development consist.
  • Information system cost happening continuous there are recurring cost with operational cost while cost happen at information system operated every day.

Information System Factor

Qualitative factor direct to best information system there are:

-          reduce mistake state

-          reduce time to solve mistake

-          reduce perceptive time from alternative workstation

-          increase time to supplying information

-          raise system security

-          increase update from active record

-          raise user satisfied

Company Strategy Factor

-          User satisfied

-          Increase selling state

-          Commitment between consumer and vendor

-          Product information marketing

Representation Learning System

-          Shortly presentation

-          Reduce technically details

-          Represented clearly with visual tools

-          If use model, use tools like laptop so more informative

-          Pushed profit from information system proposal with several alternative agree with company condition

Advanced Decision or Not

-          If company decision to develop the system then information department will doing advanced process there is system design process

-          If the other way then System Development Life Cycle (SDLC) will stopped.

-          Often find problem with studying system and usually top management will asked to do re-processing with studying system.

-          Model will explained several continuous state and sometime information department will create decision to repeat state before explain studying system.

-          With alternative, decision to repeat a state System Development Life Cycle (SDLC) before or not called Go – No -Go Decision

DEVELOPING AN INFORMATION SYSTEM

Posted in Uncategorized on March 6, 2009 by ibel69

The importance of system development

System development can be interpreted to dispose a new system to replace the preceding system as a whole or restore the existing system. The preceding system must to be repaired because:

v     Mark sense about problem that arises at preceding system. The problems such as:

a.      Mistake

Mistake in preceding system causes system that can’t operate according to expected. A mistake can be as a fault that didn’t intentional so cause truths of reducing data are secured.

b.      Organizational growth

Organization growth caused must be disposed the new system. The organization growth such as information requirement that little by little extends, data processing volume increased, changing accounting principle a new one.

v     Get the opportunities

Information Technology expanding very quickly, then organizational start to feel that this TI require to be used ready to increase information. in emulation of market, speed of time efficiency or information very determining success or failure of plan which have been made arrangements for to reach for existing opportunities.

v     Directives

The display of a new system can be done cause of being of instructions from the leader or from the outside of organization.

Purpose of developing an information system

  • solve some problems
  • reach for opportunity
  • gratifying the given instruction

The organization’s expectations after implementing an information system

The Parameter that must be improves to the new system. The improvement related to PIECES, such as:

  • Performance, the improvement of performance in a new system make the system will be effective.
  • Information, the improvement of information quality which presented.
  • Economy, the improvement of benefits and advantages or decreasing cost.
  • Control, the improvement of control to detection and repairing some faults and insincerity which possible happened.
  • Efficiency, the improvement of operating efficiency. Efficiency related with how to use resource without doing extravagance.
  • Services, the improvement of services given by system.

The principles of developing an information system

  • System for the management of
  • System big investment
    • Minimizing missing cost opportunity
    • Best investigation have to be valuable : analysis cost-benefit & analysis cost-effectiveness
  • System need educated people
    • not education have to be formal
  • System Development cycle life
  • System development not have to massage
  • Don’t fear to cancel project
  • System documentation

Systems Development Life Cycle

The Systems Development Life Cycle (SDLC) is a abstract model used in project management that describe the stages concerned in the information system development project from an initial probability study through maintenance of the completed application. Various SDLC methodologies have been developed to guide the processes concerned including the waterfall model (the original SDLC method), rapid application development (RAD), joint application development (JAD), the fountain model and the spiral model. Generally, several models are united into some sort of hybrid methodology. Documentation is critical in spite of the type of model chosen or devised for any application, and usually done in parallel with the development process. Some methods work better for definite types of projects, but in the final analysis, the most important factor for the success may be how directly particular plan was followed.

1.      The image below is the classic Waterfall model methodology, which is the first SDLC method and it describes the various phases involved in development.

waterfall1

Briefly on different Phases:

Requirement Analysis and Design

Analysis gathers the requirements for the system. This stage includes a detailed study of the business needs of the organization. Options for changing the business process may be considered. Design focuses on high level design like, what programs are needed and how are they going to interact, low-level design (how the individual programs are going to work), interface design (what are the interfaces going to look like) and data design (what data will be required). During these phases, the software’s overall structure is defined. Analysis and Design are very crucial in the whole development cycle. Any glitch in the design phase could be very expensive to solve in the later stage of the software development. Much care is taken during this phase. The logical system of the product is developed in this phase.

Implementation

In this phase the designs are translated into code. Computer programs are written using a conventional programming language or an application generator. Programming tools like Compilers, Interpreters and Debuggers are used to generate the code. Different high level programming languages like C, C++, Pascal and Java are used for coding. With respect to the type of application, the right programming language is chosen.

Testing

In this phase the system is tested. Normally programs are written as a series of individual modules, these subjects to separate and detailed test. The system is then tested as a whole. The separate modules are brought together and tested as a complete system. The system is tested to ensure that interfaces between modules work (integration testing), the system works on the intended platform and with the expected volume of data (volume testing) and that the system does what the user requires (acceptance/beta testing).

Maintenance

Inevitably the system will need maintenance. Software will definitely undergo change once it is delivered to the customer. There are many reasons for the change. Change could happen because of some unexpected input values into the system. In addition, the changes in the system could directly affect the software operations. The software should be developed to accommodate changes that could happen during the post implementation period.

2.      In software development, iterative is used to describe a heuristic planning and development process where an application is developed in small sections called iterations. Every iteration is reviewed and critiqued by the software team and potential end-users, insights gained from the critique of iteration are used to determine the next step in development. Data models, which are mostly used to map out iterations, keep track of what has been tried, approved, or discarded, and eventually serve as a kind of blueprint for the final product.

iteration

The challenge in iterative development is to make sure all the iterations are compatible. As every new iteration is approved, developers may employ a technique known as backwards engineering, which is a systematic review and check procedure to make sure each new iteration is compatible with preceding ones. The advantage of using iterative development is that the end-user is involved in the development process. Instead of waiting until the application is a final product, when it may not be possible to make changes easily, problems are identified and solved at each stage of development. Iterative development is sometimes called circular or evolutionary development.

3.      The spiral model, also known as the spiral lifecycle model, is a systems development lifecycle (SDLC) model used in information technology (IT). This model of development combines the features of the prototyping model and the waterfall model. The spiral model is favored for large, expensive, and complicated projects.

spiral

Steps of the spiral model:

  • The new system requirements are definite in as much detail as possible. This generally involves interviewing a number of users representing all the external or internal users and other aspects of the existing system.
  • A prelude design is formed for the new system.
  • A first prototype of the new system is constructed from the preliminary design. This is usually a scaled-down system, and represents an approximation of the characteristics of the final product.
  • A second prototype is evolved by a fourfold procedure: (1) evaluating the first prototype in terms of its strengths, weaknesses, and risks; (2) defining the requirements of the second prototype; (3) planning and designing the second prototype; (4) constructing and testing the second prototype.
  • At the customer’s option, the entire project can be aborted if the risk is deemed too great. Risk factors might involve development cost overruns, operating-cost miscalculation, or any other factor that could, in the customer’s judgment, result in a less-than-satisfactory final product.
  • The existing prototype is evaluated in the same manner as was the preceding prototype, and, if necessary, another prototype is developed from it according to the fourfold procedure outlined above.
  • The preceding steps are iterated until the customer is satisfied that the refined prototype represents the final product desired.
  • The final system is constructed, based on the refined prototype.
  • The final system is thoroughly evaluated and tested. Routine maintenance is carried out on a continuing basis to prevent large-scale failures and to minimize downtime.

Approaches of developing a system

v     Classic approach vs. approach of structure

Classic approach is approach inside of developing a system that follow stages at system life cycle without supplied with tools and techniques.
Troubleshoots which can arise from this approach, such as:

  • Difficult development.
    Classic approach less give tools and techniques insides develop system and finally software development process becoming not directional and difficult to be done by programmer.
  • Treatment cost or system maintenance will be more expensive.
    The expensive treatment cost at classic approach caused system documentation that developed less complete and less structured.
  • Possibility of big error.
    This approach doesn’t prepare to manner systems analysis to do system testing, so that system errors possibility will be bigger.
  • System achievement less well guaranteed.
    Because classic approach less involve system user in system development, so system user needs are less matching with the one which desirable and as finally system that applied less success.
  • Applying internal issue.
    User will be startled and unaccustomed with new system suddenly introduced.

v     Approach of structure

  • Consumer involve from early to determine requirement of system
  • Using tools-tools like data of flow diagram

v     Piecemeal approach vs. system approach

  • Piecemeal approach is system approach development that emphasized at one particular activity or certain application. This approach don’t heed overall target.
  • System approach pays information system as integration unitary to each activity or the application. This approach also emphasized in overall goal achievement from organization, not only in that information target.

v     Approach of bottom-up vs. approach of up-down

  • Bottom-Up Approach had begun from level under organization, that is begun from needs formulation to handle transaction and climb level on with formulate information need based on transaction. This approach also is feature classic approaches. Bottom-up approach is used in systems analysis stage is called also with data analysis, because that be pressure data that be cultivated before hand, information that be produced to follow to follow the data.
  • Top-Down Approach on the contrary begun from level on organization, that is begun with define target and organization policy. Step furthermore from this approach information need analysis. After information is determined, so process goes to transaction processing, that is determination output, input, data base, operating procedure and control. This approach be feature from structured approach. Top-down approach when used in systems analysis stage called also with term decision analysis, because that be pressure information that wanted for decision making by management beforehand, then data necessary cultivated to defined to follow information that wanted.

v     comprehensive system vs. modular approach

Total-system approach to be approach develops system together according to comprehensive. This approach less synchronized for complex system, because will be difficult be developed. This approach be feature classic approaches.
Modular Approach tries to divide complex system to simple some part, so that system easier will be understood and developed. Furthermore consequence system can be developed of time that planned, easy understood by system user and easy to maintain. This approach be feature structured approaches.

v     great-loop approach vs. evolutionary approach

Great-loop approach applies change comprehensive according to together use sophisticated technology. This change contains many risks, because computer technology so great-loop. This approach also too expensive, because need investment at the same moment for all technology that used and difficult to developed because too complex. Evolutionary approach apply sophisticated technology just for applications that need that moment and then be developed for periods next based on technology development. This approach causes investment not too expensive and can follow fast technology development.

The meaning of methodology, method and algorithm

  • What is methodology?

Method those are utilized in scholarship

  • What is method?

Someway systematic to work something

  • What is algorithm?

Medley procedural to solves a problems

The classifications of development methodology

There are three classifications of developing a system, such as:

  • Functional decomposition

Functional decomposition is emphasizing system resolving becomes subsystem. Examples of this classification are HIPO, Stepwise refinement, iterative stepwise refinement and information hiding.   

  • Data-oriented

Data-oriented is emphasizing on processed data characteristic.

  • Flow oriented data: types appropriate modules data elements
  • Structure oriented data: input structure and output
  • Prescriptive

Usually been provided by software maker factory

Tools for developing a system

  • Get graph form: HIPO, SADT, Jackson’s diagrams, etc.
  • Tool that utilizes to design:

o       Activity charting: figuring activity, example: chart’s substituting, flowchart, etc.

o       Layout charting: figuring layout

o       Personal relationship charting: figuring person relationship, example: organization chart, working distribution chart

Techniques used in developing a system

  • Project management techniques à to scheduling project, example: CPM and PERT
  • Tech finds fact à to gather and determines data / fact

o       Interview

o       Observation

  • analysis’s tech cost / benefit à cost benefit and cost effectiveness analysis
  • Going tech shuts close
  • Inspection tech

The differences of being a system analyst and a programmer and the knowledge a system analyst should posses

System analyst studying problems and determine system user requirements to identify resolving.

Programmer writing program code bases engineering that made by analyst

  • System analyst on call bridges distinctive happening science among system user and Data processing technology, computer and mathematics
  • Science carries on business in common
  • Quantitative method: regression, programming linear, etc. it
  • Trouble-shooting membership
  • Communication membership among person
  • Membership builds relationship among person programmer

February, 16th 2009 Definition System and Information

Posted in Computer Science with tags on February 21, 2009 by ibel69

System Definition
System is a drove of element that related and influenced to each other within working together to reach an objective. A system can divide by some subsystem, and the subsystem can divide again by smaller another subsystem.
Example:
Accounting system divide by selling accounting subsystem, buying accounting subsystem, salary accounting subsystem, etc, with the documents for the basic of its components, like a journal, finance, etc.

Characteristic of System
A system have a specific characteristic:

  1. The components based by the amount of components that interacted, and working together to be a unity. Component can divide by some subsystem, where every that subsystem have a special function and will be influenced whole of the system process.
  2. The boundary is the territory that bounded between the system and the outside area or another system. This system can make a system looks like a unity, because with this boundary the function and the order of subsystem with the each other are different but also still can interacted. This boundary referring to a scope from the system.
  3. The environments, is whatever at the outside of the boundary that influenced the system operation. The environments can be benefit or can be damage. The benefit environments must keep care, and the damaging environment must be controlled.
  4. The interface is a connector media between the subsystems, which can make the sources flow from a subsystem to another subsystem. The output from a subsystem will be an input for another subsystem through the interface and integrating the subsystems to be a unity.
  5. Input is the energy which putted into system, it kind maintenance input and signal input. Maintenance input is an energy which putted into a system in order to make the system can operated, and the signal input is an energy that processed to get the new output. For an example in computer system, program is maintenance input that use to operating computer and data is a signal input which processed to be information.
  6. Output is the result from the energy which processed to be useful output. The output can form to the input for another subsystem. For example the computer system, the heat resulted is useless output and kind of residue, but the information is necessity output.
  7. Process, the system can have a part of process which will change input to be an output. The production system will process the input can kind a material to be an output can kind a new item. For example, the accounting system will process the transaction data to be finance report and another report that needed for management.
  8. Objectives or goal, the system must have a goal or objective. If the system doesn’t have a goal, so the operating system will be useless. The objective for a system is very determined to know what the input needed and what the output resulted from a system. The can called success if that system can reach the goal.

Definition of Information

Information is data which processed to be more useful form for whom receiving that information.

Information Quality

  • Accurate

The information must free from mistakes and not mislead.

  • Real Time

The information that comes to receiver must not too late.

  • Relevan

The information must useful for its receiver.

Value of information determined from two things, which are benefit and cost to get that information.

The information will valuable if the benefit bigger than cost to get that information.

information_life_cycle1

Follow

Get every new post delivered to your Inbox.