<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-3851818876120535385</id><updated>2011-04-22T12:16:06.303+07:00</updated><title type='text'>Ririn Ilkom '06</title><subtitle type='html'>tommorow is future....^-^</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://ririnilkom06.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://ririnilkom06.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>call_ririn</name><uri>http://www.blogger.com/profile/02138001931598837324</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_879af8dIsUI/ScrUBHWUnWI/AAAAAAAAABo/rk5VYqNRvK8/S220/Foto029%5B1%5D.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>8</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-3851818876120535385.post-8636454042560713009</id><published>2009-05-03T21:44:00.008+07:00</published><updated>2009-05-03T22:05:38.170+07:00</updated><title type='text'>ERD NORMALIZATION</title><content type='html'>the proses of normalizazion diagram is:&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_879af8dIsUI/Sf2uDrK5CfI/AAAAAAAAAE4/62NXBArCO_I/s1600-h/STAGE.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 201px; height: 213px;" src="http://3.bp.blogspot.com/_879af8dIsUI/Sf2uDrK5CfI/AAAAAAAAAE4/62NXBArCO_I/s200/STAGE.JPG" alt="" id="BLOGGER_PHOTO_ID_5331608912027781618" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;The initial table&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_879af8dIsUI/Sf2vAzDVmCI/AAAAAAAAAFg/jnx1VWDVKG8/s1600-h/tabel_awal.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 347px; height: 244px;" src="http://4.bp.blogspot.com/_879af8dIsUI/Sf2vAzDVmCI/AAAAAAAAAFg/jnx1VWDVKG8/s200/tabel_awal.JPG" alt="" id="BLOGGER_PHOTO_ID_5331609962115602466" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;Functional Depedencies&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_879af8dIsUI/Sf2u1hPfOFI/AAAAAAAAAFY/aERjthLmYgk/s1600-h/FD.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 340px; height: 298px;" src="http://1.bp.blogspot.com/_879af8dIsUI/Sf2u1hPfOFI/AAAAAAAAAFY/aERjthLmYgk/s200/FD.JPG" alt="" id="BLOGGER_PHOTO_ID_5331609768356165714" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Normalization 1 NF&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_879af8dIsUI/Sf2ulmlkmWI/AAAAAAAAAFQ/r6TirKSkhbk/s1600-h/1nf.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 331px; height: 225px;" src="http://2.bp.blogspot.com/_879af8dIsUI/Sf2ulmlkmWI/AAAAAAAAAFQ/r6TirKSkhbk/s200/1nf.JPG" alt="" id="BLOGGER_PHOTO_ID_5331609494913063266" border="0" /&gt;&lt;/a&gt;Normalization 2NF&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_879af8dIsUI/Sf2ua24m87I/AAAAAAAAAFI/S1eK4KN7MXU/s1600-h/2nf.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 350px; height: 159px;" src="http://1.bp.blogspot.com/_879af8dIsUI/Sf2ua24m87I/AAAAAAAAAFI/S1eK4KN7MXU/s200/2nf.JPG" alt="" id="BLOGGER_PHOTO_ID_5331609310309315506" border="0" /&gt;&lt;/a&gt;Normalization 3 NF&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_879af8dIsUI/Sf2uNWG0DtI/AAAAAAAAAFA/Bg_zXtEhtI0/s1600-h/3nf.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 299px; height: 248px;" src="http://1.bp.blogspot.com/_879af8dIsUI/Sf2uNWG0DtI/AAAAAAAAAFA/Bg_zXtEhtI0/s200/3nf.JPG" alt="" id="BLOGGER_PHOTO_ID_5331609078172225234" border="0" /&gt;&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3851818876120535385-8636454042560713009?l=ririnilkom06.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://ririnilkom06.blogspot.com/feeds/8636454042560713009/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://ririnilkom06.blogspot.com/2009/05/proses-of-normalizazion-diagram-is.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/8636454042560713009'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/8636454042560713009'/><link rel='alternate' type='text/html' href='http://ririnilkom06.blogspot.com/2009/05/proses-of-normalizazion-diagram-is.html' title='ERD NORMALIZATION'/><author><name>call_ririn</name><uri>http://www.blogger.com/profile/02138001931598837324</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_879af8dIsUI/ScrUBHWUnWI/AAAAAAAAABo/rk5VYqNRvK8/S220/Foto029%5B1%5D.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://3.bp.blogspot.com/_879af8dIsUI/Sf2uDrK5CfI/AAAAAAAAAE4/62NXBArCO_I/s72-c/STAGE.JPG' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3851818876120535385.post-8390682702259256702</id><published>2009-04-25T21:53:00.014+07:00</published><updated>2009-04-26T00:12:52.010+07:00</updated><title type='text'>Normalization</title><content type='html'>The design database is required, so that we can have a database of compact and efficient in the use of storage space, quick and easy in the initialization manipulation (add, change, delete) data.&lt;br /&gt;&lt;div  style="text-align: justify;font-family:arial;"&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Database design process &lt;/span&gt;&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Gather user needs / business &lt;/li&gt;&lt;li&gt;Develop a needs-based ER Model user / business &lt;/li&gt;&lt;li&gt;Convert E-R model to the set of relations (tables) &lt;/li&gt;&lt;li&gt;Normalization relations, to remove anomalies &lt;/li&gt;&lt;li&gt;Implemented to create a database with a table for each relationship that is normal &lt;/li&gt;&lt;/ul&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Database normalization &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Normalization process is the establishment of the database structure so that most of the ambiguity can be removed.&lt;br /&gt;The process of normalization is the process of grouping data elements into table-table that entity and show relationship. In the process of normalization is always tested in some cases, if there are difficulties at the time to add / insert, delete / delete, change / update, and read / retrieve on a Database .Normalization stage, starting from the most mild (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.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Normalization must be done because: &lt;/span&gt;&lt;br /&gt;&lt;ol&gt;&lt;li&gt;Optimizing table structures &lt;/li&gt;&lt;li&gt;Increase speed &lt;/li&gt;&lt;li&gt;The income data is the same &lt;/li&gt;&lt;li&gt;More efficient in the use of storage media &lt;/li&gt;&lt;li&gt;Reduce redundancy &lt;/li&gt;&lt;li&gt;Avoid anomalies (insertion anomalies, deletion anomalies, update anomalies). &lt;/li&gt;&lt;li&gt;Improved data integrity &lt;/li&gt;&lt;/ol&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;A table saying good (efficient) or if the normal 3 to meet the following criteria: &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;ul&gt;&lt;li&gt;If there is decomposition (decomposition) table, it must be guaranteed safe decomposes (Lossless-Join Decomposition). That is, after the table is described / decomposed a new table-table, the table-table can generate a new table with the same exact. &lt;/li&gt;&lt;li&gt;Maintain dependence on the functional changes in data (Dependency preservation).Does not violate Boyce-Code Normal Form (BCNF) &lt;/li&gt;&lt;li&gt;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). &lt;/li&gt;&lt;/ul&gt;&lt;span style="font-weight: bold;"&gt;Normalization Stage&lt;/span&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_879af8dIsUI/SfNEICzlJCI/AAAAAAAAAEw/vSN4JgPQlxQ/s1600-h/STAGE.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 231px; height: 245px;" src="http://3.bp.blogspot.com/_879af8dIsUI/SfNEICzlJCI/AAAAAAAAAEw/vSN4JgPQlxQ/s200/STAGE.JPG" alt="" id="BLOGGER_PHOTO_ID_5328677689092285474" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The process of normalization &lt;/span&gt;&lt;br /&gt;&lt;ul&gt;&lt;li&gt; Data described in the form of a table, then analyzed based on specific requirements to some level. &lt;/li&gt;&lt;li&gt;If the table has not been tested to meet specific requirements, the need to table some of the table into a more simple form to meet the optimal. &lt;/li&gt;&lt;/ul&gt;&lt;span style="font-weight: bold;"&gt;Functional Dependency &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Functional Dependency describes a relationship attributes in relation&lt;br /&gt;An attribute said functionally dependant on the other, if we use the value attribute to determine the value of the other attributes.&lt;br /&gt;Symbols used are&lt;br /&gt;to represent the functional dependency.&lt;br /&gt;reads determine the functional&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;notation : B --&gt;  A  &lt;/span&gt;&lt;br /&gt;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&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;notation : A not B or A x--&gt; B&lt;/span&gt;&lt;br /&gt;It is the opposite of the previous notation.&lt;br /&gt;&lt;br /&gt;Example :&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_879af8dIsUI/SfMyqoudZYI/AAAAAAAAADg/VMNkvWkDni4/s1600-h/Normalisasi.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 538px; height: 132px;" src="http://1.bp.blogspot.com/_879af8dIsUI/SfMyqoudZYI/AAAAAAAAADg/VMNkvWkDni4/s200/Normalisasi.JPG" alt="" id="BLOGGER_PHOTO_ID_5328658492177606018" border="0" /&gt;&lt;/a&gt; &lt;span style="font-weight: bold;"&gt;Functional Dependency:&lt;/span&gt;&lt;br /&gt;NRP --&gt; Nama&lt;br /&gt;Mata_Kuliah, NRP --&gt; Nilai&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Non Functional Dependency:&lt;/span&gt;&lt;br /&gt;Mata_Kuliah --&gt; NRP&lt;br /&gt;NRP --&gt; Nilai&lt;br /&gt;&lt;br /&gt;Functional Dependency of the table value&lt;br /&gt;Name--&gt;Nrp&lt;br /&gt;Because for each value Nrp the same, then the value of the same name&lt;br /&gt;(Mata_kuliah, NRP) --&gt;&lt;br /&gt;Because the value of attributes depending on the NRP and Mata_kuliah together. In another sense Mata_kuliah for the NRP and the same, they also rated the same, because Mata_kuliah and the NRP is a key (is unique).&lt;br /&gt;NRP not Mata_kuliah&lt;br /&gt;Value not NRP&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;FIRST NORMAL FORM (First Normal Form - 1NF)&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;A table on the form said to be normal if I did not reside in the un-normalized form of a table, where there is a kind of field multiplication and field that allows a null (empty)&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Not allowed:&lt;/span&gt;&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Many attributes of value (Multi valued attributes).&lt;/li&gt;&lt;li&gt;Attributes composite or a combination of both.&lt;/li&gt;&lt;/ul&gt;So:&lt;br /&gt;Price is the domain attribute must be atomic rates&lt;br /&gt;&lt;br /&gt;Example (1)&lt;br /&gt;E.g. Student Data as follows:&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_879af8dIsUI/SfM48EYZprI/AAAAAAAAADo/-kR6X70mMOQ/s1600-h/1NF_1.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 456px; height: 78px;" src="http://3.bp.blogspot.com/_879af8dIsUI/SfM48EYZprI/AAAAAAAAADo/-kR6X70mMOQ/s200/1NF_1.JPG" alt="" id="BLOGGER_PHOTO_ID_5328665388728821426" border="0" /&gt;&lt;/a&gt;Or&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_879af8dIsUI/SfM5YGWr8KI/AAAAAAAAADw/4wos4XefZmQ/s1600-h/1NF_2.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 444px; height: 73px;" src="http://1.bp.blogspot.com/_879af8dIsUI/SfM5YGWr8KI/AAAAAAAAADw/4wos4XefZmQ/s200/1NF_2.JPG" alt="" id="BLOGGER_PHOTO_ID_5328665870294839458" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;Table-the table above does not meet the requirements 1NF&lt;br /&gt;Example (2)&lt;br /&gt;&lt;br /&gt;Decomposition becomes:&lt;br /&gt;Student Table:&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_879af8dIsUI/SfM52EvBFcI/AAAAAAAAAD4/EvLxz6SxtDA/s1600-h/1NF_3.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 200px; height: 69px;" src="http://3.bp.blogspot.com/_879af8dIsUI/SfM52EvBFcI/AAAAAAAAAD4/EvLxz6SxtDA/s200/1NF_3.JPG" alt="" id="BLOGGER_PHOTO_ID_5328666385256093122" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;Table Hobbies:&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_879af8dIsUI/SfM6PfrEcRI/AAAAAAAAAEA/0W8MARRPWrw/s1600-h/1NF_4.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 200px; height: 130px;" src="http://3.bp.blogspot.com/_879af8dIsUI/SfM6PfrEcRI/AAAAAAAAAEA/0W8MARRPWrw/s200/1NF_4.JPG" alt="" id="BLOGGER_PHOTO_ID_5328666821984022802" border="0" /&gt;&lt;/a&gt; &lt;span style="font-weight: bold;"&gt;Second NORMAL FORM (Second Normal Form - 2NF)&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Normal form 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&lt;br /&gt;A table does not meet 2NF, if there are attributes that dependence (Functional Dependency) are only partial (only depending on the part of the primary key)&lt;br /&gt;If there are attributes that have no dependence on the primary key, then the attributes must be moved or removed&lt;br /&gt;&lt;br /&gt;Y is full if it is said to delete anàFunctional dependency X  attribute A from X means that Y is no longer dependent functional.&lt;br /&gt;Y said if deleting a partial attribute A from X means that Y is functionally dependent.àFunctional dependency X&lt;br /&gt;R depend on the full primary key fungsioanl R.ÎRelation scheme R in the form 2NF if every non-primary key attribute A&lt;br /&gt;&lt;br /&gt;Example (1)&lt;br /&gt;The following table meet 1NF, 2NF, including but not&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_879af8dIsUI/SfM7kDXuKOI/AAAAAAAAAEI/UKMUAgw1u-Q/s1600-h/2NF.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 396px; height: 138px;" src="http://4.bp.blogspot.com/_879af8dIsUI/SfM7kDXuKOI/AAAAAAAAAEI/UKMUAgw1u-Q/s200/2NF.JPG" alt="" id="BLOGGER_PHOTO_ID_5328668274675558626" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Example (2)&lt;br /&gt;Does not meet 2NF, because (NIM, KodeMk) is regarded as the primary key:&lt;br /&gt;NamaMhs   --&gt; (NIM, KodeMk)&lt;br /&gt;Address       --&gt; (NIM, KodeMk)&lt;br /&gt;Matakuliah --&gt; (NIM, KodeMk)&lt;br /&gt;SKS              --&gt; (NIM, KodeMk)&lt;br /&gt;NilaiHuruf  --&gt;(NIM, KodeMk)&lt;br /&gt;Table needs to be some table decomposition  eligible 2NF&lt;br /&gt;&lt;br /&gt;Example (3)&lt;br /&gt;Functional dependency as follows:&lt;br /&gt;(NIM, KodeMk) --&gt; NilaiHuruf (fd1)&lt;br /&gt;NIM                     --&gt; (NamaMhs, Address) (fd2)&lt;br /&gt;KodeMk               --&gt; (Matakuliah, SKS) (fd3)&lt;br /&gt;So that:&lt;br /&gt;fd1 (NIM, KodeMk, NilaiHuruf) --&gt; Value Table&lt;br /&gt;fd2 (NIM, NamaMhs, Address) --&gt; Student Table&lt;br /&gt;fd3 (KodeMk, Matakuliah, SKS) --&gt; MataKuliah Table&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;NORMAL FORM Third (Third Normal Form - 3NF) &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Normal form 3NF fulfilled 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).&lt;br /&gt;Example (1)&lt;br /&gt;Table following students eligible 2NF, 3NF, but does not meet&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_879af8dIsUI/SfM_w5jIGzI/AAAAAAAAAEQ/KMqXTJ-tCRQ/s1600-h/3NF.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 274px; height: 72px;" src="http://1.bp.blogspot.com/_879af8dIsUI/SfM_w5jIGzI/AAAAAAAAAEQ/KMqXTJ-tCRQ/s200/3NF.JPG" alt="" id="BLOGGER_PHOTO_ID_5328672893423852338" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;Because there are non-primary key attribute (i.e., City and Provincial), which has a dependence on non-primary key attributes of the other (i.e. KodePos):&lt;br /&gt;(City, Province)àKodePos&lt;br /&gt;&lt;br /&gt;Example (2)&lt;br /&gt;So that the table should be decomposition:&lt;br /&gt;Student (NIM, NamaMhs, Road, KodePos) &lt;b&gt;r&gt;KodePos (KodePos, Province, City) &lt;/b&gt;&lt;br /&gt;&lt;br /&gt;Example 3&lt;br /&gt;A model data meets said third normal form if it meets the form of both normal and does not have the attributes of non-identifying (non-unique identifier) that  depending on the attributes of other non-identifying. If there is, separate one of these attributes a new entity, and attributes that depend on the attributes to become the new entity.&lt;br /&gt;In a simple data model that we use here, none of non-identifying attributes (such as Task Mata kuliah description, or name Lecturer), which depends on the attributes non identifying other. But for the sake of example, we have Lecturer e.g entity attributes information Home Address and Phone Number House. Both can not be unique identify the object of a certain entity Lecturer, but both are mutually dependent.&lt;br /&gt;As in the previous two-step normalization, as this type of dependences&lt;br /&gt;can be removed by creating a new entity (which will not be created because the three&lt;br /&gt;entities have been enough for one article).&lt;br /&gt;Last model that we can meet this third normal form (third normal form)&lt;br /&gt;and ready to convert into a table. But before, we need to discuss the various types of&lt;br /&gt;relations, which are often found in data modeling, including those we met in the example model&lt;br /&gt;data this time.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Boyce-Codd Normal Form (BNCF) &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Boyce-Codd Normal Form constraint has a stronger form of the Normal third. To be BNCF, relations must be in the form of Normal once and forced each of the attributes depends on the function in the super key attributes.&lt;br /&gt;In the example below there is a relationship seminar, is the Primary Key NPM + Seminar.&lt;br /&gt;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.&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_879af8dIsUI/SfNAlLT4cZI/AAAAAAAAAEY/dRg4RwuO8ak/s1600-h/BCNF2.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 345px; height: 132px;" src="http://2.bp.blogspot.com/_879af8dIsUI/SfNAlLT4cZI/AAAAAAAAAEY/dRg4RwuO8ak/s200/BCNF2.JPG" alt="" id="BLOGGER_PHOTO_ID_5328673791544947090" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Relations Seminar is a form of Third Normal, but not BCNF&lt;br /&gt;Seminar Code because the function depends on the Pembimbing, if any Pembimbing can only teach a seminar. Seminar depend on one key attribute is not as super disayaratakan by BCNF. So&lt;br /&gt;Seminar relations must be parsed into two namely:&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_879af8dIsUI/SfNA3AXmfBI/AAAAAAAAAEg/NVCyIaBpkmA/s1600-h/BCNF3.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 346px; height: 96px;" src="http://4.bp.blogspot.com/_879af8dIsUI/SfNA3AXmfBI/AAAAAAAAAEg/NVCyIaBpkmA/s200/BCNF3.JPG" alt="" id="BLOGGER_PHOTO_ID_5328674097845402642" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Normal form of the fourth and fifth&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Relations in the fourth normal form (NF 4) if the relation in BCNF and dependency tdak 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.&lt;br /&gt;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.&lt;br /&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3851818876120535385-8390682702259256702?l=ririnilkom06.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://ririnilkom06.blogspot.com/feeds/8390682702259256702/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://ririnilkom06.blogspot.com/2009/04/normalization.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/8390682702259256702'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/8390682702259256702'/><link rel='alternate' type='text/html' href='http://ririnilkom06.blogspot.com/2009/04/normalization.html' title='Normalization'/><author><name>call_ririn</name><uri>http://www.blogger.com/profile/02138001931598837324</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_879af8dIsUI/ScrUBHWUnWI/AAAAAAAAABo/rk5VYqNRvK8/S220/Foto029%5B1%5D.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://3.bp.blogspot.com/_879af8dIsUI/SfNEICzlJCI/AAAAAAAAAEw/vSN4JgPQlxQ/s72-c/STAGE.JPG' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3851818876120535385.post-985824289506542313</id><published>2009-04-19T12:06:00.006+07:00</published><updated>2009-04-19T12:37:31.857+07:00</updated><title type='text'>DATABASE AND ER-Diagram</title><content type='html'>&lt;span style="font-weight: bold;"&gt;DEFINITION Database &lt;/span&gt;&lt;br /&gt;&lt;div style="text-align: justify;"&gt;&lt;br /&gt;Definition of the database:&lt;br /&gt;&lt;span style="font-weight: bold; font-style: italic;"&gt;A set of data stored in the magnetic disk, optical disk or other secondary storage &lt;/span&gt; &lt;span style="font-weight: bold; font-style: italic;"&gt;Collection of integrated data-related data of an enterprise (company, government or private) &lt;/span&gt; &lt;span style="font-weight: bold; font-style: italic;"&gt;Is a system which consists of collection of the file (table) in a database in a computer system and a related set of data base management program (DBMS: Database Management System) that allows several users and / or other programs for acess and manipulate files ( table-table) is &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;for example: &lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;ul style="text-align: justify;"&gt;&lt;li&gt;Manufacturing companies have data in form of production planning data,actual production data,cmaterial ordering data&lt;br /&gt;&lt;/li&gt;&lt;/ul&gt;&lt;ul style="text-align: justify;"&gt;&lt;li&gt;The hospital has a patient data form of data, doctor, nurse, etc. &lt;/li&gt;&lt;/ul&gt;&lt;div style="text-align: justify;"&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;DATABASE MANAGEMENT SYSTEM (DBMS)&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;definition&lt;br /&gt;&lt;span style="font-weight: bold; font-style: italic;"&gt;Collection / database combined with software applications that are based database &lt;/span&gt; &lt;span style="font-weight: bold; font-style: italic;"&gt;Application programs are used to access and maintain databases &lt;/span&gt; &lt;span style="font-weight: bold; font-style: italic;"&gt;The main purpose DBMS is to provide an environment that is efficient and easy to use, withdrawal and storage of data and information.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-weight: bold; font-style: italic;"&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-weight: bold; font-style: italic;"&gt;&lt;/span&gt;&lt;span style="font-weight: bold;"&gt;Benefits of DBMS &lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;ol style="text-align: justify;"&gt;&lt;li&gt;Reducing the repetition of data. &lt;/li&gt;&lt;li&gt;Achieve independence of the data.Specification data stored in each application program.Changes can be made on the structure of data without affecting programs that access the data. &lt;/li&gt;&lt;li&gt;Integrating data from multiple files.When the file was so provide a logical connection, the organization is no longer a physical constraint. &lt;/li&gt;&lt;li&gt;Retrieve data and information quickly.Relationships logical query language allows users to take data in seconds or minutes. &lt;/li&gt;&lt;li&gt;Increase security.Both DBMS Mainframe and micro-computer can include multiple layers such as password security, user directory, language and a password. &lt;/li&gt;&lt;/ol&gt;&lt;div style="text-align: justify;"&gt;&lt;span style="font-weight: bold;"&gt;  Losses DBMS &lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;ol style="text-align: justify;"&gt;&lt;li&gt;Obtain the expensive software. &lt;/li&gt;&lt;li&gt;Obtain the configuration of the hardware. &lt;/li&gt;&lt;li&gt;Need for DBA and retain staff. &lt;/li&gt;&lt;/ol&gt;&lt;div style="text-align: justify;"&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;BIT, BYTE, Field &lt;/span&gt;&lt;br /&gt;Data&lt;span style="font-weight: bold;"&gt; bit &lt;/span&gt;is the part that contains the smallest value of 0 or 1&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Byte&lt;/span&gt; is a set of bit-bit similar with the same 1 byte with 8 bits&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Field &lt;/span&gt;is a set of byte-byte similar, in the database used the term attribute&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;ER Diagram Components &lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;ul style="text-align: justify;"&gt;&lt;li&gt;Entity &lt;/li&gt;&lt;li&gt;Attribute &lt;/li&gt;&lt;li&gt;Relationship (between entities): &lt;/li&gt;&lt;li&gt;Relationship types &lt;/li&gt;&lt;li&gt;Role &lt;/li&gt;&lt;li&gt;Cardinality &lt;/li&gt;&lt;/ul&gt;&lt;div style="text-align: justify;"&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Attribute / Field &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;It is the nature or characteristics of an entity that provides provide detail on these entities. &lt;/span&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;For example&lt;/span&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;&lt;/span&gt;an employee has a name, SSN, address, gender, date of birth.&lt;br /&gt;One entity will have specific values for each attribute&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;For example&lt;/span&gt;&lt;br /&gt;a particular employee has the name John Smith, SSN: ... .. Address: Sex: Birthdates: January 5 55&lt;br /&gt;each attribute has a set of values associated with it.&lt;br /&gt;This value is a set of data types, such as integer, string, and the other,&lt;br /&gt;And can also be given a certain range, e.g., date of birth of employee&lt;br /&gt;A relationship can also have attributes&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;TYPE-TYPE Attribute &lt;/span&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Single vs. multi value &lt;/span&gt;&lt;br /&gt;Single&lt;br /&gt;can only be filled at most one value&lt;br /&gt;Each entity has a single atomic value&lt;br /&gt;Example: SSN, Sex.&lt;br /&gt;&lt;br /&gt;Multi value&lt;br /&gt;can be filled with more than one value with the same type of&lt;br /&gt;an entity can have multiple values&lt;br /&gt;Example:&lt;br /&gt;Color of a CAR&lt;br /&gt;Degree of employee&lt;br /&gt;Expressed as: (color), (title).&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Atomic vs. composition &lt;/span&gt;&lt;br /&gt;Atomic&lt;br /&gt;can not be divided into the attributes of smaller&lt;br /&gt;Composition&lt;br /&gt;is a combination of several attributes of a smaller&lt;br /&gt;Example:&lt;br /&gt;Address (Apt #, House #, Street, City, State, Zip Code, Country)&lt;br /&gt;Name (first name, Middle Name, Last Name).&lt;br /&gt;The composition can be a hierarchy where the attribute is also a component of composite attribute.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Derived attribute &lt;/span&gt;&lt;br /&gt;attribute value can be derived from other attribute values,&lt;br /&gt;e.g. age resulting from the date of birth attribute&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Null Value attribute &lt;/span&gt;&lt;br /&gt;Attributes that have no value to a record&lt;br /&gt;attribute can have a null value if:&lt;br /&gt;&lt;/div&gt;&lt;ul style="text-align: justify;"&gt;&lt;li&gt;Not applicable, e.g. the name for the couple people who are not married &lt;/li&gt;&lt;li&gt;Missing: The value but there is not yet known. E.g. high body someone. &lt;/li&gt;&lt;li&gt;Not known: You do not know if the value is there. E.g. home phone number. &lt;/li&gt;&lt;/ul&gt;&lt;div style="text-align: justify;"&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Mandatory attribute Value &lt;/span&gt;&lt;br /&gt;Attributes must have values&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;RECORD / TUPLE &lt;/span&gt;&lt;br /&gt;It is a line of data in a relationship&lt;br /&gt;Consists of the set of attributes where the attribute-attribute-attribute is to inform each other entity / relationship fully&lt;br /&gt;Record is a collection of field-field is structured in a format that has been determined.&lt;br /&gt;During the design of the system, records will be classified as fixed-length records or variable-length record.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Entity / FILE &lt;/span&gt;&lt;br /&gt;File is a collection of similar records and have the same elements, the same attributes but different data value&lt;br /&gt;A entities is an "object" (thing) or "object" (object) in the real world that&lt;br /&gt;can be distinguished from all other objects. Entity sets are a set of entities&lt;br /&gt;have the same type. This type of similarity can be seen from the attribute / property that&lt;br /&gt;owned by the individual entities. E.g., group of people who save money on a&lt;br /&gt;bank entities can be defined as a set of customers&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;&lt;div style="text-align: justify;"&gt;&lt;span style="font-weight: bold;"&gt;File Type &lt;/span&gt;&lt;br /&gt;In processing applications, files can categorized as follows:&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Master File &lt;/li&gt;&lt;li&gt;Transaction File &lt;/li&gt;&lt;li&gt;File Report &lt;/li&gt;&lt;li&gt;File History &lt;/li&gt;&lt;li&gt;File Protection &lt;/li&gt;&lt;li&gt;Job File &lt;/li&gt;&lt;/ul&gt;&lt;span style="font-weight: bold;"&gt;DOMAIN &lt;/span&gt;&lt;br /&gt;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&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Element KEY DATA &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;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 . selection key attributes is important in the design of the database because:&lt;br /&gt;&lt;ul&gt;&lt;li&gt;to affect validation of data integrity and performance database &lt;/li&gt;&lt;li&gt;With declare an attribute as the key and declare 'not allowed duplicates' will prevent the user entering the same data that is not desired &lt;/li&gt;&lt;li&gt;A key will be how to maintain the integrity of the key with another key on the table. &lt;/li&gt;&lt;/ul&gt;Elections key attributes:&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Key is an attribute that does not change. Example: SSN, employee_ID, SKU (stock-keeping-units), license plate number. &lt;/li&gt;&lt;li&gt;Key values can not be null, must have a valid value. Example: Date of students is a bad choice to be a key. &lt;/li&gt;&lt;li&gt;Avoid the key that has a certain intelligence or codes built in. Examples: building codes (which can be changed later) &lt;/li&gt;&lt;/ul&gt;&lt;span style="font-weight: bold;"&gt;SPECIES OF KEY &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Super key&lt;/span&gt; is one 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)&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Candidate Key&lt;/span&gt; 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.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Primary Key &lt;/span&gt;&lt;br /&gt;One of the key attributes of the candidate can be selected / specified a primary key with the three following criteria:&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Key is more natural to use as reference &lt;/li&gt;&lt;li&gt;Key is more simple &lt;/li&gt;&lt;li&gt;Key is guaranteed unique &lt;/li&gt;&lt;/ul&gt;&lt;span style="font-weight: bold;"&gt;Alternate Key&lt;/span&gt; is an attribute of the candidate key is not selected to be primary key.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Foreign Key&lt;/span&gt; is any attribute that points to the primary key in another table. Foreign key will be going on a relationship that has cardinalities 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.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;External Key &lt;/span&gt;is a lexical attribute (or set of lexical attributes) that values are always identify an object instance.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;ERD (Entity Relationship Diagram) &lt;/span&gt;&lt;br /&gt;ERD is a model of a network that uses word order is stored in the abstract system.&lt;br /&gt;Differences between the DFD and ERD&lt;br /&gt;DFD is a model of network functions that will be implemented by the system&lt;br /&gt;ERD is a model that emphasizes the network data on the structure and relationship data&lt;br /&gt;Elements of the ERD&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Entity &lt;/span&gt;&lt;br /&gt;In the ER Diagram Entity is described with the form of a rectangle. Entity is something that exists in the real system and the abstract where the data stored or where there are data.&lt;br /&gt;Relationship&lt;br /&gt;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  relation.&lt;br /&gt;A relationship connecting the two / more different entity with a specific meaning.&lt;br /&gt;Example:&lt;br /&gt;EMPLOYEE John Smith works on the ProductX PROJECT&lt;br /&gt;EMPLOYEE Franklin Wong manages the Research DEPARTMENT.&lt;br /&gt;&lt;br /&gt;Type relationships that are grouped together into a single type. Example:&lt;br /&gt;WORKS_ON relationship type in which employees participate and PROJECTS&lt;br /&gt;MANAGES relationship type in which employees participate and Departments.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Degree of relationship &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;is the number of entities participating in a relationship. Degree which is often used in the ERD. &lt;/span&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Unary Relationship &lt;/span&gt;&lt;br /&gt;model is the relationship between the entity originating from the same entity set.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Binary Relationship &lt;/span&gt;&lt;br /&gt;model is the relationship between 2 entities.&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_879af8dIsUI/Seq19CRTGEI/AAAAAAAAAC4/EB0rzEvc2Y0/s1600-h/binary_relationship.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 200px; height: 125px;" src="http://4.bp.blogspot.com/_879af8dIsUI/Seq19CRTGEI/AAAAAAAAAC4/EB0rzEvc2Y0/s200/binary_relationship.JPG" alt="" id="BLOGGER_PHOTO_ID_5326269569505105986" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Ternary Relationship &lt;/span&gt;&lt;br /&gt;is a relationship between the instance of 3 types of entities are unilateral.&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_879af8dIsUI/Seq2IoDmCUI/AAAAAAAAADA/6CfGs2OmZzk/s1600-h/ternary.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 200px; height: 125px;" src="http://1.bp.blogspot.com/_879af8dIsUI/Seq2IoDmCUI/AAAAAAAAADA/6CfGs2OmZzk/s200/ternary.JPG" alt="" id="BLOGGER_PHOTO_ID_5326269768626735426" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Cardinalities &lt;/span&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;tupel  indicates the maximum number that can be relation with entities on the other entity &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;There are 3 cardinalities relations, namely&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;One to One&lt;/span&gt;: 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.&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_879af8dIsUI/Seq2USKuiHI/AAAAAAAAADI/Dv4yIV1lIr4/s1600-h/one+to+one.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 200px; height: 125px;" src="http://4.bp.blogspot.com/_879af8dIsUI/Seq2USKuiHI/AAAAAAAAADI/Dv4yIV1lIr4/s200/one+to+one.JPG" alt="" id="BLOGGER_PHOTO_ID_5326269968909502578" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;One to Many or Many to One&lt;/span&gt;: Level one to many relationship is the same as the one to many depending on the direction from which the relationship seen  .for  an incident on the first entity can have any relationship with more incident on the second entity, if the one incident on the entity the second can only have one relation with the incident on the first entity.&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_879af8dIsUI/Seq2fiYMCHI/AAAAAAAAADQ/S3E1WWAGO_A/s1600-h/many+to+one.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 200px; height: 128px;" src="http://3.bp.blogspot.com/_879af8dIsUI/Seq2fiYMCHI/AAAAAAAAADQ/S3E1WWAGO_A/s200/many+to+one.JPG" alt="" id="BLOGGER_PHOTO_ID_5326270162239490162" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Many To Many: &lt;/span&gt;if any incident occurs in an entities  have relationships with other entities in the incident.&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_879af8dIsUI/Seq2qL52jUI/AAAAAAAAADY/C9kAjaHaJGk/s1600-h/many+to+many.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 200px; height: 125px;" src="http://3.bp.blogspot.com/_879af8dIsUI/Seq2qL52jUI/AAAAAAAAADY/C9kAjaHaJGk/s200/many+to+many.JPG" alt="" id="BLOGGER_PHOTO_ID_5326270345185234242" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;reference&lt;br /&gt;Elmasri &amp;amp; Navathe, Fundamental of Database Systems, 5th Edition, Chapter 1, 2007&lt;br /&gt;&lt;div style="text-align: left;"&gt;DATABASE and ER-DIAGRAM persentation of NGURAH AGUS SANJAYA ER, S.KOM,&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3851818876120535385-985824289506542313?l=ririnilkom06.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://ririnilkom06.blogspot.com/feeds/985824289506542313/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://ririnilkom06.blogspot.com/2009/04/database-and-er-diagram.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/985824289506542313'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/985824289506542313'/><link rel='alternate' type='text/html' href='http://ririnilkom06.blogspot.com/2009/04/database-and-er-diagram.html' title='DATABASE AND ER-Diagram'/><author><name>call_ririn</name><uri>http://www.blogger.com/profile/02138001931598837324</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_879af8dIsUI/ScrUBHWUnWI/AAAAAAAAABo/rk5VYqNRvK8/S220/Foto029%5B1%5D.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://4.bp.blogspot.com/_879af8dIsUI/Seq19CRTGEI/AAAAAAAAAC4/EB0rzEvc2Y0/s72-c/binary_relationship.JPG' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3851818876120535385.post-2230009204022472486</id><published>2009-04-04T22:14:00.003+07:00</published><updated>2009-04-04T22:27:40.235+07:00</updated><title type='text'>Data Flow Diagram</title><content type='html'>&lt;span style="font-size:100%;"&gt;&lt;span style="font-weight: bold;"&gt;Definition&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;DFD is a logical data model or process that is made to describe the origin of the data and the destination where the data out of the system, where data is stored, the process that produces the data and the interaction between the data stored and the process is imposed on data.&lt;br /&gt;DFD are often used to describe a system that already exists or the new system will be developed logically without considering the physical environment where the data flows, or where data are stored and the user is less easy to understand to understand the field of computer systems that will be done.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Context Diagram&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;the top level diagram, a diagram of a system that describes the stream-flow data that enter and exit the system and the incoming and&lt;br /&gt;out of the foreign entity&lt;br /&gt;The case must be considered:&lt;br /&gt;Provide a snapshot of the entire system&lt;br /&gt;Terminals that provide input to system called source&lt;br /&gt;Terminal that receives the output called sinks&lt;br /&gt;Only one process&lt;br /&gt;Consists of a process and describe the scope of a system&lt;br /&gt;Is the highest level of the DFD that describes the entire system to the input of the system and output&lt;br /&gt;System is limited by Boundary (depicted by broken lines)&lt;br /&gt;No storage (storage)&lt;br /&gt;how to create a context diagram&lt;br /&gt;Specify the name of the system.&lt;br /&gt;Determine the limits of the system.&lt;br /&gt;Specify the terminator is present in the system.&lt;br /&gt;Define what is received / given terminator from / to the system.&lt;br /&gt;Describe context diagram.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Zero Diagram&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;After making context will proceed with the making of:&lt;br /&gt;DFD level 0 context diagram is a representation of more detailed (overview diagram) and to give a view on the overall system in which, showing the main function or process that is, the flow of data and entity external&lt;br /&gt;It should be:&lt;br /&gt;At this level of data storage possible&lt;br /&gt;To process that does not detail again on the next level then added to the symbol '*' or 'P' at the end of the process&lt;br /&gt;Balance of input and output (balancing) between 0 to diagram context diagram should be maintained&lt;br /&gt;&lt;br /&gt;how to create a zero diagram:&lt;br /&gt;Determine the main process in the system.&lt;br /&gt;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).&lt;br /&gt;If necessary, store a feature data (master) as the source and destination flow data.&lt;br /&gt;describe diagram level zero.&lt;br /&gt;- Avoid intersection flow data&lt;br /&gt;- Give the number on the main process (the number does not indicate the order process).&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Detailed Diagram&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;is diagrams that decompose a process that is in the diagram zero level or above&lt;br /&gt;Numbering level in the DFD:&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_879af8dIsUI/Sdd65T8faUI/AAAAAAAAACg/QZRyp8mJJqE/s1600-h/detail.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 162px;" src="http://2.bp.blogspot.com/_879af8dIsUI/Sdd65T8faUI/AAAAAAAAACg/QZRyp8mJJqE/s320/detail.JPG" alt="" id="BLOGGER_PHOTO_ID_5320856609786652994" border="0" /&gt;&lt;/a&gt;In one level there should be no more than 7 units and the maximum of 9, when more should be done in the decomposition&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;DFD level 1:&lt;br /&gt;Each process level 0 will described the details must be observed:&lt;br /&gt;�� balance the flow of data between zero diagram and detailed diagrams In the process&lt;br /&gt;&lt;br /&gt;�� not detail again, add a sign * at the end of the numbering process Balance&lt;br /&gt;&lt;br /&gt;�� data store used&lt;br /&gt;How:&lt;br /&gt;Define the process of smaller (sub-process) from the main process in the zero level.&lt;br /&gt;Determine what is given / received each sub-process to / from the system and note the concept of balance.&lt;br /&gt;If necessary, store a feature data (transaction) as the source and destination flow data.&lt;br /&gt;One describe level DFD&lt;br /&gt;- Avoid intersection flow of data.&lt;br /&gt;- Give the number on each sub-process that shows the decomposition of the process before.&lt;br /&gt;Example: 1.1, 1.2, 2.1&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;SPECIFICATION PROCESS&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Each process in the DFD must have a specification process&lt;br /&gt;At the top level method is used to describe the process can use a sentence with descriptive&lt;br /&gt;At a more detailed level, namely on the bottom (functional primitive) requires specification of a more structured&lt;br /&gt;Specification process will be the guideline for the programmer to make this program (coding)&lt;br /&gt;Method used in the specification process: the process of disintegration in the form of a story, decision table, decision tree&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;ON FOREIGN (foreign entities)&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Foreign entity is the entity that is outside the system that provides data to the system (source) or receive information from the system (sinks) that are in the outside environment that will provide input or receive output from the system. Foreign entity is not part of the system, when an information system designed for one section / department and other parts that are still related to a foreign entity. While the terminal is the entity that is part of the system.&lt;br /&gt;Something that is outside the system, but it provides data in the system or to provide data from the system&lt;br /&gt;for example:&lt;br /&gt;- An office, department or division within the company but outside the system being developed.&lt;br /&gt;- The person or group of people in the organization but outside of that system is being developed.&lt;br /&gt;symbolized with the notation&lt;br /&gt;External entity not part of the system including&lt;br /&gt;Naming:&lt;br /&gt;The name of the form of noun&lt;br /&gt;Terminal may not have the same name except the same objeknya&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;CASH DATA&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Is the place to make a flow an information&lt;br /&gt;Depicted with the straight line that connects the components of the system&lt;br /&gt;Data flow direction is indicated with arrows and lines give the name on the flow of data that flows&lt;br /&gt;Flow data flow between processes, data storage and data flow indicates that the form of data input for the system&lt;br /&gt;&lt;br /&gt;Data flow describes the flow of data from one entity to another entity. The direction the arrow depicts the flow of data. There are several streams of data, namely:&lt;br /&gt;• Between the two processes in sequence&lt;br /&gt;• from data storage (data store) to the process and vice versa&lt;br /&gt;• From the source to the process&lt;br /&gt;• From the process to sink&lt;br /&gt;&lt;br /&gt;Guidelines of the name:&lt;br /&gt;Name of the flow of data that consists of some words associated with the flow lines connect&lt;br /&gt;No flow data for the same and the name should reflect its content&lt;br /&gt;The flow of data that consists of several elements can be expressed with the group element&lt;br /&gt;Avoid using the word 'data' and 'information' to give a name to the flow of data&lt;br /&gt;Wherever possible the complete flow of data is written&lt;br /&gt;Other provisions in the current data:&lt;br /&gt;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&lt;br /&gt;Data flow into or out of data storage does not need to be given a name if:&lt;br /&gt;The flow of data simple and easy to understand&lt;br /&gt;Describes the data flow of all data items&lt;br /&gt;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 a process&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;PROCESS&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Describe what the process done by the system. 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 data inputs and generates one or more output data. The process also often called bubble. For Physical data flow diagrams (LDFD), the process can be done by a person, machine or computer and for Logical data flow diagram is a process only shows the process of computer&lt;br /&gt;Symbols used: circle&lt;br /&gt;Guidelines of the process:&lt;br /&gt;Name of the process consists of a verb and noun, which reflects the function of the process&lt;br /&gt;Do not use the process as part of the name of a bubble&lt;br /&gt;May not have some process that has the same name&lt;br /&gt;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&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Data Storage&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Data storage is a storage place for data that exists in the system&lt;br /&gt;symbolized with a pair of parallel lines or two lines with one side open side&lt;br /&gt;The process can retrieve data from or provide data to the database&lt;br /&gt;Savings can be the following data:&lt;br /&gt;1.file or database in the computer system&lt;br /&gt;2.manual record keeping or&lt;br /&gt;3.the data in a table&lt;br /&gt;4.table reference manual&lt;br /&gt;5. agenda book&lt;br /&gt;Guidelines of the name:&lt;br /&gt;The name should reflect the data storage&lt;br /&gt;When his name more than one word must be marked with the number&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;DFD Symbols&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_879af8dIsUI/Sdd7JRi8wKI/AAAAAAAAACo/GS0K3sm-17c/s1600-h/simbol2.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 270px;" src="http://3.bp.blogspot.com/_879af8dIsUI/Sdd7JRi8wKI/AAAAAAAAACo/GS0K3sm-17c/s320/simbol2.JPG" alt="" id="BLOGGER_PHOTO_ID_5320856884020560034" border="0" /&gt;&lt;/a&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_879af8dIsUI/Sdd7ed0NEDI/AAAAAAAAACw/YCOR6rOFHWE/s1600-h/simbol.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 284px; height: 320px;" src="http://4.bp.blogspot.com/_879af8dIsUI/Sdd7ed0NEDI/AAAAAAAAACw/YCOR6rOFHWE/s320/simbol.JPG" alt="" id="BLOGGER_PHOTO_ID_5320857248091410482" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Dictionary of Data (Catalog Data)&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Is a catalog (storage) of the elements that are in a system. Data dictionary has the same function in modeling the system and also help the system to understand the application in detail, and organize all elements of the data used in the system so that users and analyze system have basic understanding about the same input, output, storage and processing.&lt;br /&gt;&lt;br /&gt;Data dictionary defines the data elements with the function as follows:&lt;br /&gt;1. Explain the meaning of the data flow and storage in the DFD&lt;br /&gt;2. Describe your composition package moving through the data flow to be described, for example address city, state and zip code&lt;br /&gt;3. Describe your data storage composition&lt;br /&gt;4. Specify the value and the relevant unit for the storage and flow and&lt;br /&gt;5. Describe your relationship between the details of storage that will be the focus point in the diagram entity relationship&lt;br /&gt;&lt;br /&gt;Working data dictionary 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&lt;br /&gt;At analysis, the data dictionary is used as a means of communication between the systems analyst with the&lt;br /&gt;At the system design, data dictionary is used to design input, reports and databases&lt;br /&gt;Flow data on the global DAD, further details can be seen in the data dictionary&lt;br /&gt;Load the data dictionary as follows:&lt;br /&gt;Name of data flow: must note that readers who need further explanation about a flow of data can find it easily&lt;br /&gt;Alias: alias or other name of the data can be written when there is&lt;br /&gt;Forms of data: used to segment the data dictionary to use when designing the system&lt;br /&gt;Flow data: indicates from which data flows and where the data&lt;br /&gt;Description: to give an explanation of the meaning of the data flow&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Balancing IN DFD&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;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&lt;br /&gt;Name of the data flow into and out of the process must match the name of the flow of data into and out of the details of the process&lt;br /&gt;Number and the name of an entity outside the process must be equal to the number of names and entities outside of the details of the process&lt;br /&gt;The issues that must be considered in the DFD which have more than one level:&lt;br /&gt;There must be a balance between input and output of one level and next level&lt;br /&gt;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 / output of stream data to / from the process concerned&lt;br /&gt;Name of the flow of data, data storage and terminals at each level must be the same if the same object&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Restrictions in DFD&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Flow data may not be from outside the entity directly to other outside entities without going through a process&lt;br /&gt;Flow data may not be from the savings directly to the data to outside entities without going through a process&lt;br /&gt;Flow data may not be saving the data directly from the savings and other data without going through a process&lt;br /&gt;Flow data from one process directly to the other without going through the process of saving data should / be avoided as much as possible&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3851818876120535385-2230009204022472486?l=ririnilkom06.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://ririnilkom06.blogspot.com/feeds/2230009204022472486/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://ririnilkom06.blogspot.com/2009/04/data-flow-diagram.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/2230009204022472486'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/2230009204022472486'/><link rel='alternate' type='text/html' href='http://ririnilkom06.blogspot.com/2009/04/data-flow-diagram.html' title='Data Flow Diagram'/><author><name>call_ririn</name><uri>http://www.blogger.com/profile/02138001931598837324</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_879af8dIsUI/ScrUBHWUnWI/AAAAAAAAABo/rk5VYqNRvK8/S220/Foto029%5B1%5D.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://2.bp.blogspot.com/_879af8dIsUI/Sdd65T8faUI/AAAAAAAAACg/QZRyp8mJJqE/s72-c/detail.JPG' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3851818876120535385.post-7180473716084307561</id><published>2009-03-28T16:13:00.000+07:00</published><updated>2009-03-28T16:42:19.978+07:00</updated><title type='text'>Initial Investigation and Requirement Analysis</title><content type='html'>&lt;div style="text-align: justify;"&gt;&lt;span style="font-size:130%;"&gt;&lt;span style="font-weight: bold;"&gt;Initial Investigation&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Problem (problem) is inequalities gap between the goal system and the actual system conditions, with the understanding why other systems failed to achieve the goals that the system has been determined previously. To know the things that have been what caused the failure of the system, and then an analyst should do more investigation before take action to improve the system. With the investigation, an analyst will better understand the problem and the flow system further, detect even in the already known problem but the problem still describes the size of the course.&lt;br /&gt;Many reports in the detection problem may not actually be real or cannot be solved. This may be because:&lt;br /&gt;a. Goals that are too difficult or the ideal so that might not be reached.&lt;br /&gt;b. The system cannot be developed because of lack of resources, attitudes or     both.&lt;br /&gt;c. Measurement system that is not accurate.&lt;br /&gt;d. Statement of purpose of the system that is behind (statement of goals is dated).&lt;br /&gt;e. The gap between the ideal system and the system at this time is  while (the gap between the ideal and the current system is temporary and will decrease given patience).&lt;br /&gt;&lt;br /&gt;In solving the problem, should provide an explanation of:&lt;br /&gt;a. explain condition of the system that runs through the investigation in detail.&lt;br /&gt;b. Getting a consensus that the ideal system.&lt;br /&gt;c. Develop alternatives to reduce some of the differences (gaps)    between the ideal system with which the system is running.&lt;br /&gt;d. Selecting the best alternative and sell it to management.&lt;br /&gt;&lt;br /&gt;Task start point b to d will take a very long time, including cost is required. The objective of the investigation is to stabilize or indicate a problem that actually occurs in addition as a way&lt;br /&gt;an analyst to understand the system in depth.&lt;br /&gt; &lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Constraints in the system of investigation &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;in doing some investigation, there are obstacles or constraints that will occur, among other issues:&lt;br /&gt;a. Time (time)&lt;br /&gt;    Analysts lack of resources (resource) time, so only do part of the investigation. Usually time-related problems cost is required.&lt;br /&gt;b. Cost (cost)&lt;br /&gt;    often the costs incurred related to the length of time for  investigation activities, so that management will give the limits of cost.&lt;br /&gt;c. Science (knowledge)&lt;br /&gt;    Manager information systems tend Junior told analysts that have not been have the technical expertise or knowledge is sufficient, so that will be impact on the results of investigations that are less deep, mature or complete.&lt;br /&gt;d. Politics (politics)&lt;br /&gt;    Management or the parties may distribute certain issues which purpose is to restrict the investigation activities.&lt;br /&gt;e. Interference (interference)&lt;br /&gt;    there are parties who try to intervene or investigation in activities that will disrupt or cause&lt;br /&gt;    chaos.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt; Recommendations &lt;/span&gt;&lt;br /&gt; &lt;br /&gt;Results of the investigation is a recommendation, which is one of them as follows:&lt;br /&gt;a. Does not take any action because it found no problems.&lt;br /&gt;    This can happen as they may in the preliminary report, problem is contrived so that the investigation conducted at the time of issue the problem does not happen or was not found.&lt;br /&gt;b. Perform system maintenance for problems that small.&lt;br /&gt;    Maintenance of the system that made every day (short period) will be help minimize the problems that arise so quickly to and are always treated well.&lt;br /&gt;c. Or improve skills in the run or the user&lt;br /&gt;    using information systems.&lt;br /&gt;d. Consider modifications to the system in total, so the need to&lt;br /&gt;    thought to replace it with a new system.&lt;br /&gt;e. Place going into the development plan system which is done immediately.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt; Strategy of Investigation &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;the strategy is needed for investigation to discovering the problem and to knowing caused the problem.&lt;br /&gt;There are strategies of investigation it can be done, the several as follows:&lt;br /&gt;a. Listen, do not lecture).&lt;br /&gt;    If you know all the answers, you definitely will not conduct investigations.&lt;br /&gt;    So that in the investigation should provide enough time management or for the user to explain in full and systems analyst and clearly do not dominate the discussion.&lt;br /&gt;b. Do not provide solutions to the initial problem&lt;br /&gt;    This means do not try to show ideas to solve the problem, before the investigation is complete all the activities carried out, so avoid solutions that part-part.&lt;br /&gt;c. Compare stories&lt;br /&gt;    Different people mean different views of the same problem, so the need to involve the supervisor and subordinate in the view of the problem clearly and can be trusted. Should not 1 from a source so that there is only 1 view (opinion).When the user has a difference of views, should find the difference and then seek the views that have similarities.&lt;br /&gt;d. Note the reluctance responses (look for reluctant responses).&lt;br /&gt;    Reluctance to give responses that indicate something is hidden.&lt;br /&gt;    Too many problems be able the system causes confusion, so not able to explain in full.&lt;br /&gt;e. Probe for logical inconsistencies).&lt;br /&gt;    Inconsistency is the logical termination of the data flow where data     missing, or suddenly appear certain data. Some of the things that     dealing with this issue:&lt;br /&gt;    There are data entered but no output (black hole).&lt;br /&gt;    There is the output (output), but no data entered (miracles).&lt;br /&gt;f. Notice the impact you (observe your effect).&lt;br /&gt;    Given the differences of when you attend and when you do not  present. Assessment is called directly with the internal probe. While external probe is that the assessment be done without anyone (searching external materials), such as by analyzing the report, history the problem tools, and sources of other secondary investigation.&lt;br /&gt;g. Require hard work, giving rise to boredom (expect hard, boring work).&lt;br /&gt;    Be a detective professionals and patient in dealing with problems step by step and system is sustainable.&lt;br /&gt;h. Avoid politics&lt;br /&gt;    Mission analyst system is not the judge the facts (your mission is the fact, not judgment).&lt;br /&gt;&lt;br /&gt;Technical investigations&lt;br /&gt;Investigation techniques included:&lt;br /&gt;a. directly (direct (internal) probes)&lt;br /&gt;    namely to find out directly what is happening in the environment users. They allow you to pay attention directly without  through certain parties (interpreter). Internal probes are source of chaos (disruptive), the differences arise because of attitude. Internal  probes used as a richer and the justifier of facts that occurred (truer group of facts). There are three techniques for conduct the investigation directly, with:&lt;br /&gt;    * Questionnaire (questionnaires).&lt;br /&gt;      This technique is very appropriate, if in the investigation have constraints time and cost although to get it through the form of responded field. The things in the condition of the questionnaire will be the explanation different if carried out directly in the face (face to face interview). This is the best of the questionnaire as a document that can show differences that occurred in the respondents.&lt;br /&gt;    * Frequently asked questions (interview).&lt;br /&gt;      These activities require time and special expertise. Not all people able to interview successfully. Interview can be used for a sequence of questions in depth in addition to more flexible accordance with the condition of the field. Obstacles faced and the time is special expertise.&lt;br /&gt;    * Observation (observation).&lt;br /&gt;      It is a strong internal probe (a powerful internal probe).&lt;br /&gt;      Sit together with the system by making observations with the question is more specific.&lt;br /&gt;      Why you do this activity?&lt;br /&gt;      or where this document will be moved?. Each question may  will be able to demonstrate problem-solving mysterious.&lt;br /&gt;&lt;br /&gt;b. Indirect (indirect (external) probes)&lt;br /&gt;    Activities that can be done quickly and not visible from operational personnel, so that they can know the outside or something hidden from the user community. This activity will dominate&lt;br /&gt;    activities at the beginning of the SDLC, the internal probe to deepen.&lt;br /&gt;    * Flow of the procedure (procedure flow).&lt;br /&gt;      An operational procedure is the means (vehicles) for new employees&lt;br /&gt;      understand their work and experience to handle employee problems.&lt;br /&gt;      If the procedure does not flow properly, the system information cannot be&lt;br /&gt;      also operated correctly. Use the system flowchart for&lt;br /&gt;      the path information as an explanation Operating procedure.&lt;br /&gt;      If there is any problem procedure, the problem may be&lt;br /&gt;      arise in the actual operations.&lt;br /&gt;    * Reviewing documents (document review).&lt;br /&gt;      Is to find and collect the documents necessary&lt;br /&gt;      (critical document). If problems occur in many customer orders,&lt;br /&gt;      collected from the original source document customer orders that&lt;br /&gt;      used as its data-entry, interactive screen format, detail&lt;br /&gt;      transactions, and summary reports that the error occurred.&lt;br /&gt;      Documents often caused problems.&lt;br /&gt;    * Sampling (sampling).&lt;br /&gt;      Maybe you need information from the vendor that has been billing&lt;br /&gt;      provide discounts at the time of payment, because the company lost&lt;br /&gt;      money when the discount is not given when the delay of payment.&lt;br /&gt;Example:&lt;br /&gt;      You can involve the customer to get the payer&lt;br /&gt;      information (although there are many transactions). Finally you can make&lt;br /&gt;      list of sample data with the random selection for one last Sunday,&lt;br /&gt;      select the 20 pages of daily transactions, select 5 items from each&lt;br /&gt;      page are selected., record the information for each item and 5&lt;br /&gt;      calculate the average-Ra and variants to the sample-sample of all transactions&lt;br /&gt;      payment occurs.&lt;br /&gt;    * Tabular (Tabular tools)&lt;br /&gt;      Also called the matrix, the check list (checklists) to find&lt;br /&gt;    &lt;br /&gt;&lt;span style="font-weight: bold;"&gt;System description at this time &lt;/span&gt;&lt;br /&gt; &lt;br /&gt;Determine the performance of the system at this time will have difficulty when&lt;br /&gt;company does not have a standard performance measurement system.&lt;br /&gt;Unfortunately, companies tend not to update (to update)&lt;br /&gt;documentation systems that are running. Therefore, analysts improve document&lt;br /&gt;system for investigating the problem.&lt;br /&gt;Description of the system include a clear explanation at this time:&lt;br /&gt;a. Inputs (inputs)&lt;br /&gt;b. Outputs (outputs)&lt;br /&gt;c. Files (files)&lt;br /&gt;d. Data elements (data elements)&lt;br /&gt;e. Volume of transactions and documents action (transaction and document action&lt;br /&gt;    volume)&lt;br /&gt;f. Data flow diagrams (data flow diagrams)&lt;br /&gt;&lt;br /&gt;&lt;span style="font-size:130%;"&gt;&lt;span style="font-weight: bold;"&gt;Requirement Analysis&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Requirement analysis phase is the intensive interaction between the analyst&lt;br /&gt;system with the user community the system (end-user), where the development team&lt;br /&gt;system shows the expertise to get the responses and confidence&lt;br /&gt;the user, so get a good participation.&lt;br /&gt;Is working hard to get agreement (skeptical) users about their needs from an information system, as they may the failure of the previous information system.&lt;br /&gt;&lt;br /&gt;In doing this step will be achieved 4 goals, namely:&lt;br /&gt;a. Describe the system at this time in full.&lt;br /&gt;b. Describes the ideal information system.&lt;br /&gt;c. Bringing information system to the ideal conditions at this time with&lt;br /&gt;    attention to resource constraints.&lt;br /&gt;d. Provide encouragement to the confidence of this team into the development     system.&lt;br /&gt;The desire of users is:&lt;br /&gt;&lt;br /&gt;Requirement in the first stage of the system is doing a survey of&lt;br /&gt;the desire and the information system that is ideal.&lt;br /&gt;Here is an ideal concept than a reality, meaning that no&lt;br /&gt;the ideal system (no system is perfect information) but are&lt;br /&gt; subjective. If this is not explained in depth can&lt;br /&gt;rise to differences of views will be disappointing or end-user.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Method needs analysis &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Keep the selection method of collecting data for the right to&lt;br /&gt;system requirement. Methods are interviews, questionnaires,&lt;br /&gt;observation, analysis procedure, and document the survey.&lt;br /&gt;Each method will be described in depth as follows:&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Frequently asked questions (Interviews) &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;1. How do the methods used.&lt;br /&gt;    Elections potential interviewees.  Make arrangements to potential interviewees.&lt;br /&gt;    Setting up the structure of the complete and clear.&lt;br /&gt;    Choosing a person who will be interview in private and recorded.&lt;br /&gt;2. Target of the method.&lt;br /&gt;    Private key in the process of DFD.&lt;br /&gt;    Sometimes involving outsiders, such as customers or vendors.&lt;br /&gt;3. Benefits of the method.&lt;br /&gt;    Interviewer can measure the response through the questions and to adjust them&lt;br /&gt;      according to the situation that occurred.&lt;br /&gt;    Good for the problems that are not structured, such as why you&lt;br /&gt;      think this could happen?.&lt;br /&gt;    Shows the effect of interviewer time.&lt;br /&gt;    Show a high response since the preparation meeting.&lt;br /&gt;4. Loss method.&lt;br /&gt;    Takes time and costs that are not small.&lt;br /&gt;    Requires special training and experience of the interviewer.&lt;br /&gt;    Difficult to compare the interview because natural subjectivity.&lt;br /&gt;5. When both methods are used.&lt;br /&gt;    Obtaining the views or explanation of key personnel.&lt;br /&gt;    Test the credibility of the interviewees.&lt;br /&gt;    Search for the interview contradictions.&lt;br /&gt;    Stabilizing credibility team.&lt;br /&gt;&lt;br /&gt;Some important factors in both the interview, namely objectives,&lt;br /&gt;audience, format, weighting and combining responses, and documentation.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Questionnaire&lt;/span&gt;&lt;br /&gt;1. How do the methods used.&lt;br /&gt;    Design using a standard questionnaire.&lt;br /&gt;    The questionnaire sent to a work environment end-user.&lt;br /&gt;    Summarized the structure of the response distribution in statistics.&lt;br /&gt;2. Target of the method.&lt;br /&gt;    All end-users with him /his knowledge will be involved in the process of solution splitting system.&lt;br /&gt;    End-user associated with the use of symbols in a DFD.&lt;br /&gt;3. Benefits of the method.&lt;br /&gt;    Cheaper and faster than the interviews.&lt;br /&gt;    Does not require a trained investigator (only one expert who needed to design a questionnaire  for end-user is selected.&lt;br /&gt;    Easy to synthesis since the creation of the questionnaire.&lt;br /&gt;    Can easily minimize the cost for all end-users.&lt;br /&gt;4. Loss method.&lt;br /&gt;    Cannot make a specific question for the end-user.&lt;br /&gt;    Analysts involved so that an impression can not reveal personal  end-user.&lt;br /&gt;    Response to a low not because there is a strong encouragement for  return the questionnaire.&lt;br /&gt;    Cannot adjust the question to end-user specific.&lt;br /&gt;5. When both methods are used.&lt;br /&gt;    Simple question, and have no meaning fork.&lt;br /&gt;    Requires a broad perspective of the end-user.&lt;br /&gt;    When you have less time and cost.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Observation (Observation) &lt;/span&gt;&lt;br /&gt;1. How do the methods used.&lt;br /&gt;    Personally visit the location of one analyst observed.&lt;br /&gt;    Analysts recording events in the location of the observation, including the volume and&lt;br /&gt;      processing, spreadsheets.&lt;br /&gt;2. Target of the method.&lt;br /&gt;    The geographical location of the process shown in the DFD (Data Flow Diagram)&lt;br /&gt;3. Benefits of the method.&lt;br /&gt;    Obtain records of the facts (opinion).&lt;br /&gt;    Does not require construction of a question.&lt;br /&gt;    Does not disrupt or hide something (end-users do not know&lt;br /&gt;      that they are observed).&lt;br /&gt;    Analyst does not rely on verbal descriptions of end-users.&lt;br /&gt;4. Loss method.&lt;br /&gt;    If seen, analysts may change operation (end-user was observed).&lt;br /&gt;    In the long term, the fact that in one observation may be&lt;br /&gt;      not appropriate (representative) in daily or weekly.&lt;br /&gt;    Requires experience and special kehlian analyst.&lt;br /&gt;5. When both methods are used.&lt;br /&gt;    Require quantitative descriptions, such as time, volume and so forth.&lt;br /&gt;    Suspicion that the end-user to the actual occurrence of a&lt;br /&gt;      does not occur (contrived).&lt;br /&gt;&lt;br /&gt;Tip in the practical observations:&lt;br /&gt;&lt;br /&gt;a. Do not be observed in a long time.&lt;br /&gt;    There are two reasons, namely: with a long time will disturb the operation which is being observed, and will deflect the real problems.&lt;br /&gt;b. Create a brief note.&lt;br /&gt;Before observation, please let the supervisor and the involved&lt;br /&gt;    about what will be done and why, so that will be&lt;br /&gt;    reduce interference.&lt;br /&gt;d. Use a short checklist of the required information together.&lt;br /&gt;e. Do not make observations without a plan ..&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Analysis procedure (Procedure Analysis) &lt;/span&gt;&lt;br /&gt;1. How do the methods used.&lt;br /&gt;    With operating procedures can identify and learn&lt;br /&gt;      document the flow of key information through the system, with data flow&lt;br /&gt;      diagram (DFD).&lt;br /&gt;    Each flow of the document describes the key system operating procedures.&lt;br /&gt;    Through observation, learn the reality of the analyst describe your&lt;br /&gt;      volume of distribution (high, low, moderate), and what next&lt;br /&gt;      done to a copy of the original document.&lt;br /&gt;2. Target of the method.&lt;br /&gt;    Documents in the main DFD (Data Flow Diagram)  Process in the DFD.&lt;br /&gt;3. Benefits of the method.&lt;br /&gt;    Evaluation procedure can be done with the intervention (interferences)&lt;br /&gt;      is minimal and does not affect the operation.&lt;br /&gt;    The flow of the procedure can become a checklist for the structure&lt;br /&gt;      make observations.&lt;br /&gt;4. Loss method.&lt;br /&gt;    Procedures may not be complete and not up to date again.&lt;br /&gt;    Learning the flow chart document requires time and expertise analyst.&lt;br /&gt;5. When both methods are used.&lt;br /&gt;    Decide whether the failure of the system can help design  good.&lt;br /&gt;    Analyst team is not completely familiar with the document flow.&lt;br /&gt;    Describe your document that disrupt the flow of work function.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Observations document (Document Survey) &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;1. How do the methods used.&lt;br /&gt;    Identifying key documents and reports (physical data flow  diagram).&lt;br /&gt;    Collect copies of actual documents and reports.&lt;br /&gt;    Each document or report, is used to record data, including&lt;br /&gt;      field (the size and type), frequency of use and structure code (coding structure).&lt;br /&gt;2. Target of the method.&lt;br /&gt;    The flow of key data shown in the data flow diagram (DFD).&lt;br /&gt;3. Benefits of the method.&lt;br /&gt;    Minimize interruption of operations functions.&lt;br /&gt;    The beginning of the data element dictionary.&lt;br /&gt;    Often, major modifications may consider procedural.&lt;br /&gt;4. Loss method.&lt;br /&gt;    Need enough time (there is a business organization in the&lt;br /&gt;      swamped with documents and reports).&lt;br /&gt;5. When both methods are used.&lt;br /&gt;    Be done if a system will be designed (for activities&lt;br /&gt;      analysis, clarity in the new system design and analysis&lt;br /&gt;      documents can help to determine the next task of the design).&lt;br /&gt;&lt;br /&gt;Sampling can help reduce the time and cost. Need for accuracy&lt;br /&gt;select a sample of the population, so the statistics that require expertise&lt;br /&gt;not experience a failure or threat.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Resource constraints &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;a. Time&lt;br /&gt;     substitution a system must be expressed in the framework since&lt;br /&gt;    decreasing function of the system quickly. Time constraints can be&lt;br /&gt;    influence the analyst to consider the technology innovation that is not&lt;br /&gt;    may be operated in a short time. Therefore, the need to&lt;br /&gt;    need enough time to have a leeway of time so that&lt;br /&gt;    can create an alternative to the most good.&lt;br /&gt;b. Money&lt;br /&gt;    The ideal information system would require the expensive cost, so that&lt;br /&gt;    requires adequate funding. This will occur due to&lt;br /&gt;    competition with our competitors where they embed investment&lt;br /&gt;    in a large information system.&lt;br /&gt;c. Expertise.&lt;br /&gt;    Staff information system may not have knowledge or experience&lt;br /&gt;    a significant problem, such as telecommunications, database integration, and&lt;br /&gt;    interactive setting. Companies can contract consultant to&lt;br /&gt;    increase design capabilities. This will be the opposed&lt;br /&gt;    constraint costs incurred for energy consultants.&lt;br /&gt;d. Technology.&lt;br /&gt;    Technology needs may become the main problem in supporting&lt;br /&gt;    working system, so the need to pay attention to the development of technology continues&lt;br /&gt;    again, the consequences of going in cost and&lt;br /&gt;    not until the technology used behind the competitors.&lt;br /&gt;e. Ekternal factors.&lt;br /&gt;    Many obstacles that come from outside of the design settings, such as prevention&lt;br /&gt;    use exotic technologies (of exotic technologies), to prevent&lt;br /&gt;    keep local data in a central database system, and so forth.&lt;br /&gt;&lt;br /&gt;Needs analysis document&lt;br /&gt;&lt;br /&gt;1. Referral (conduct) analysis.&lt;br /&gt;    Relationships with end users.&lt;br /&gt;    Analyze the records, forms and reports.&lt;br /&gt;    Observation process.&lt;br /&gt;    Analyzing the methods used.&lt;br /&gt;    Problems in data collection.&lt;br /&gt;2. Needs of the user.&lt;br /&gt;    What are the actual needs.&lt;br /&gt;    Reporting needs (type and frequency).&lt;br /&gt;    Training needs.&lt;br /&gt;    The influence of the new system.&lt;br /&gt;3. Constraint system.&lt;br /&gt;    Explain the constraints of time, cost, expertise, technology and factor&lt;br /&gt;      external.&lt;br /&gt;    Realistic system.&lt;br /&gt;4. Documentation.&lt;br /&gt;    Instrument data collection (needs questionnaire, interview).&lt;br /&gt;    Consensus statistics.&lt;br /&gt;    The logical flow of data and physics.&lt;br /&gt;    Initial element in the data dictionary.&lt;br /&gt;Generating SYSTEMS ALTERNATIVES&lt;br /&gt;How do I approach the condition of the system at this time with the condition of the ideal system?&lt;br /&gt;Creating an alternative to solve the problem of information system&lt;br /&gt;Best alternative is applied wisely&lt;br /&gt;Options Strategies&lt;br /&gt;Distributed versus centralized processing&lt;br /&gt;Changes in decision-making information from the centralized data processing to the end user Decentralized responsibility center&lt;br /&gt;Integrated versus dispersed database&lt;br /&gt;System designer must consider the data are entered in the data base and the entrance to the File&lt;br /&gt;Surround System Development Strategy of&lt;br /&gt;About important environmental strategy in the case of company takeovers because the information system of other companies may vary with the company at this time.&lt;br /&gt;Generating SYSTEMS ALTERNATIVES&lt;br /&gt;Options strategy&lt;br /&gt;Selection is done before the design operational&lt;br /&gt;Designing Operational Options&lt;br /&gt;Design options can be grouped into&lt;br /&gt;Input&lt;br /&gt;Online Vs Off Line Data Entry&lt;br /&gt;Keyed Vs Machine Readable Data Entry&lt;br /&gt;Centralized Vs Decentralized Data Entry&lt;br /&gt;Processing&lt;br /&gt;Batch Vs Real time record update&lt;br /&gt;Sequential Vs Direct Access to records&lt;br /&gt;Single Vs Multiple Users update of records&lt;br /&gt;Output&lt;br /&gt;Traditional Vs Turn Around Documents&lt;br /&gt;Structured Inquiry Vs based reports&lt;br /&gt;SELECTING THE PROPER SYSTEM&lt;br /&gt;Compare tactics: systems based on the comparison of costs and benefits relative; There are 3 ways said system A system is superior to the other if:&lt;br /&gt;A cost is lower than B, and the benefits of both&lt;br /&gt;A cost is lower than B and A yield advantage of more than B&lt;br /&gt;A and B have the same but the cost advantage generated a lot more.&lt;br /&gt;Some methods corporation System&lt;br /&gt;Break Even point Analysis&lt;br /&gt;Payback Period&lt;br /&gt;Discounted payback period&lt;br /&gt;Internal Rate of Return&lt;br /&gt;SELECTING THE PROPER SYSTEM&lt;br /&gt;Cost categories&lt;br /&gt;Hardware&lt;br /&gt;Software&lt;br /&gt;People&lt;br /&gt;Suppliers&lt;br /&gt;Telecommunications&lt;br /&gt;Physical sites&lt;br /&gt;Cost details&lt;br /&gt;Comparing the cost of information systems through the life of the system, analysts projection how cost changes for the future and there are 3 models cost information system, namely Linear, and exponentially Step Function&lt;br /&gt;SELECTING THE PROPER SYSTEM&lt;br /&gt;Cost information system can occur only once and can also occur on an ongoing basis.&lt;br /&gt;Information system costs that occur once only cost that is on time and development costs that occur during the development of the system.&lt;br /&gt;Cost information systems that occur on a continual basis are recurring cost and operational cost where the cost of this is the case when the operating system information every day.&lt;br /&gt;FACTORS INTO INFORMATION SYSTEM&lt;br /&gt;Qualitative factors that lead the performance information system that both of them&lt;br /&gt;Reduce errors&lt;br /&gt;Reducing the time to fix errors&lt;br /&gt;Reduce the response time from the workstation alternative&lt;br /&gt;Accelerate the provision of the information&lt;br /&gt;Improve security systems&lt;br /&gt;Propagate update records on the source&lt;br /&gt;Increasing user satisfaction&lt;br /&gt;FACTORS INTO CORPORATE STRATEGY&lt;br /&gt;Customer satisfaction&lt;br /&gt;Sales increased&lt;br /&gt;Consumer and the vendor's commitment&lt;br /&gt;Information marketing products&lt;br /&gt;Presenting learning SYSTEM&lt;br /&gt;Make short presentations&lt;br /&gt;Reduce the explanation of technical detail&lt;br /&gt;presentation  clearly with visual aids&lt;br /&gt;If using a model using a tool such as a laptop so that more informative&lt;br /&gt;Emphasize the benefits of the proposed system with some information that there are alternative suitable conditions experienced by the company.&lt;br /&gt;Continuing KEPUTUSAN OR NOT&lt;br /&gt;if the company decided to develop the information system, the department will do the next process, namely Design System.&lt;br /&gt;If then the System Development Life Cycle (SDLC) will be terminated.&lt;br /&gt;Will be often found problems with the system and the study and top management will usually ask for the fulfillment of the re-study system.&lt;br /&gt;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.&lt;br /&gt;With the alternative, the decision to repeat a previous phase or SDLC is not Go - No-Go Decision.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;References&lt;br /&gt;1. Martin, Merle P., Analysis and Design of Business Information Sytems,&lt;br /&gt;    Macmillan Publishing Company, New York, 1991.&lt;br /&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3851818876120535385-7180473716084307561?l=ririnilkom06.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://ririnilkom06.blogspot.com/feeds/7180473716084307561/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://ririnilkom06.blogspot.com/2009/03/initial-investigation-and-requirement.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/7180473716084307561'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/7180473716084307561'/><link rel='alternate' type='text/html' href='http://ririnilkom06.blogspot.com/2009/03/initial-investigation-and-requirement.html' title='Initial Investigation and Requirement Analysis'/><author><name>call_ririn</name><uri>http://www.blogger.com/profile/02138001931598837324</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_879af8dIsUI/ScrUBHWUnWI/AAAAAAAAABo/rk5VYqNRvK8/S220/Foto029%5B1%5D.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3851818876120535385.post-7170790933206814382</id><published>2009-03-07T20:01:00.012+07:00</published><updated>2009-03-07T22:28:19.392+07:00</updated><title type='text'>Information system development</title><content type='html'>Developing an information system means arrange a new system to continue as a replacement an old system.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The importance of developing an information system is:&lt;/span&gt;&lt;br /&gt;1&lt;span style="font-weight: bold;"&gt;.    problems&lt;/span&gt;&lt;br /&gt;Main factor which caused the old system was replaced with the new system because of problems with the old system.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    Irregularity: &lt;/span&gt;&lt;br /&gt;Irregularity in the system can cause the old system does not function in accordance with expectations.&lt;br /&gt;For example:&lt;br /&gt;System of a warehousing company, the note has some bugs so that employees can do, such as cheating, cheating to manipulate the data the company's fault or error that is not intentional. Of course this may because the truth of the data is not guaranteed. Therefore, the work of the system will not operate efficiently in&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    Growth Organization: &lt;/span&gt;&lt;br /&gt;Growth may cause the organization must arrange the new system. The growth of this organization are the information needs of the more knowledgeable, the volume of data increases, the change in the principles of organization and others, causing the old system does not operate effectively.&lt;br /&gt;For example:&lt;br /&gt;a banking company, the company is first to use a SQL database, but the longer the more the customer so that the volume of data to be increase. This requires that the company is changing the banking system into the information-based oracle that can accommodate the new customer data.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;2.    Opportunity&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Information technology is now developing very rapidly. In the current era of competition such as this, information is needed in support of a decision. So companies need a system that can process the information appropriately in accordance with the development of the era.&lt;br /&gt;For example:&lt;br /&gt;Restaurant attract customers by providing hotspot service free to customers who lunch or dinner at the. So that visitors can browse while eating or they can use restaurant to conduct business meetings or other activities.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;3.    instruction&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;Change a system can occur because of intruction superiors or the environment outside.&lt;br /&gt;For example:&lt;br /&gt;customers bank who complain to the queue system were established at the time of the transaction. Because of the wide costumer cause a long queue so that many customers tired of standing. Complaints from customers is the bank should change the old system into the new system is using the automated system.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The purpose or goal of developing an information system&lt;/span&gt;&lt;br /&gt;There are 3 goals in the development of a system that is:&lt;br /&gt;&lt;br /&gt;·    Solve the problems that are mainly caused by the old system.&lt;br /&gt;·    Seize opportunities in the era of competition, such as now. So companies need to utilize information technology in order to survive and develop.&lt;br /&gt;·    Fulfill the instructions given in both in and outside the company environment.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The Organization expectations after implementing the system organization &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Performance &lt;/span&gt;&lt;br /&gt;performance improvements so that the new system is more effective. Performance can be measured from the throughput and respon time. Throughput means the amount of work that can be done at a certain time. Response time is the average time the pending transaction between the two plus the response time to respond to the job.&lt;br /&gt;For example:&lt;br /&gt;a supermarket to replace the system that excels in sales into the system cashier. So the system is expected cashier will be able to calculate quickly and accurately in accordance with the information required by cashier and customers.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Information &lt;/span&gt;&lt;br /&gt;Improving the quality of information generated by the system&lt;br /&gt;for example:&lt;br /&gt;accounting information system that can provide benefits such as company reports and monthly employee salaries, etc. that cannot be done by the old system.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Economy &lt;/span&gt;&lt;br /&gt;the new system is expected to increase the benefits or advantages to the company so that it also expected a decline to the cost of going&lt;br /&gt;for example:&lt;br /&gt;a warehouse in a company still using manual system checks in the goods entrance or exit of goods. So that requires a lot of employees on duty, but for now check warehousing system change in the use of information technology systems that can work automatically. So that they can save the labor and production costs can be derived.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Control &lt;/span&gt;&lt;br /&gt;Detect and fix errors&lt;br /&gt;for example:&lt;br /&gt;at the supermarket, supermarkets now have been using bar code system for checking and selling goods. So by using this system will be able to detect errors at the time of the transaction with the customer.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Efficiency &lt;/span&gt;&lt;br /&gt;Operational efficiency related to how resources are used with the minimum of waste.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Services &lt;/span&gt;&lt;br /&gt;Improvement of the services provided by the system.&lt;br /&gt;For example:&lt;br /&gt;the banking system that is able to give even a report that is required in accordance with user preferences&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;the principles of developing an information system &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;1.system for management &lt;/span&gt;&lt;br /&gt;system is developed for management purposes so that the system must be able to support the needs required by the management&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;2.system is a large capital investment &lt;/span&gt;&lt;br /&gt;information system is identical with the use of technology  so that require a large capital to develop it. So every investment capital should consider 2 things, namely:&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    All alternatives should be investigated in order to minimize the opportunity cost&lt;/span&gt;. Several alternatives should be in the investigation to determine the most profitable alternative.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    Must be the best investment value&lt;br /&gt;&lt;/span&gt;said the new investment if the value has. That is the benefit or result great than cost to obtain it from. Cost benefit analysis or cost analysis Effectiveness can be used to determine whether the project is worth investigation or not&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;3.system developed that require people educated &lt;/span&gt;&lt;br /&gt;does not mean the system should be the people who educated about the system but can also be done by providing on the job training to users on how to use the system that is applied.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;4. Worked phase to be done in the process of system development &lt;/span&gt;&lt;br /&gt;system development cycle generally shows stages work tasks or work to be done. Some development methodology system also provides a more detailed concept work to be done in the process of developing the system.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;5. Process development system does not need Ascending &lt;/span&gt;&lt;br /&gt;For example:&lt;br /&gt;in the development of the system, the design output is the phase that must be done before the design file. However, this does not mean all of the output should be designed all new design file, but can also be done simultaneously with.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;6. Don’t afraid to cancel the project &lt;/span&gt;&lt;br /&gt;Cancel the project that are not practical anymore, re-evaluate, adjust the cost and time will be increased, reduce the scope if the cost is not enough to pay for system. After that is expected to manage the risk, to control what may fail later in the project before the process of risk arising&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;7.documentation there must be guidelines for the development system &lt;/span&gt;&lt;br /&gt;documentation created and collected during the process of development of the system can be used for communication between the analyst and the system can be used to encourage the involvement of the system.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The principles of developing an information system&lt;/span&gt;&lt;br /&gt;1.    Waterfall model&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_879af8dIsUI/SbKOTGHI9kI/AAAAAAAAABI/W3UNPQdf83s/s1600-h/graphics1.png"&gt;&lt;img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer; width: 320px; height: 246px;" src="http://1.bp.blogspot.com/_879af8dIsUI/SbKOTGHI9kI/AAAAAAAAABI/W3UNPQdf83s/s320/graphics1.png" alt="" id="BLOGGER_PHOTO_ID_5310463369332454978" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;This method proposes an approach to software development and systematic sequential.&lt;br /&gt;Consists of the planning stages of the system (system engineering), analyzes needs, design, writing programs, testing and maintenance the system.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    Requirement or planning systems (systems engineering),&lt;/span&gt;&lt;br /&gt;at this stage needs done on the system level, namely the needs of the hardware, software, and databases. Needs of this important collection is done because Software information system that will be built is part of the computer system.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    Analysis of information system needs&lt;/span&gt;, at this stage needs to be done collection information system software in the form of input data, processes that occur and the expected output with the interviews and observations, the results from the diagram can be a data flow diagram (DFD) with a data dictionary, relation entity diagram (ERD) or change in the status diagram (STD).&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    Design, &lt;/span&gt;at this stage to translate the needs analysis in the form of a draft before writing the program in the form of the design of the interface (input and output), the design files or databases and the design procedure (algorithm).&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    Implementation&lt;/span&gt;, the results on the design changed to the form understood by machines in the form of a programming language. If the detailed design of the program can be done quickly.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Testing,&lt;/span&gt; testing process focuses on:&lt;br /&gt;internal logic device to ensure that all statements in the test and has been on an external drive that is functional testing to find errors and to ensure that the limited input that will give the actual value.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    Maintenance&lt;/span&gt;&lt;br /&gt;is a system of care that can be used continuously.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The weakness of the waterfall model:&lt;/span&gt;&lt;br /&gt;·    Iterations often cause new problem&lt;br /&gt;·    Client difficulty for all states to explicitly want beginning stage of development.&lt;br /&gt;·    The new software will be developed long after the project development starts&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Model prototipe (prototyping model)&lt;/span&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_879af8dIsUI/SbKPL_jviJI/AAAAAAAAABY/k11WReobCUs/s1600-h/prototype_model.jpg"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 184px;" src="http://3.bp.blogspot.com/_879af8dIsUI/SbKPL_jviJI/AAAAAAAAABY/k11WReobCUs/s320/prototype_model.jpg" alt="" id="BLOGGER_PHOTO_ID_5310464346825918610" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;starting with the collection needs and improvements, the design quickly, forming&lt;br /&gt;prototype, prototype evaluation of the customer, improvement prototype and final product.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    Reaction of the user&lt;/span&gt;, beginning with a show prototype information system, and then see the reaction from users when working with the prototype if the features in the system prototype is already in accordance with their needs. Reaction is collected in the observation, interviews and the questionnaire.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;·    User suggestions&lt;/span&gt;, advice is the result of the interaction  user with the prototype is shown (user evaluation) which is the input for the improvement, conversion or&lt;br /&gt;'Stop' so that the prototype can meet the needs users better.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;· Innovation&lt;/span&gt; is the ability of the new system previously did not have at the time the user interacts with the prototype. Innovation prototype if successful will become part of system so results.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;· Plan revision&lt;/span&gt;, describes the prototype system in the future.&lt;br /&gt;Plan to help identify revision priorities what will be next prototype.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;3.    Spiral model&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_879af8dIsUI/SbKPqmmRGMI/AAAAAAAAABg/OPB9d2oC6cQ/s1600-h/spiral.jpg"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 248px;" src="http://4.bp.blogspot.com/_879af8dIsUI/SbKPqmmRGMI/AAAAAAAAABg/OPB9d2oC6cQ/s320/spiral.jpg" alt="" id="BLOGGER_PHOTO_ID_5310464872701565122" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;This method of analysis of the risk. If the analysis shows there is a risk of uncertainty of demand, the development system can be stopped.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;This model is divided into 6 activities are:&lt;/span&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;1.    Communications customer&lt;/span&gt;, comunication between developers with customers to determine needs work.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;2.    Planning&lt;/span&gt;, defining the resources, the time-relation information and other projects.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;3.    Risk analysis&lt;/span&gt;, to determine the technical and risk management.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;4.    Engineering&lt;/span&gt;, to build one or more applications that can be represented.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;5.    Construction and launch&lt;/span&gt;, to mengkonstruksi, test, install and provide user support (training).&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;6.    Customer evaluation&lt;/span&gt;, to obtain customer feedback based on the assessment of the results    of engineering.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Approaches of developing a system&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;1. Be seen from methodology used&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;The classical approach versus structured approach&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The classical approach&lt;/span&gt;&lt;br /&gt;The approach is called classical or traditional approach with the approach is the approach conventional in the development of systems that follow the stages in the life cycle without system provided with the tools and techniques are adequate.&lt;br /&gt;Problems:&lt;br /&gt;·    software development will be difficult&lt;br /&gt;·    cost of care and maintenance will become more expensive&lt;br /&gt;·    possibility on the size of the error system&lt;br /&gt;·    success of the system less secure&lt;br /&gt;·    problems in the implementation of the system&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Structured approach&lt;/span&gt;&lt;br /&gt;is an approach to the development of the new system is equipped with several tools and techniques so that the result was successful. Through this approach,  complex problem 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 better .&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;2. Be seen from the target to be achieved&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;the piece approach versus system approach&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;the piece approach&lt;/span&gt;&lt;br /&gt;Emphasizing that the application or on an activity without considering the overall objectives of the organization.&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;System Approach&lt;/span&gt;&lt;br /&gt;emphasizing that the approach in achieving the overall goals and see the system as a whole is unity.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;3.Be seen from how to determine the needs of the system&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;the bottom-up approach versus the top-down&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Ride-down approach (bottom-up)&lt;/span&gt;&lt;br /&gt;The Approach that starts from the bottom level of the operational level where the transaction is done. Is a discrete approach to classical . Known by the term data-analysis because the pressure is to be data to be processed first, the information generated subsequent to the data.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Top-down approach (top-down&lt;/span&gt;)&lt;br /&gt;Starting from the approach that the top-level strategy planning . Is a discrete approach to structured . Also known with the decision-analysis because the pressure is to be the information necessary for decision making by management and the data processed is defined overtake  the information required.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;4.be seen of how development&lt;/span&gt;&lt;br /&gt;The system-comprehensive approach versus modular approach&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Comprehensive approach &lt;/span&gt;&lt;br /&gt;Develop a system simultaneously and comprehensively&lt;br /&gt;Is a discrete approach to classical&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Modular approach&lt;/span&gt;&lt;br /&gt;Split the system into the complex parts of a simple&lt;br /&gt;System to be developed on time, easy to understand and kept&lt;br /&gt;Is a discrete approach to structured&lt;br /&gt;&lt;br /&gt;5. &lt;span style="font-weight: bold;"&gt;seen from the technology used&lt;/span&gt;&lt;br /&gt;The far-jump approach versus developing approach&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The far-jump (great-loop approach)&lt;/span&gt;&lt;br /&gt;Develop a system simultaneously using the advanced technology&lt;br /&gt;High-risk and spend a lot of cost&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Developing approaches (evolutionary approach)&lt;/span&gt;&lt;br /&gt;Applying advanced technology for application-specific applications&lt;br /&gt;Developed for the needs&lt;br /&gt;Cost effective and can follow the development of technology&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;the meaning of methodology, method and algorithm&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;System development &lt;span style="font-weight: bold;"&gt;methodology&lt;/span&gt; is the methods, procedures, concepts of work, the rules that will be used as a guide how and what should be done during this development. While the &lt;span style="font-weight: bold;"&gt;method&lt;/span&gt; is a way / technique systematically to grind. Continuity procedures for the settlement of this issue are known by the term &lt;span style="font-weight: bold;"&gt;algorithm&lt;/span&gt;. System development methodology that will be used in this case is a structured approach. Structured approach to introduce the use of tools and techniques to develop a structured system.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;three classifications of development methodology&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;1.    Data-oriented&lt;/span&gt;&lt;br /&gt;Emphasizes the characteristics of the data processed&lt;br /&gt;Data-flow oriented: modules according to the type of data elements&lt;br /&gt;Data-oriented structure: the structure of input and output&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;2.    Prescriptive&lt;/span&gt;&lt;br /&gt;Usually provided by the manufacturer of the software&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;3.    Functional decomposition&lt;/span&gt;&lt;br /&gt;Emphasize breaking system subsystem&lt;br /&gt;Example: HIPO, Stepwise refinement, iterative stepwise refinement, information hiding&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Tools for developing a system&lt;/span&gt;&lt;br /&gt;Shaped graph: HIPO, SADT, Jackson's diagram, and other&lt;br /&gt;·    Tools that use the chart:&lt;br /&gt;Charting activity: describes the activities, for example: Gant chart, flowchart, etc.&lt;br /&gt;·    Layout charting: describes the layout&lt;br /&gt;·    Charting a personal relationship: describes the relationship of personnel, for example: organization charts, work distribution chart&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;techniques used in developing a system&lt;/span&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;1.    Project management techniques used to project schedule&lt;/span&gt;&lt;br /&gt;for example: CPM (Critical Path Method) and pert (Program Evaluation and review technique)&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;2.    Fact-finding techniques&lt;/span&gt;&lt;br /&gt;the techniques that can be used to collect data and find the facts in activities to learn the system that exists.&lt;br /&gt;Techniques that can be done are:&lt;br /&gt;·    Interview&lt;br /&gt;·    Observation&lt;br /&gt;·    Questionnaires&lt;br /&gt;·    Sampling&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;3.    Technique to analysis of cost / benefit → cost-benefit and cost-Effectiveness analysis&lt;/span&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;4.    Technique to  run a meeting&lt;/span&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;5.    Technique to inspection&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The differences of being a system Analyst and a programmer&lt;/span&gt;&lt;br /&gt;Analyst system: study of the problems and determine the needs of the system to identify solutions&lt;br /&gt;Programmers: write a program code based on the building design is created by the analyst&lt;br /&gt;System analyst duty bridge the knowledge gap that occurs between the user and system programmers&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Responsibility of the programmer than the system analyst&lt;/span&gt;&lt;br /&gt;Programmers&lt;br /&gt;1. Responsible limited to the programmer of making the computer&lt;br /&gt;2. Knowledge programmers just limited to computer technology, information systems, utilities and languages program is needed&lt;br /&gt;3. Jobs of Programmers are technical and must be precise in making the program instructions&lt;br /&gt;4.  Jobs Programmers don’t have  relationship with the people, limited to a fellow programmer and systems analysis to prepare a design  program.&lt;br /&gt;&lt;br /&gt;Analysis system&lt;br /&gt;1. Responsible analyst system not only on making a computer program, but the system overall&lt;br /&gt;2. Knowledge analyst systems must be knowledgeable, not only in computer technology, but also in the field of application in&lt;br /&gt;3.  Job of systems analyst in making the program limited to solving the outline.&lt;br /&gt;4. Job of systems analyst relations system involving many people, not limited to fellow analyst system, but also the programmers and system managers&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The knowledge a system analyst should posses&lt;/span&gt;&lt;br /&gt;Technology, data processing, computer programming and&lt;br /&gt;Business knowledge in general&lt;br /&gt;quantitative methods: regression, linier programming&lt;br /&gt;Problem-solving skills&lt;br /&gt;Communication skills among the personnel&lt;br /&gt;Expertise builds relationships between the personnel&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;library:&lt;br /&gt;1. analisis dan desain sistem informasi (jogiyanto)&lt;br /&gt;2.rekayasa perangkat lunak (Roger s Pressman)&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3851818876120535385-7170790933206814382?l=ririnilkom06.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://ririnilkom06.blogspot.com/feeds/7170790933206814382/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://ririnilkom06.blogspot.com/2009/03/information-system-development_07.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/7170790933206814382'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/7170790933206814382'/><link rel='alternate' type='text/html' href='http://ririnilkom06.blogspot.com/2009/03/information-system-development_07.html' title='Information system development'/><author><name>call_ririn</name><uri>http://www.blogger.com/profile/02138001931598837324</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_879af8dIsUI/ScrUBHWUnWI/AAAAAAAAABo/rk5VYqNRvK8/S220/Foto029%5B1%5D.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://1.bp.blogspot.com/_879af8dIsUI/SbKOTGHI9kI/AAAAAAAAABI/W3UNPQdf83s/s72-c/graphics1.png' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3851818876120535385.post-8818959515534425570</id><published>2009-02-20T19:27:00.000+07:00</published><updated>2009-02-20T22:49:55.142+07:00</updated><title type='text'>Information System Analysis and Design</title><content type='html'>&lt;span style="font-weight: bold;"&gt;The approach of base concept of system&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;There are two approaches to define the system itself.&lt;br /&gt;&lt;br /&gt;  &lt;span style="font-weight: bold;"&gt; 1. Procedure Approach&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;System is a work of network from procedures which is having a mutual connection and together to do the activity or to finish a certain target. (Taken from fundamental of system analysis).&lt;br /&gt;Definition of procedure is the correct sequence from a number instruction which is to explain what must doing, who is done it, when it done and how we done it.&lt;br /&gt;&lt;br /&gt; &lt;span style="font-weight: bold;"&gt;  2. Element Approach&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;System is interacted a group of elements to achieve a certain goal.&lt;br /&gt;&lt;br /&gt;Both of definition about system above is right because the definition of system is important role for studying about system definition approach. The approach of system is a group of elements or components or subsystem is a general definition of system itself.&lt;br /&gt;&lt;br /&gt;For example:&lt;br /&gt;&lt;br /&gt;The company information system is consisting of several subsystems there are inventory subsystem, accounting subsystem, marketing subsystem and etc.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The purpose of system&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;System has a certain purpose there is:&lt;br /&gt;&lt;br /&gt;The purpose of system is to achieve a goal.&lt;br /&gt;For Example: for business system, goals are correctly of purpose for the system.&lt;br /&gt;&lt;br /&gt;The purpose of system is to achieve an objection.&lt;br /&gt;For Example: the accounting system and other subsystem from business system, an objection is correctly of purpose for the system.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The characteristic of the system&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;- Components of system&lt;br /&gt;An integrated a set of components for collecting, storing and communicating information.&lt;br /&gt;&lt;br /&gt;- Boundary of system&lt;br /&gt;Boundary of system is scope area between another system and environment.&lt;br /&gt;&lt;br /&gt;- Environment&lt;br /&gt;Environment means is everything outside the system boundary.&lt;br /&gt;&lt;br /&gt;- Interface&lt;br /&gt;Link between subsystems to another subsystem&lt;br /&gt;&lt;br /&gt;- input&lt;br /&gt;Input means all of resources that entered into the system&lt;br /&gt;&lt;br /&gt;- output&lt;br /&gt;Output means result of input have been processed.&lt;br /&gt;&lt;br /&gt;- Processing&lt;br /&gt;A process from input to be output&lt;br /&gt;&lt;br /&gt;- Goal&lt;br /&gt;It’s functioning because there are limits to what it can do and how it can achieve its purpose within its environment&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;The Classification of system&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;The Classification of system from several viewpoints such as:&lt;br /&gt;&lt;br /&gt;   1. Classification of system as abstract system and physical system&lt;br /&gt;   2. Classification of system as natural system and human made system&lt;br /&gt;   3. Classification of system as deterministic system and probabilistic system&lt;br /&gt;   4. Classification of system as close system and open system&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Base concept of information&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;The information is useful for system itself to avoid entropy processing or negative entropy (negentropy). The Information as a concept has a diversity of meanings, from everyday usage to technical settings. Resources of information are data. Data refer to a collection of facts usually collected as the result of experience, observation or experiment, or processes within a computer system, or a set of premises. Data are often viewed as a lowest level of abstraction from which information and knowledge are derived.&lt;br /&gt;Example of information is marketing report from salesmen is useful for management to determine the bonus.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Quality of information&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;The quality of information&lt;br /&gt;&lt;br /&gt;- Accurate is measured by comparing the data to actual events .Payroll information must be exact or accurate. For example the information must be simple, not confusing and true free from mistakes.&lt;br /&gt;&lt;br /&gt;- Timeliness&lt;br /&gt;The information likes real time system. Its means that the information comes to user can not be late.&lt;br /&gt;&lt;br /&gt;- Relevance&lt;br /&gt;It means the information must have advantages and useful for users.&lt;br /&gt;Information is relevant if it leads to improved decision making. It might also be relevant if it reaffirms a previous decision.&lt;br /&gt;&lt;br /&gt;Value of information is depending on 2 factor, advantages and cost.&lt;br /&gt;An information has a high value if the advantages more effective than the cost to get it&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3851818876120535385-8818959515534425570?l=ririnilkom06.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://ririnilkom06.blogspot.com/feeds/8818959515534425570/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://ririnilkom06.blogspot.com/2009/02/information-system-analysis-and-design.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/8818959515534425570'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/8818959515534425570'/><link rel='alternate' type='text/html' href='http://ririnilkom06.blogspot.com/2009/02/information-system-analysis-and-design.html' title='Information System Analysis and Design'/><author><name>call_ririn</name><uri>http://www.blogger.com/profile/02138001931598837324</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_879af8dIsUI/ScrUBHWUnWI/AAAAAAAAABo/rk5VYqNRvK8/S220/Foto029%5B1%5D.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3851818876120535385.post-5083311564970675469</id><published>2009-02-18T13:27:00.000+07:00</published><updated>2009-02-18T13:28:23.653+07:00</updated><title type='text'>tulisan pertama</title><content type='html'>blog untuk ADSI dah berhasil dibuat.......&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3851818876120535385-5083311564970675469?l=ririnilkom06.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://ririnilkom06.blogspot.com/feeds/5083311564970675469/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://ririnilkom06.blogspot.com/2009/02/tulisan-pertama.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/5083311564970675469'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3851818876120535385/posts/default/5083311564970675469'/><link rel='alternate' type='text/html' href='http://ririnilkom06.blogspot.com/2009/02/tulisan-pertama.html' title='tulisan pertama'/><author><name>call_ririn</name><uri>http://www.blogger.com/profile/02138001931598837324</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_879af8dIsUI/ScrUBHWUnWI/AAAAAAAAABo/rk5VYqNRvK8/S220/Foto029%5B1%5D.jpg'/></author><thr:total>0</thr:total></entry></feed>
