wysukarya

Normalization with Entity Relationship Diagramming

2009-05-03T02:35:00.000-07:00

Normalizing with Entity Relationship Diagramming

ABSTRACT

Entity relationship diagram (ERD) is one of the most widely used technique for data modeling. An ERD developed during the conceptual data modeling phase of the database development process is generally transformed and enhanced through normalization principles during the logical database design phase. This paper suggests inclusion of normalization during ERD development. Application of normalization during ERD development allows for more robust requirement analysis. The paper concludes with a set of guidelines to refine an ERD to include normalization principles.

1.0 Introduction

Entity relationship diagram (ERD) is one of the most widely used technique for data modeling. Data modeling is an essential component of database design and development. It provides a means to analyze business requirements so as to standardize organizational vocabulary, enforce business rules, and ensure adequate data quality. Since data has become a vital corporate resource (Adelman et al., 2005; Dyche, 2000; Liataud & Hammond, 2001), good data models can make a significant contribution to an organization's future success.

Data modeling is performed during the initial phases of the database development process (also referred as database life cycle) as shown in Figure 1(Mannino, 2006; Rob & Coronel, 2006). During this process, the top two phases are concerned with the information content of the database, while the last two phases are concerned with the implementation of the database on some commercial DBMS.

Figure 1

During the conceptual data modeling phase, data requirements are expressed through an ERD. The conceptual data modeling phase in general is independent of a DBMS. The logical design phase transforms the conceptual data model into a format understandable to DBMS. This phase may also enhance or refine the data model (ERD) of the previous phase to ensure efficient utilization of the database. Since most of the commercial DBMS are based on the relational model, the end product of this phase is relational model design.

One of the ways an ERD is enhanced during the logical design phase is through the process of normalization. Normalization is one of the key tenets in relational model design. It is the process of removing redundancy in a table so that the table is easier to modify (Bala & Martin, 1997; Codd, 1970; Date, 2003; Mannino, 2006; Rob & Coronel, 2006). It usually involves dividing an entity table into two or more tables and defining relationships between the tables. The objective is to isolate data so that additions, deletions, and modifications of an attribute can be made in just one table and then propagated through the rest of the database via the defined relationships.

Normalization utilizes association among attributes within an entity table to accomplish its objective. Since an ERD also utilizes association among attributes as a basis to identify entity type structure, it is possible to apply normalization principles during the conceptual data modeling phase. Performing normalization during ERD development can improve the conceptual model, and speed its implementation. This paper outlines the application of normalization principles to ERD development during the conceptual modeling phase. There are various standards for ERD. In this paper, the Crow's Foot notation is utilized.

The ERD has received many extensions and variations, which are generally termed as Enhanced Entity Relationship (EER) model (Lenzerini & Santucci, 1983; Lenzerini & Nobili, 1990; Thalheim, 1998; Balaban & Shoval, 1999; Balaban & Shoval, 2002). In the last few years, the Unified Modeling Language (UML) emerged and became the defacto industry standard for many aspects of object modeling (Bock & Ryan, 1993; Booch, 1994; Fowler, 1997; Booch, Rumbaugh & Jacobson, 1999). The EER model is an integral part of UML as all constructs of EER schemas are included, except for weak entity types, to represent the static part of object modeling. However, ERD continues to be popular for conceptual data modeling.

2.0 Application of Normalization to ERD

Data modeling is an iterative process. Generally a preliminary data model is constructed which is then refined many times. There are many guidelines (rules) for refining an ERD. Some of these rules are as follows (Mannino, 2006):

Transform attributes into entity types. This transformation involves the addition of an entity type and a 1-M (one-to-many) relationship.
Split compound attributes into smaller attributes. A compound attribute contains multiple kinds of data.
Expand entity types into two entity types and a relationship. This transformation can be useful to record a finer level of detail about an entity.
Transform a weak entity type into a strong entity type. This transformation is most useful for associative entity types.
Add historical details to a data model. Historical details may be necessary for legal as well as strategic reporting requirements. This transformation can be applied to attributes and relationships.
Add generalization hierarchies by transforming entity types into generalization hierarchy.

Application of normalization principles toward ERD development enhances these guidelines. To understand this application (i) representation of dependency concepts in an ERD is outlined, followed by (ii) representation of normal forms toward the development of entity type structure. Guidelines for identification of various dependencies is avoided in the paper so as to focus more on their application. Only the first four normal forms and the Boyce-Codd normal forms are considered.

2.1 Representation of Dependencies

Functional dependency in an entity type occurs if one observes the association among the entity identifier and other attributes as reflected in an entity instance. Each entity instance represents a set of values taken by the non entity identifier attributes for each primary key (entity identifier) value. So, in a way an entity instance structure also reflects an application of the functional dependency concept. For example, the Student entity type of Figure 2 can represent the functional dependency SID ?Name, Street, City, Zip.

Figure 2

Each entity instance will now represent the functional dependency among the entity attributes as shown in Figure 3.

Figure 3

During requirement analysis, some entity types may be identified through functional dependencies, while others may be determined through database relationships. For example, the statement, "A faculty teaches many offerings but an offering is taught by one faculty" defines entity type Faculty and Offerings. Another important consideration is to distinguish when one attribute alone is the entity identifier versus a composite entity identifier. A composite entity identifier is an entity identifier with more than one attribute. A functional dependency in which the determinant contains more than one attribute usually represents a many-to-many relationship, which is more addressed through higher normal forms. The notion of having a composite entity identifier is not very common, and often times is a matter of expediency, rather than good entity structure or design.

Transitive dependency in an entity type occurs if non entity identifier attributes have dependency among themselves. For example, consider the modified Student entity type as shown in Figure 4.

Figure 4

In this entity type, suppose there is a functional dependency BuildingName ? Fee. Existence of BuildingName ? Fee dependency implies that the value assigned to the Fee attribute is fixed for distinct BuildingName attribute values. In other words, the Fee attribute values are not specific to the SID value of a student, but rather the BuildingName value. The entity instance of transitive dependency is shown in Figure 5.

Figure 5

Multi-valued dependency equivalency in ERD occurs when attributes within an entity instance have more than one value. This is a situation when some attributes within an entity instance have maximum cardinality of N (more than 1). When an attribute has multiple values in an entity instance, it can be setup either as a composite key identifier of the entity type, or split into a weak entity type. For example, consider the following entity type Student Details as shown in Figure 6.

Figure 6

The Student Details entity type has a composite entity identifier consisting of three attributes - SID, MajorMinor, and Activity. The composition of entity identifier is due to the fact that a student has multiple MajorMinor values along with being involved in multiple activities. However, a student has only one value for Name, Street, City, Zip attributes based on the functional dependency SID, MajorMinor, Activity ? Name, Street, City, Zip. The multi-valued dependency affects the key structure. So, in the Student Details entity type, there can be an MVD SID ?? MajorMinor, Activity. This means that a SID value is associated with multiple values of MajorMinor and Activity attributes, and together they determine other attributes. The entity instance of Student Details entity type is shown Figure 7.

Figure 7

2.2 Normalized ERD

Now we utilize the representation of dependency concepts in ERD toward their use in the application of normal forms. Each normal form rule and its application is outlined.

First Normal Form (1NF)
The first normal form rule is that there should be no nesting or repeating groups in a table. Now an entity type that contains only one value for an attribute in an entity instance ensures the application of first normal form for the entity type. So in a way any entity type with an entity identifier is by default in first normal form. For example, the entity type Student in Figure 2 is in first normal form.

Second Normal Form (2NF)
The second normal form rule is that the key attributes determine all non-key attributes. A violation of second normal form occurs when there is a composite key, and part of the key determines some non-key attributes. The second normal form deals with the situation when the entity identifier contains two or more attributes, and the non-key attribute depends on part of the entity identifier. For example, consider the modified entity type Student as shown in Figure 8. The entity type has a composite entity identifier of SID and City attributes.

Figure 8

An entity instance of this entity type is shown in Figure 9. Now, if there is a functional dependency City ? Status, then the entity type structure will violate the second normal form.

Figure 9

To resolve the violation of the second normal form a separate entity type City with one-to-many relationship is created as shown in Figure 10. The relationship cardinalities can be further modified to reflect organizational working. In general, the second normal form violation can be avoided by ensuring that there is only one attribute as an entity identifier.

Figure 10

Third Normal Form (3NF)
The third normal form rule is that the non-key attributes should be independent. This normal form is violated when there exists a dependency among non-key attributes in the form of a transitive dependency. For example consider the entity type Student as shown in Figure 4. In this entity type, there is a functional dependency BuildingName ? Fee that violates the third normal form.

Transitive dependency is resolved by moving the dependency attributes to a new entity type with one-to-many relationship. In the new entity type the determinant of the dependency becomes the entity identifier. The resolution of the third normal form is shown in Figure 11. The relationship cardinalities can be further modified to reflect organizational working.

Figure 11

Boyce-Codd Normal Form (BCNF)
The Boyce-Codd normal form (BCNF) extends the third normal form. The Boyce-Codd normal form rule is that every determinant is a candidate key. Even though Boyce-Codd normal form and third normal form generally produce the same result, Boyce-Codd normal form is a stronger definition than third normal form. Every table in Boyce-Codd normal form is by definition in third normal form. Boyce-Codd normal form considers two special cases not covered by third normal form:

Part of a composite entity identifier determines part of its attribute, and
a non entity identifier attribute determines part of an entity identifier attribute.

These situations are only possible if there is a composite entity identifier, and dependencies exist from a non-entity identifier attribute to part of the entity identifier. For example, consider the entity type StudentConcentration as shown in Figure 12. The entity type is in third normal form, but since there is a dependency FacultyName ? MajorMinor, it is not in Boyce-Codd normal form.

Figure 12

To ensure that StudentConcentration entity type stays in Boyce-Codd normal form, another entity type Faculty with one-to-many relationship is constructed as shown in Figure 13. The relationship cardinalities can be further modified to reflect organizational working.

Figure 13

Fourth Normal Form (4NF)
Fourth normal form rule is that there should not be more than one multi-valued dependency in a table. For example, consider the Student Details entity type shown in Figure 6. Now, during requirements analysis if it is found that the MajorMinor values of a student are independent of the Activity performed by the student, then the entity type structure will violate the fourth normal form. To resolve the violation of the fourth normal form separate weak entity types with identifying relationships are created as shown in Figure 14. The StudentFocus and StudentActivity entity types are weak entity types. The relationship cardinalities can be further modified to reflect organizational working. It is now presumed that the Student entity type has the functional dependency SID ? Name, Street, City, Zip.

Figure 14

3.0 Conclusions

Instead of applying normalization principles during the relational design portion of logical database design phase, it is better to apply them during the conceptual modeling phase. Due to the similarity in the notion of an entity type and a relation, normalization concepts when explained or applied to an ERD may generate a richer model. Also, such an application enables a better representation of user working requirements. This application now results in the specification of additional guidelines for refining an ERD. These guidelines can be stated as follows:

There should be only one dependency in each entity type where the determinant is the entity identifier.
There should not be any additional dependency among the non entity identifier attributes. Any such additional dependency should be represented by a new entity type with one-to-many relationship.
If there is a composite entity identifier of three or more attributes it should be ensured that there is only one multi-valued dependency among them.

Study of dependencies among attributes during requirement analysis assist in entity type identifications and cardinality specifications. Since an ERD represents a relational model schema, a normalization ERD improves the modeling effort thereby facilitating a better fit with organizational working.

4.0 References

Adelman, S., Moss, Larissa and Abai, Majid (2005) Data Strategy, Addison-Wesley, Readings, MA.
Bala, Mohan and Martin, Kipp (1997) "A Mathematical Programming Approach to Data Base Normalization," Informs Journal of Computing, Vol. 9, No.1, pp. 1-14.
Balaban, M. and Shoval, P. (1999). Enhancing the ER model with integrity methods. Journal ofDatabase Management, 10(4),14-23.
Balaban, M. and Shoval, P. (2002). Enforcing Cardinality Constraints in ER Model with Integrity Methods. In Keng Siau (Eds) Advanced Topics in Database Research, Volume 1, 1-16.
Bock, D. and Ryan, T. (1993). Accuracy in modeling with extended entity relationship and object oriented data models. Journal of Database Management, 4(4), 30-39.
Booch, G. (1994). Object-Oriented Analysis and Design with Applications (second edition).
Reading, MA: Addison-Wesley.
Booch, G., Rumbaugh, J. and Jacobson, I. (1999). The Unified Modeling Language User
Guide. Reading, MA: Addison-Wesley.
Chen P. P. (1976). The entity-relationship model: toward a unified view of data. ACM
Transactions on Database Systems, 1 (1), 9-36.
Codd, E. F. (1970) "A Relational Model of Data for Large Shared Data Banks," Communications of the ACM, Vol. 13, No. 6, pp. 377-387.
Date, Chris (2003) Introduction to Database Systems, 8th edition, Addison-Wesley, Readings, MA.
Dyche, Jill (2000) e-Data, Addison-Wesley, Readings, MA.
Fowler, M. (1997). UML Distilled. Reading, MA: Addison-Wesley.
Lenzerini, M. and Nobili, P. (1990. On the satisfiability of dependency constraints in entity-
relationship schemata. Information Systems, 15 (4),45 3-461.
Lenzerini, M. and Santucci, G. (1983). Cardinality constraints in the entity-relationship model. In Davis, Jejodia, Ng, and Yeh. (Eds.), Entity-Relationship Approach
Liautaud, B. and Hammond, M (2001) e-Business Intelligence, McGraw-Hill, NJ.
Mannino, M. V. (2006) Database Design, Application Development, and Administration, Third Edition, McGraw-Hill, NJ.
Rob, Peter and Coronel, Carlos (2006) Database Systems Design Implementation & Management, Course Technology, Boston, MA.
Thalheim, B. (1998). Fundamentals of Entity-Relationship Modeling. New York: Springer-Verlag.

NORMALIZATION

2009-04-26T04:11:00.000-07:00

Normalization

Database design process (review)
• Gathering user needs / business
• Develop the ER model based on user needs / business
• Convert ER Model to set the relation (table)
• Normalisasikan relations, to remove anomalies
• to implement the database for each table to create relationships that are ternormalisasi

Database normalization
• normalization process is the establishment of the database structure so that most of the ambiguity can be removed.
• The normalization stage starting from the light (1NF) to most stringent (5NF)
• Usually only up to the level of 3NF or BCNF because already sufficient to generate the table-a table of good quality.

Advanced
• Why do normalization?
- Optimization table structures - Increase the speed - Eliminate income data the same
- More efficient use of storage media
- Reduce redundancy
- Avoiding anomalies (insertion anomalies, deletion anomalies, update anomalies).
- Improved data integrity

More
• A table said good (efficient) or if the normal 3 to meet the following criteria:
- If there is decomposition (decomposition) table, it must be guaranteed safe dekomposisinya (Lossless-Join Decomposition). That is, after the table is described / didekomposisi a new table-table, the table-table can generate a new table with the same exact.
- Maintain the functional dependence on the change data (Dependency preservation).
- No violate Boyce-Code Normal Form (BCNF)
• If the three criteria (BCNF) can not be met, then at least the table does not violate the Normal Form of the third stage (3rd Normal Form / 3NF).

Functional Dependency
• Functional Dependency attributes describe the relationship in a relationship
• An attribute said functionally dependant on the other, if we use the value attribute to determine the value of the other attributes.
• The symbol that is used to represent → functional dependency. → reads determine the functional

Continue
• notation: A → B A and B are attributes of a table. A means of determining the functional B or B depends on A, if and only if there are 2 rows of data with the same value of A, then B is also the same value
• notation: A → B or A x→ B It is the opposite of the previous notation.

Functional DEPENDENCY (FD)

Example

Functional Dependency:
• NRP → Name
• subject_lecture, NRP → Value

Non Functional Dependency:
• subject_lecture → NRP
• NRP → Value Functional Dependency
• Functional Dependency of the table value
- Nrp → Name Because for each value Nrp the same, then the value of the same name
- (subject_lecture, NRP) → Value Because the value of attributes depending on the NRP and subject_lecture together. In another sense subject_lecture for the NRP and the same, they also rated the same, because subject_lecture and the NRP is a key (is unique).
- subject_lecture → NRP - NRP → Value

FIRST NORMAL FORM (First Normal Form - 1NF)
A table said to be normal in the form of identity if it is not in the unnormalized form of a table, where there is a kind of field multiplication and field that allows a null (empty) Not the came by:
• Attribute values, many (Multivalued attributes).
• Attribute a composite or a combination of both.

So:
• Price is the domain attribute must be atomic rates Eg student data as follows:

Or

Table
-the table above does not meet the requirements Inf. Decomposition becomes:

Student table:

Table hobbies:

Second NORMAL FORM (Second Normal Form - 2NF)
• The form of normal 2NF met in a table if it meets the form of 1NF, and all the attributes than the primary key, have a full Functional Dependency on primary key
• A table does not meet 2NF, if there are attributes that dependence if (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 Second NORMAL FORM (Second Normal Form - 2NF
• functional dependence X → Y said if fully remove an attribute A from X means that Y is no longer dependent functional.
• functional dependence X → Y if said partial delete an attribute A from X means that Y is functionally dependent.
• The scheme in the form of the relation R 2NF if every non-primary key attribute A € R depend on the full primary key fungsioanl R.

Example:
Table following this meet Inf, including tetafi not 2NF.
• Not meet 2NF, because (NIM, code lecture of subject) is regarded as the primary key:
(NIM, codelecture of subject) → Name Mhs (NIM, codelecture of subject) → Address (NIM, codelecture of subject) → lecture of subject (NIM, code lecture of subject) → SKS (NIM, code lecture of subject) → alfabeth of value

• The table should be a few tables compositioned eligible 2NF
• Functional if dependency as follows:
• (NIM, KodeMk) → NilaiHuruf (fd1)
• NIM → (NamaMhs, Address) (fd2)
• KodeMk → (Matakuliah, SKS) (fd3)
• So that:
• fd1 (NIM, KodeMk, NilaiHuruf) → Table Values
• fd2 (NIM, NamaMhs, Address) → Table Student
• fd3 (KodeMk, Matakuliah, SKS) → Table MataKuliah NORMAL FORM Third (Third Normal Form - 3NF)
• The form of normal 3NF has been 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).

Example
• Table the following students qualified 2NF, 3NF, but does not meet
• Because there are non-primary key attribute (ie, City and Provincial), which has a dependence on non-primary key attributes of the other (ie zip code):
• postcode → (City, Province)
• So that the table should be didekomposisi:
• Students (NIM, NamaMhs, Road, zip code)
- postcode(zip code, Province, City)

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 Normal first and forced each of the attributes depends on the function in the super key attributes. In the example below there is a relationship seminar, is the Primary Key NPM + Seminar. Students may take one or two seminars. Each seminar requires 2 each of the students and led by one of the 2 seminar. Each leader can only take one seminar course.
NPM in this example and show a Seminar of guidancers

Boyce-Codd Normal Form (BNCF) Relations Seminar is a form of Third Normal, but not BCNF Seminar Code because the function depends on the guidancers, if any guidances can only teach a seminar. Seminar depend on one key attribute is not as super disayaratakan by BCNF. But relations Seminar should be parsed into two namely:

Normal form of the fourth and fifth
• Relations in fourth normal form (4NF ) 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 (also called the 5 NF PJNF (projection join normal form). The case is very rare and appear difficult to detect in practice.

DATA BASE AND ER- Diagram

2009-04-19T05:21:00.000-07:00

DATABASE AND ER-Diagram

DEFINITION Database

Definition of the database:

A set of data stored in the magnetic disk, optical disk or other secondary storage Collection of integrated data-related data of an enterprise (company, government or private)

A companies manufacturing production planning data, actual production data, data ordering materials, etc.

A hospital patient data, doctor, nurse, etc.

DATABASE MANAGEMENT SYSTEM

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

DBMS is to provide an environment that is efficient and easy to use, with drawal and storage of data and information

BIT, BYTE, Field

A part is a bit of data which contains the smallest value of 0 or 1

Byte a-bit set of bit similar

Field a-byte set of bytes is similar, in the data base used the term attribute

NIM NAME ADDRESS

9455500001 Abdullah objects RAYA NO 4

9455500002 Aminah CILEDUG NO 4

9455500003 Budiman Halimun NO 7

Attribute / Field

It is the nature or characteristics of an entity that provides provide detail on these entities

A relationship can also have attributes

Example attributes:

STUDENTS: NIM, NAME, ADDRESS

CAR: NOMOR_PLAT, COLOR, TYPE, CC TYPE-TYPE

Attribute

Single vs. multivalue Single a can only be filled at most one value a

Multivalue can be filled with more than one value with the same type of

Atomic vs. composition Atomic a can not be divided into the attributes of smaller a composition is a combination of several attributes of a smaller

Derived attribute attribute value can be derived from the value of other attributes, eg age a attributes resulting from the date of birth

Null Value attribute

Attributes that have no value to a record

Mandatory attribute Value

Attributes must have values

RECORD / TUPLE

It is a line of data in a relationship Consists of the set of attributes where the attribute-attribute-attribute is to inform each other entity / relationship fully

Entity / FILE

File is a collection of similar records and have the same elements, the same attributes but different data values.

File Type

In processing applications, files can follows occupy meaning:

- Master File

- Transaction Files

- File Reports

- File History

- File Protection

- File Work

DOMAIN

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

Element KEY DATA

Key elements of record which is used to find these records at the time of access, or can also be used to identify each entity / record / line

SPECIES OF KEY

Superkey is one or more attributes of a table that can be used to identify entityty / record of the table are unique (not all attributes can be superkey)

Cadidate 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 superkey but not necessarily vice versa. Primary Key One of the key attributes of the candidate can be selected / specified a primary key with the three following criteria:

1. Key is more natural to use as reference

2. Key is more simple

3. Key is guaranteed uniqueness.

Alternate Key is an attribute of the candidate key is not selected to be primary key.

Foreign Key is any attribute that points to the primary key in another table. Foreign key will be going on a relationship that has kardinalitas one to many (one to many) or many to many (many to many). Foreign key is usually always put on the table that point to many. External Key is a lexical attribute (or set of lexical attributes) that values are always identify an object instance

ERD (Entity Relationship Diagram)

ERD is a model of a network that uses word order is stored in the abstract system. Differences between the DFD and ERD. DFD is a model of network functions that will be implemented by the system ERD is a model that emphasizes the network data on the structure and relationship data Elements of the ERD

Entity In the ER Diagram Entity is described with the form of a rectangle. ER Entity is something that exists in the real system and the abstract where the data stored or where there are data.

Relationship ER diagram on the relationship can be described with a lozenge. Relationship is a natural relationship that occurs between entities. In general, the name given to the verb base making it easier to do the reading relations.

Relationship Degree is the number of entities participating in a relationship. Degree which is often used in the ERD.
Attribute is the nature or characteristics of each entity and relationship cardinalitationstuple indicates the maximum number that can be relations with entities on the other entity

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 two entities.

Ternary Relationship is a relationship between the instance of three types of entities are unilateral

CardinalitationThere

are three cardinalitation relations, namely - 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 vice versa. - 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 eyes.For an incident on the first entity can have any relationship with incident many 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: if any incident occurs in an entity have many relationships with other entities in the event

EXEMPLARY KARDINALITAS

Notation (E-R diagram)
symbolic notation in the ER diagram is

1. rectangle represent the collective entity

2. circles represent attributes

3. rhomb stated set of relationships

4. line as a link between the collective set of relationships with the entity and the collective entity with attributed.

DATA FLOW DIAGRAM (DFD)

2009-04-05T07:07:00.000-07:00

DATA FLOW DIAGRAM

Data Flow Diagram (DFD) is a tool that is used to describe a system that already exists or the new system will be developed logically without considering the physical environment where the data flow or the physical environment where the data is saved. DFD This is also called by the name Bubble chart, Bubble diagram, process models, work flow diagrams, or models function

Foreign entity Is unity in the environment outside the system that can be a person, organization or other system that is in the outside environment that will provide input or receive output from the systemProcess A process is an activity or work done by the person, machine or a computer from the data that flow into the process to generate data that will flow out of the process
Save data Savings is a savings of data from the data can be: a. A file or database in the computer system b. A manual record keeping or c. A box where the data in a table d. A table reference manual e. Agenda or a book

DATA FLOW Diagram Component
1. Terminator components / Foreign Entity Terminator represent external entities that communicate with system that is currently being developed. Usually known as the terminator name of foreign entities (external entity).
There are two types of terminator: Terminator Source (source): the terminator into the source. Terminator Destination (sink) is the terminator of a goal data / information system.

Terminator can be a person, group of people, organizations, departments in the organization, or company but at the same system beyond the current model is made. Terminator can also be departments, divisions or outside the system systems that communicate with the system under development

There are three important issues that must be remembered about the terminator: Terminator is a part / the environment outside the system. Flow data connecting terminator system with different processes, shows the relationship system with the outside world. Professional Systems reserve the right not to change the contents or the way work organization or procedures relating to the terminator Relations between the terminator is the one with the other not depicted on the DFD.

Process Components Describe the process components of the system that transform input into output. The process is given a name to describe the process / activities that are / will be implemented. Giving the name of the process is done with using a transitive verb (the verb need object), such as Calculating Salaries .
There are a few things to note about the process:
The process must have input and output. The process can be connected with component terminator, the data store or data flow through process.
System / sections / divisions / departments that are analyzed by professional system components are described with the

Generally, errors in the DFD process is:

1. The process does not have any input but the output. This error is called the black hole (black hole), because the data into the process and does not vanish like to include in the black hole
2. The process of producing output, but did not receive this input. Mistake called miracle (magic), because the output produced magically without ever receiving input

Component Data Store This component is used to create a model set of data packets and given the name of the plural noun, such as Student. Data store is usually associated with the storage-storage, such as file or database associated with the storage of the computer, such as a diskette file, files, hard disk, magnetic tape files. Also store data related to the storage manually, such as address books, file folders, and the agenda

A data store associated with the flow of data only on the components process, not with the other components DFD. Data flows that connect the data store with an understanding of the process have the following:

1.Flow data from the data store, which means as the initialization or reading one single packet of data, more than one packet of data, part of a single packet of data, or some of the more from one packet data to a process
2.Flow of data to store data as a means updated data, such as adding a new data packet or more, remove setup packet or more, or change / modify one or more data packet

In the first clear understanding that the data store does not change, if a packet of data / information from a data store to a process. Instead of the second data store has changed as a result of the flow enter the data store. In other words, the process flow of data is responsible for the changes that occur in the data store.

Component Data Flow / Data Flow A data flow / data flow is depicted with the arrow, which indicates the direction to go and out of a process. This data flow is used to explain the movement of data or packet data / information from one system to the other part.
In addition to indicating the direction, flow data on the model made by the professional system can represent bits, characters, messages, forms, real numbers, and various information related to the computer. Flow data can also represent data / information that is not associated with the computer. Flow data should be named according to the data / information is usually the name of the data flow is done by using the noun, for example, Sales Reports. There are four concepts that need to be in the drawing groove data, namely: Concept Data Package (packets of data) When two or more data flows from a source to the same goal and have the same relationship, and should be considered as a single data flow, because the data that flow together as one package
·Spread the concept of Data Flow (Data Flow Diverging) Flow of data spread shows a number of copies of data packets that originate from the same source to a different destination, or a complex data package is divided into multiple elements of data that is sent to a different destination, or flow data for a data packet that has a different value which will be sent to a different destination
·The concept of Data Flow gather (Converging Data Flow) Some of the data flows of different resources to join together towards the same goal.
·The purpose or the concept of Data Flow All data flows must contain at least one process. The purpose is this sentence:

A flow of data generated from a process and to a data store and / or terminator .A flow of data generated from a data store and / or terminator and to a process. A flow of data generated from a process and leading to a process

INVESTMENT DATA FLOW Diagram There are two forms of DFD, the Physical Data Flow Diagram, Data Flow Diagram and Logic. Physical data flow diagram more emphasis on how the process of the system applied, while the data flow logic diagram further emphasize the processes of what is there in the system. Physical Data Flow Diagram (DADF) DADF is used to more accurately describe the existing system (old system). The emphasis of DADF is how process of the system is applied (in a way what, where and by whom), including manual processes. To obtain a description of how the system is implemented, DADF must include:

1. Manual processes are also described.

2. The name of the data flow must include a description detailed enough to show how the systems work to understand the system.

3. Savings data can show savings of non-computer.

4. The name of saving the data type of application must indicate whether manual or computerized. Manually, for example can show notes books, desk workers. How are shows such as computerized order file, database file
5. The process must show the name of the processor, the person, department, computer system, computer program or the name of the access process.

Data Flow Diagram Logic (DADL) DADL more appropriately used to describe the system that will be proposed (new system). For computerized systems, DADL drawing only shows the process needs of the proposed system of logic, usually processes described is only the processes of a computer course.

TERMS-TERMS DEVELOPMENT DATA FLOW Diagram DFD terms of making this system will help professionals to avoid the wrong formation DFD or the DFD is incomplete or does not logically consistent. Some conditions formation DFD system can help professionals to establish the correct DFD, fun to see and easy to read by the user. Terms of making DFD are:

1. Giving a name to each component DFD

2. Giving number on the component process

3. DFD representation as possible so that good views

4. Tergiversation DFD representation of complex

5. DFD is formed logically consistent

1. name for each component DFD As mentioned previously, the components represent the terminator of the environment outside the system, but have any influence on the system that is being developed. So that the user knows the system environment wherever they are related, this terminator component must be named in accordance with the external environment that affect this system. Terminator component are usually given a name with the word object.
Next is a component of the process. The components of this process represent the system functions that will be implemented or show how the system functions performed by a person, group of people or machines. So it is very clear that this component need to be given the appropriate name, so that anyone who read the DFD especially feel confident that the DFD was established that this model is accurate. Giving the name of the component process better show the rules that will be implemented by someone than by giving the name or identity of the person who will implement them. There are two reasons why not the name or identity of the person (who perform the function system) is used as the name of the process, namely:
1.people may be replaced by another person while coming, so when there is turnover every time people who carry the function, then the system must be changed again.
2.People may not perform a function of the system alone, but some of the different functions of the system. Describe the process than some of the same name but different meaning, it is better to show the tasks / functions of the actual system will be implemented
Because the component name for the process showed better task / function of the system will be implemented, the better use of the name is transitive. Giving a name for the component data store using the noun, because the data store that indicates what data is stored in the system needs to perform its tasks. If the system time when the data need to conduct its work, the data is still there, because the save system. Similarly, for the data flow component, the name given to the better use of the word. Because of this data shows the flow of data and information required and issued by the system in the implementation of its tasks

2. Tax Provision on the Process Component Usually provide a professional system with a number Ascending component in the process as a reference. It does not matter how the numbers of this process are given. The number can be given from left to right or from top to bottom, or can be also done with patterns for a specific number of these remain consistent in the number that is used
The numbers given to the process component of this process is not intended that the process is carried out sequentially. Giving this number is that a reading process in a discussion will be easier with only mention the process only if compared to the process, especially if the name is long and difficult process. Purpose of the number in the process is even more important is to show reference to the numbering scheme in the hierarchy levelisasi DFD. In other words, the number of this process is the basis of the number levelilasi DFD

DFD drawing as often as possible Depiction DFD can be done many times until the DFD technique is correct, can be received by the user, and have been professional enough so that the system rapih not ashamed to show it to the DFD and one .with other words, this depiction DFD made to form DFD is good views, and easy to read by the user and other system professionals. The beauty of drawing DFD depends on the standards required by professional organizations where the system is working and the software used by professionals in the system make DFD. delineation nice to see that can be done with attention to the following:
Size and shape the process. Some users sometimes feel confused when the size of a process different from the other process. They will think that the process with a larger size will be more important than suspected that the process is smaller. This is only the name because the process is longer than the others. So, should the process have described the size and forms of the same
Flow data and flow of data around straight. Flow data can be described with only a circle or straight line. Which is seen more comfortable depending on who will see the DFD.
DFD with the image and the image of the machine. DFD can be described manually or by using the assistance of machines, depending on the choice or professional system.

4.Giversation DFD representation of complex DFD goal is to create a model function that must be implemented by a system and the interaction between functions. Other goal is to model that made it easy to read and understand not only by the professional system to create a DFD, but also by the experienced with the subject of the case. This means that the DFD must be easy to understand, read, and fun to see

On many issues, DFD is created does not have too many processes (process a maximum of six) with the data store, data flow, and terminator that are associated with the process in one diagram. If too many processes, terminator, the data store, data flow and is described in a DFD, then the possibility exists that occurred many contradiction in the data flow in DFD. Cross flow of this data will be difficult to cause the user to read and understand the DFD certain. So the fewer the data on the cross DFD, the DFD is the better established by professional system. Contradiction flow of this data can be avoided with the DFD describes the many-level (levelisasi DFD), or by using the duplicate of the DFD components. DFD component that can use only duplicate parts store and terminator. Provision is also duplicates can not be given at a professional system that creates DFD, but little use of the duplicate, the better that DFD.
Provision of duplicate data store is done by giving straight line or symbol asterik (*), while the terminator to use a forward slash symbol (/) or asterik (*). A large number of duplicates in the duplicate symbol that is used depends on the number of duplicates is used

5. Consistent representation of DFD DFD representation of the group must be consistent another .Professional system DFD describes the DFD based on the levels of DFD with the aim that the DFD is in it easily read and understood by the system. This is in accordance with one of the goals or requirements create DFD

Drawing DFD There are no standard rules to describe the DFD. But from the various references available, outline the steps to create a DFD are:

1. Identify the first all foreign entities are involved in the system.

2. Identification of all input and output are involved with outside entities.

3.Create a Context Diagram (context diagram)
Consist of a process and depict scope from a systemRepresenting highest level of DFD depicting all system to input and output of the systemSystem is limited by boundary (depicted by dash line)There is no storage
This chart is a chart of the highest level DFD that describes the relationship with the environment outside the system. How:
Specify the name of the system.

> Determine the limits of the system.

> Specify the terminator are present in the system.

> Define what is received / given terminator from / to the system.

> picture context diagram

4. Create Diagram Level Zero Diagram of this decomposition is the context diagram. How:

> Determine the main process in the system.

> Determine what is given / received each process to / from the system while considering the concept of balance (the data flow outgoing / incoming from a level should be the same as the flow of data entry / exit to the next level).

> If necessary, store appear data (master) as the source and destination flow data.

> picture diagram level zero.

> Avoid snippet flow data

> Give the number on the main process (the number does not indicate the order process).

5.Create Diagram Level One Decomposition diagram is a diagram of the zero level. How: Define the process of smaller (sub-process) from the main in the zero level. Determine what is given / received each sub-process to / from the system and note the concept of balance. If necessary, store appear data (transaction) as the source and destination flow data.

One picture level DFD

> Avoid snippet flow of data.

> Give the number on each sub-process show that decomposition of the process before.

Example: 1.1, 1.2, 2.1

6. DFD Level Two, Three, ...

This diagram is a decomposition of the previous level. Process decomposition is done with the process until ready to poured in the program. Rules that are used with the same level one.
There are a few things to note in drawing levelisasi DFD, namely: In the context of the diagram, there are several things that need to be system such as the relationship with the outside world that influence, representation system in a process, and data representation store (optional) which is known to store data or external data master store. Data store means this is an external data store is generated by the system that is being analyzed, but is used by another system, or store the data generated by other systems but used by the system that is being analyzed.

Balancing in the drawing need to levelitation DFD DFD Balancing this is a balance between flow of data entry / exit of a level must be the same with the flow data entry / exit to the next level

Data Dictionary

1. 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 .

2. At analysis, the data dictionary is used as a means of communication between the systems analyst with the user.

3. At the system design, data dictionary is used to design input, reports and databases .

4. Flow data on the global DAD, further details can be seen in the data dictionary

Restrictions in DFD

1. Data flow not be outside of the entity directly to the other outside entities without going through a process.

2. Data flow not be directly from the data store to entities outside without going through a process.

3. The data flow not store data directly from the data store without the other through a process.

4. Data flow from one process directly to the other without going through the process of a data store should / be avoided as much as possible

BASIC-BASIC SYSTEM INVESTIGATION

2009-03-29T03:34:00.000-07:00

BASIC-BASIC SYSTEM INVESTIGATION
CONCEPT INVESTIGASI SYSTEM
System Investigation

• gaps differences (gaps) between the purpose of the system and actual system conditions
• The report detection problems does not really real
• The goal is too ideal
• Lack of resources and / or attitudes
• Measurement system is less accurate
• The purpose of the system is lagging
• The difference between the system and the system idel while

• Problem solving: Redrawed system à the ongoing investigation in detail Obtain consensus that the ideal system
• Develop multiple alternatives
• Selecting the best alternative
• Goal à investigation indicates the problem is actually happening

Constraints SYSTEM IN Investigation
In doing some investigation, the constraints that often appear are:
• Time
• Cost
• Finance
• Politics
• Mix of

RECOMMENDATIONS
Results of the investigation is a recommendation that includes, among others, the following:
• Not to take any action not found a problem
• Conducting system maintenance à problems that small
• Improve the ability or skills of the
• Consider modifications to total system
• Placing the problem to occur in the development plan system which immediately made

Tactics Investigation
• Why we need tactics?
• Find all of the issues
• Knowing the causes of the emergence of problems
• Determine the appropriate solution Done so that all elements of the system can receive
preferred solution without disrupting their activities

Some of the tactics that can be done:
• Listen to opinions of the system
• Do not give the early breakthrough
• Compare the story of some of the system on cases the same
• Note the logical inconsistency problem

Jump:
• questionnaire
• Frequently asked questions
• Observation

Not directly:
• Flow of procedure
• Reviewing documents
• Sample
• Tobular

WHEN THIS SYSTEM DESCRIPTION
• Inputs
• Exodus
• File
• Element data
• Transaction Volume and document action
• Diagram the flow of data

NEEDS ANALYSIS
Stage of intensive interaction between the systems analyst with the end user where the system shows the development team expertise to get feedback and trust so that the user get a good participation.

4 PURPOSE THAT WANT achieved:
• Explain the complete system
• describes the ideal information system
• Bringing information system to the ideal conditions at this time with attention to resource constraints
• Provide encouragement to the user confidence in system development
• Method
• FAQs
• quitioner
• Observation
• Procedure analysis

Observation resource document
• constraints
• Time
• Money
• Expertise
• Technology
• External Factors
• Document needs analysis

Referral analysis: Relationships with end users, the observation process, problems in data collection
The user needs: The need actual, reporting requirements, training needs and the influence of the new system
System constraints: Explaining the cost and time constraints, expertise, technology, and external factors
• Documents such as data collection instruments, statistical consensus, the logical flow of data and phisik, data elements in the initial data dictionary.

GENERATING SYSTEMS ALTERNATIVES
How do I approach the condition of the system at this time with the condition of the ideal system?
• Create an alternative to solve the problem of information system
• Alternative is best applied to the wise Options Strategies
• Distributed versus centralized processing Changes in decision-making information from the centralized data processing to the end user Decentralized responsibility center
• Integrated versus dispersed database System designer must consider the data are entered in the data base and the entrance to the File
• Surround System Development Strategy of About important environmental strategy in the case of company take overs because the information system of other companies may vary with the company at this time.
• Options Tactics Selection is done before the design operational
• Design Options Operations Design options can be grouped into
• Input
• Online Vs Off Line Data Entry
• Keyed Vs Machine Readable Data Entry
• Centralized Vs Decentralized Data Entry
• Processing • Batch Vs Realtime record update
• Sequential Vs Direct Access to records
• Single Vs Multiple Users update of records
• Output
• Traditional Vs Turn Around Documents
• Structured Vs based Inquiry reports

SELECTING THE PROPER SYSTEM
• Tactics compare: System comparison based on the costs and benefits are relative;
There are 3 ways said system A system is superior to the other if:
• A has a lower cost of both B and the same benefits
• A has a lower cost of producing A and B benefits more from the B
• A and B have the same but the cost advantage generated a lot more.
• Some methods comparatic System
• Break Even point Analyisis
• Payback Period
• discounted payback period
• Internal Rate of Return
• Cost categories
• Hardware
• Software
• People
• Suppliers
• Teleccommunications
• Physical sites

Cost Details Comparing the cost of information systems through the life of the system, analysts projectivited how cost changes for the future and there are 3 models cost information system, namely Linear, and exponentially Step Function
• Cost information system can occur only once and can also occur on an ongoing basis.
• Cost of information systems that occur only once the cost ontime and development costs that occur during the development of the system.
• Cost of information systems that occur on a continual basis are reccuring cost and operational cost where the cost of this is the case when the operating system information every day.

FACTORS INTO INFORMATION SYSTEM
Qualitative factors that lead the performance information system that both of them
• Reduce errors
• Reduce the time to fix errors
• Reduce the response time from the workstation alternative
• Accelerating the provision of information
• Increase system security
• have active update source record
• Improve the satisfaction

FACTORS INTO CORPORATE STRATEGY
• consumer satisfaction
• Level sales increased
• Commitment of consumers and vendors
• Information product marketing Presenting learning

SYSTEM
• Conducting a brief presentation
• Reduce technical explanation in detail
• Presenting clearly with visual aids
• If using a model using a tool such as a laptop so that more informative
• Emphasize the benefits of the proposed system with some information that there are alternative suitable conditions experienced by the company.

CONTINUING DECISION OR NOT
• If the company decided to develop the information system, the department will do the next process, namely Design System.
• If the System Development and Life Cycle (SDLC) will be terminated.
• Often akan found problems with the system and the study and top management will usually ask for the fulfillment of the re-study system.
• Model will describe some of the stages of the repeated and sometimes the information will make a decision before the repeat stage system of study. With the alternative, the decision to repeat a previous phase or SDLC is not Go - No-Go Decision.

GENERAL OVERVIEW DEVELOPMENT SYSTEM

2009-03-07T20:28:00.000-08:00

GENERAL OVERVIEW DEVELOPMENT SYSTEM

The need and importance of the development system

Development of a system means preparing for the new system replaces the old system as a whole or improve the existing system.
A system needs to be replaced is because;
The existence of the problems that arise in the system longer.
Irregularity, this can be.
Operating inefficiently.
Not a here to policy management.

The growth of the organization
The growth of the organization's old system is not effective anymore, so have to be developed a new system.

To seize the opportunity
In the competitive market, speed or efficiency of the information is very successful, or not to determine strategies and plans that have been developed to achieve opportunities that exist.

There is instruction.
directive is sometimes the instructions given to the development of the old system or creating a new system, instructions can be derived from the leadership organization.
With the new system developed, the expected increase in-going improvements in the new system. Pieces namely, the

Performance, increased system performance toward be more effective, can be seen through trough put at the number of jobs that can be done in a certain time.

Response time is the average time between two transactions and response time in responding to system problems.
Information, improving the quality of information presented.

Economy, upgrading of benefits or the benefits and cost reduction that occurred.
Control, Improvement of the control-control to overcome and fix errors and cheating, and deception that will occur.

Efficiency, improvement of the efficiency operation, related to the efficiency of how resources are used is used with the minimum of waste. Efficiency can be measured from if output divided by the if input.
Service, the increase of services provided by the system.

The principle of the development system

System that is developed is to management system.
After the system completed the system should be developed can be used by the management and can meet all the needs that are required by management.

System developed is a large capitals investment.

Development of a system require capital funds that are not small, especially with use of current technology. System developed is a large capital investment, should consider the following

All alternative should be investigated.

From some alternative investment should be investigated to determine alternative the best and the most profitable.
Investment should be the best value.
This is the best investment must also be measured. Said the new investment is profitable if the value, which means that the benefits or results that are greater than the cost to obtain it. Cost-benefit analysis or cost-Effectiveness analysis can be used to determine whether the project is worth investing or not

System developed need educated people.
People involved in the development and use of this system should be the people who educated about the problems that exist and to solutions that may be made. Educated mean that not have to follow formal university education, but exercise can be done working (on-the-job training).

Stages of work and tasks that must be made in the process of system development.
Before the system development process is done, it must be made before the schedule of work showing stages workplace and work tasks to be done, so that the process of system development can be conducted and completed in accordance with success time and budget that is planned. Cycle or systems development life cycle (system development life cycle) generally shows the stages and work tasks that must be done.

The process of developing the system does not handle.

The process of developing the system does not have to order.

Stages of development of system on the principle of no
shows the steps that must be done and the steps that must be done not only can this series, but can be done together. For example in the development system, design of output is a phase that must be done before the design file. This does not mean that all output must be designed first all new design file can be done, but can be done simultaneously.
Do not be afraid to cancel the project.

The decision to proceed or cancel a project should be evaluated carefully .. for certain cases, where a project had to be stopped or canceled because it is not feasible anymore, it should be done with the firm.

Documentation must have for the development system.
This documentation can be made at the time of the process of developing the system itself is still in the process, because this documentation can be produced from the work of each step in the development system. Documentation created and collected during the process of system developer can be used for communication between the system analyst with the system and can be used to encourage the involvement of the system.

System development life cycle .

Model secuencial linier
On this model the steps are
Requirements
Starting with the building requirements of all elements of the system and allocating some subset of the software needs to be a engineer.
Design
Design software is a multiple-step process that focuses on the four attributes in the different programs, data structures, software architecture, interface representations, and detail (algorithm) procedural
Implementation
Design should be implemented into the form of program code that can be processed by computer
Verification
Ensure that all functions that can be done by the system running well, at the time the test was conducted to find the mistakes in the program.
Maintenance
Changes in software usually occurs after the use by the user, changes can occur due to adjustments to the outside environment, at the time of this software is needed, for example device antiviruses, virus with the new anti-virus must be able to adjust them.

Iterative model

.This model does not vary much with the waterfall model, different is in this model there is.
Initial planning
The planning, the plan starts with knowing the purpose software engineering, the model is used, and certain about those who participate in making the system.
Planning
Make a schedule activity or rundown of the development system.
In the model this iterative cycle where there is after the implementation of the testing is done when there are errors of evaluation will be done, when there are errors this model allows the re-planning with additional information from the evaluation results and generate a better product, the process continues to progress this cycle performance system to the most good.

Spiral Model.
The process is described as spiral.
a.Each loop represents one phase of the process software will be developed a certain organization.
b.Loop in the most focused on the feasibility of the system, the next loop on the definition of the needs of organizations of the system, the next loop associated with the design of the system will be developed and so each Loop is divided into several sectors.

a. Concept operation
determine the destination of the specified phase. Restrictions on the process and product are known. Planning have been prepared. The risk of the project is known. Alternative strategies have been prepared based on the risks that are known, and already planned.

Development plan.
Development planning system, known at tools that at coupled.
Test plan.
Planning the test conducted to test whether a system of organization is eligible to be used.

System development approach

1. The classical approach vs structured

1.1 Classical Approach
Classical approach is the approach in the development of systems that follow the stages in the life cycle without a system provided with the tools and techniques are adequate. Problems in phenomenological classic.

a. Software development will be difficult
Less classical approach to provide tools in the development of techniques in the system and as a result, the software development process does not become effective and difficult to be done by programming. Case with other approaches that provide structured tools, such as data flow diagrams, data dictionary, decision table, and so forth.

b. Cost of care and maintenance system will be expensive
High cost of treatment in the classical approach is because the documentation system developed less complete and less structured.

c. Possibility of system error
Some research indicates that the system does not at a test during the development phase is the main source of system errors. Classical approach does not provide a way to system analysts, to do testing system, so the possibility of errors the system will become greater.

d. Success of the system less secure
In the classical phenomenological because the system is less involved in the development system, the needs of the system will be less than in accordance with the desired result, and as a system that is applied to be less successful.

Problems in the implementation of the system
Because the system is less involved in the development system, then the system will only recognize the new system at the implementation stage only. as a result of this system will not upset because the new system and become frustrated because it can not operate the system with both

1.2 The structured approach
Structured approach, complete with tools and techniques needed in developing the system, so that the final results of the system will have developed a system with well defined structure and clear.

Through this structured approach, the problems are complex in the organization can be solved and the results from the system will be easy to maintain, flexible, more satisfied users, have a good documentation, on time, according to the budget cost of development, can improve productivity and quality will be more well.

2. The piece approaches vs the system

2.1 The piece
A. approach that emphasizes the application of a particular activity or course
b. on this approach, activities or applications that are selected, developed without considering the overall objectives of the organization.

2.2 The system
• Viewing the system as a whole and the unity form a certain information.
• Emphasizing the achievement of overall objectives

3. Ride-down approach vs. top-down approach

3.1 The bottom-rise (bottom-up)
• Starting from the bottom level of the operational
• It is the characteristics of classical
• Known by the term data-analysis

3.2 The top-down (top-down)
• Starting from the top-level strategy planning
• It is the characteristics of structured
• Also known to the decision-analysis.

4. The system-comprehensive approach vs. modular

4.1 The approach of comprehensive system information
• Develop a system simultaneously and comprehensively, and
• It is characteristic of the classical approach

4.2 The modular approach
• break a complex system into parts of a simple
• System to be developed on time, easy to understand and kept
• It is characteristic of the structured approach

5. The far-jump approach vs. developing

5.1 The jump-distance (great-loop approach)
• Develop a system simultaneously using technologi sophisticated.
High-risk and spend a lot of cost

5.2 The approach evolved (evolutionary approach)
• Applying advanced technology for application-specific applications
• Developed for the needs
• Save the cost and can follow the development of technology

System development methodology.

methodology
- totality methods, procedures, working concepts, rules and postulat used in science, art or discipline the other.
For example the methodology is structured systems analysis and design for use on the development of the system.

method
- One way, systematic techniques to grind
For example is the simplex method to find the value of x and y in the equation linear.

Algorithm
- Sort-order procedure to solve a problem.
For example quick sort algorithm is in the process of sorting

Classification methodology development.
a. Functional decomposition
- Emphasizing breaking into the system so that the subsystem will be more easy to understand, designed and implemented
- Example: Stepwise refinement, iterative stepwise refinement.
b.Data-oriented
- Emphasizing on the characteristics of the data processed

• Data-flow oriented: modules according to the type of data elements and behavior logic in the module system
Example: composite design, SSAD

• Data-oriented structure: emphasis on the structure of input and output in the system, then this structure will be used as a basic structure of the system are made.
Example: Jakson's system development.

Prescriptive
- Usually provided by the manufacturer of the software
Example: PRIDE, Spectrum.

Tool in the development system

Tools used in a methodology as a general picture, diagram or graph, in addition to the equipment that is not the form of graphic image is an example of data dictionary and a form to present data.

Example of system development tool that shaped graph
Data Flow diagrams, structured charts, SADT, Jakson's diagram.

Tools that use the chart-chart:
o Activity charting: describe the activity, flowchart.
o Layout charting: describes the system layout diagram
o Personal relationship charting: describes the relationship of personnel, for example: organization chart.

System development techniques.
a. And management techniques for project scheduling, for example: CPM.
b. Techniques to find, collect and define data / facts
- Interview
- Observation
- Questioner.
c. Technical operating cost / benefits, for example, cost-benefit and cost-Effectiveness analysis.
d. Technical meeting to run a membership organization.
e. A system of technical inspection organization.

System analyst and programmer
System analyst
learn the issues and determine the needs of the system to identify a solution.
And the task of responsibility
Not only on the making of an application program or computer, but in the system as a whole.
Knowledge must be knowledgeable, not only on the technology, but also in the field of application systems that handling.
laborer systems analyst in making the program is limited to solving the line of the system.
System analyst jobs involving contact with many people in analyst system.

Programmers
writing program code based on the design of the system will be made by analysts
Duties and responsibilities
- Limited in making program
- The programming is limited to computer technology, computer systems, utilities and language program is required.
- Employment is the technical and programming must be precise in making the instruction program.
- Employment not the relationship with people.

System analyst duty bridge the knowledge gap that occurs between the user and programmer system itself

Analysts knowledge required system.
. Technology, data processing, and computer programming.
. Business knowledge is broad and general.
. Quantitative methods: linear programming.
. Expertise breaking a problem.
. Communication between the expertise of personal.
. Expertise builds relationships between the personal.

reference :
1. Structured Analysis &Design of Information System, Aktas, A.Ziya.Prentice-Hall, 1987
2.Structured System Analysis ; Tools and Techniques,Chris Gane and Trish Sarson.Prentice-Hall, 1979
3.System Analysis and Design A Structured Approach, William S.Davis.Massachusetts: Addison-Wesley, 1983
4.Information Systems Theory and Practice, John Burch, Gary Grudnitski, Fourth Edition;New York: John Wiley & Sons,1986

Basic Concept of Information Systems Analysis and Design

2009-02-20T19:30:00.000-08:00

Basic Concept of Information Systems Analysis and Design

Before studying what that Information Systems Analysis and Design, first we have to know what that system and what that information.

WHAT IS SYSTEM?

There are two approaching to definition of system:

1. Definition of system based on approach of procedure

According to this approach, system interpreted by as a working network from procedures which is interaction and work along to finish a specific-purpose or goal. A procedure is a correct sequences of instruction steps explaining what have to be done, who have to do, when have to be done and how to do that.

2. Definition of system based on approach of element

According to this approach the definition of system is a set of elements which is have interaction to reach specific-purpose or goal.

CHARACTERISTIC OF SYSTEM

Characteristic a system can be explained as follows:

1. Components

Consist of a number of components which interact, what each other working along to form an unity. The example is Supra System that is a larger ones system.

2. Boundary

A system has a boundary to limiting system with environmental or other system outside its.

3. Environments

Environment is a media link between a subsystem with other subsystem.

4. Input

Entered energy into system can in the form of treatment input and signal input. The treatment input is entered energy system to can walk. While signal input is energy which in process to yield output.

5. Output

The result from processed energy and classified is become an output which good for and rest of dismissal.

6. Process

Process is the change an input become output.

7. Target (objective)/goal

Otherwise have the target then system operation there will be no utilizing of. The system is told succeed if it has reach the target/its goal.

The Classification Of System

a. Deterministic System
The Certain system operate with behaviour which have earned can be predicted, interaction between its sharess can be detected categorically so that its output can be forecasted. for example of : Computer programe, executing precisely as according to its instruction network. System of pay, and others.

b. Probabilistic System
The System which is input and its process can be defined, but yielded output cannot be determined categorically; ( always there is a little mistake / deviation to forecast of the way system). for Example : marketing system)

c. Open System
The system that relation and effect external environment .This system accept input and yield output for external environment / the other sub system, so that have good operation system. This system tend to measure up to adaptation, can adapt to its environment so that can continue its.

d. Closed System
The System Physical where the process that happened do not experience of transfer of items, information or energy with environment outside system. This system work automatically without existence of interfere in of external side of it.

e. Relatively Closed System
The closed System but doesn't closed at all to accept other influences. This system in its operation can accept influence from outside which have been defined in certain boundarys.

f. Artificial System
The System imitating occurence in system. This system is formed pursuant to occurence in nature where human being unable to do it. Equally imitat exist in nature.

g. Natural System
The natural System is occurence in nature. for Example of : sea, solar system and others.

h. Manned System
The System explanations of behaviour covering human being taking part in. This system can be depicted in way of as follows:

The System of Human being focus the relations between human being
The System of Human being - Machine, System which involve machine to a target
The Machine System, automatic system where human being have duty to start and finish system, meanwhile human being entangled also to monitor system.

Information
Data is fact. Information is data that processed become better form and more meaning to accept it. If data is not useful to accept it so the data cannot be referred as by information.

QUALITY OF INFORMATION

To get information with quality, then information must have:

*
Accurately

Information free from mistakes and doesn't deflect or mislead
*
Punctually

Incoming information at receiver may not lose time
*
Relevantly

Information is have benefit for its usage.

Information will be valuable if big added significance of expense get it.