Normalization in Data Quality

-
well.. the first time I study in Informatics of ITB we studied about "Data quality" the goal of this lesson is to make the data more quality as semantic word is free error, good analysis. This Lesson also content of Database like on how we make data be normalized. in this occasion I will share about Normalization.

Exactly we have to know about 1NF up to Boys Code Normal Form (BCNF). The table can be said get into 1NF or first normal form if the table is atomic, it means that the data can not be decomposition any more. How about 2NF the table is stated in 2nd Normal Form if all non prime attribute depends absolutely to primary key, it means there is no partial non prime attribute that depends on another key let say candidate key.

3NF or 3rd Normal form means that the table must have been in 2NF and then the second one there is no prime attribute that force another prime attribute, so if the table is 3NF of course the table is 2NF and 1NF, the last how about BNCF, well BCNF is built by Boys Code, in this case there is no have to 2NF and neither 2NF, the key is all super key in the left side must be primary key. Well.. I think that's all then, for this lesson :).

Popular posts from this blog

Introduction to Use Case Diagram - Case study: Facebook

-
Image
At this session, will be explained about Use case Diagram. as we know, there are so many diagrams in UML for Analyse and design such as Use Case, Class diagram, Interaction, communication diagrams, etc. Use case can be created to explain business process from the system and to know the relationship between Actor and Use case itself. here is the sample of Facebook which is created in Astah community (Free UML tools) : From the pictures, can be explained that :  the User can update status, send message, edit his profile after he/she log on (in this part use "include"). the Extend in this session have a function as conditional, according to text book of AdegBoyage..continue
Read more

Sequential Search

-
Salam, berikut ini diberikan contoh program menggunakan Sequential Search menggunakan bahasa pemrograman Pascal. Silhakan saudara coba coding menggunakan tools Free pascal. program pencarian_SequenctialSearch; uses crt; const   Nmaks = 100; type   larikInt = array[1..Nmaks] of integer; var   L : larikint;   i : integer;  {indeks Larik}   n : integer;  {banyaknya elemen Larik used}   x : integer; {nilai dicaari}   idx : integer;   procedure bacaLarik(var L:larikInt; n : integer);   var     i : integer;   begin     for i := 1 to n do     begin       write('Masukan nilai L[',i,']:'); readln(L[i]);     end;   end;   procedure cetakLarik(L:larikInt; n : integer);   var     i : integer;   begin     for i := 1 to n do      begin        writeln(L[i]);      end;   end;   procedure seqSearch2(L : LarikInt; n : integer; x : integer; var idx:integer);   var     i : integer;   begin     i := 1;     while (i < n) and (L[i] <> x) do  
Read more

Review Buku Knowledge Management Creating Value Nonaka-1995

-
Buku ini sangat menarik untuk dikaji secara terus menerus, sebagai pionir buku dari Knowledge Management Creating Value dengan penulis Nonaka dan Takeuchi, 1995. Sebagai pionir dalam bidang knowledge management yang tentu saja dijaman sekarang ini banyak buku-buku knowledge management yang ditulis oleh beberapa penulis baik di dalam negeri maupun luar negeri. Pada pembahasan awal buku ini, diteliti oleh beberapa penulis senior barat ditahun 1990-an mengenai hal apa yang bisa membuat Jepang maju dalam penguasaan teknologi, seperti diketahui Jepang terlibat dalam perang dunia ke-2 tahu 1941 tentu saja membuat negara ini menjadi hancur buakan hanya secara ekoonmi, sosial dan lainnya.
Read more