Anomali terbagi menjadi tiga jenis, yaitu:

1. Insert Anomali (Anomali pemasukan data)

Anomali pemasukan data adalah kesalahan-kesalahan dalam memasukkan sebuah data yang disebabkan oleh desain database yang buruk.

Perhatikan kembali Tabel 1.1, dalam tabel tersebut terdapat sebuah anomaly pada kolom Nama_Perusahaan, tepatnya dari data karyawan bernomor Nik 105. Nilai kolom ini seharusnya PT. BERSAMA, bukan PT. BERSAM.

Seiring dengan bertambahnya data, apabila kesalahan seperti ini dibiarkan, maka data-data seperti ini akan bertambah. Kita dapat saja secara manual mamperbaiki kesalahan seperti di atas secara manual, tetapi ada cara yang lebih baik lagi untuk memperkecil kesalahan seperti ini melalui Normalisasi. Memperbaiki secara manual bukan merupakan solusi yang baik apabila data yang salah sudah terhitung sangat banyak.

2. Delete Anomali (Anomali penghapusan data)

Anomali pemasukan data adalah kesalahan-kesalahan dalam melakukan operasi penghapusan sebuah data yang disebabkan oleh desain database yang buruk.

Perhatikan kembali tabel 1.1, bagaimana apabila semua karyawan yang memiliki ID_perusahaan 1111 dihapus. Apakah kita masih memiliki dataperusahaan PT.BERSAMA? Tentu tida,karenadata-data tersebut akan ikut terhapus juga dan tidak akan tersisa. Ketika kita membutuhkan informasi mengenai perusahaan-perusahaan           yang [pernah ada dalam tabel 1.1, kita tidak akan mendapatkan informasi mengenai  PT. BERSAMA.

3. Update Anomali (Anomali pengubahan data)

Update Anomali  adalah kesalahan-kesalahan dalam melakukan operasi  pengubahn  sebuah data yang disebabkan oleh desain database yang buruk.

Perhatikan  kembali tabel   1.1, bagaimana apabila nama perusahaan PT. BERSAMA diganti menjadi PT. LANGKAH, apakah kita harus mengganti semua data karyawan yang bekerja pada PT. BERSAMA agar menjadi PT. LANGKAH?

Permasalahan-permasalahan seperti redudansi dan anomali seperti di atas umumnya dapat diatasi dengan membuat desain database yang baik yang dapat memperkecil terjadinya kesalahan pemanipulasian sebuah data.

Write comment

Name: Email:  do not notifynotify Title:     Please input the anti-spam code that you can read in the image.

Comments

Add New Search RSS

Lineage2 adena  - Lineage2 adena   |221.6.130.xxx |11-08-2010 08:27:17 L2 is very popular. Recently my friend and I always play it. And it is my favorite game link:http://www.cheapl2adena.com is very useful. As soon as you play this game, L2 adena is necessary. I often use link:http://www.cheapl2adena.com to get the link:http://www.cheapl2adena.com. My friends make money just through link:http://www.cheapl2adena.com, when they find  someone want to sell their L2 adena as link:http://www.cheapl2adena.com,they will buy it. Reply 0   0 Montblanc Sport Watches  - Blancpain Collection Léman watches   |59.61.148.xxx |29-01-2011 15:59:06 our shop gives you a hefty chance of restriction throughg a drunk appearance link:http://www.replica-watches-fan.com, link:http://www.replica-watches-fan.com/replica-b rm-gp44-gp44111-watch-p- 1030.html, link:http://www.replica-watches-fan.com/dior-watc hes-dior-dior-christal-c ollection-watches-c-182_26 8.html on-lpreferrede in the absence of discarding your inhabitant. we surrender you the men's in the midst of ladies' link:http://www.replica-watches-fan.com/replica-b reitling-windrider-colle ction-cockpit-488-watch-p- 895.html, link:http://www.replica-watches-fan.com/iwc-watch es-iwc-portugaise-watche s-c-224_227.html, link:http://www.replica-watches-f... Reply 0   0 nba shoes  - nba shoes   |175.44.23.xxx |14-08-2011 07:53:22 To do the honors to the link:http://www.nbashoesssales.com/ Americans, coming from Latvia where they followed the FIFA World u-19, there was also the President of the Consorzio Ancona for Sport, Renzo Lucioli, the impression given to the staff of the San Antonio from the sports facility; the American entourage in link:http://www.nbashoesssales.com/lebron-james-s hoes/ occasion confirmed the excellent link:http://www.nbashoesssales.com/ friendship established with the company marches which, link:http://www.nbashoesssales.com/ in turn, through this interchange can have a watch on players of interest and the dense network of scout  link:http://www.n... Reply 0   0 caine  - lv watches   |123.153.66.xxx |24-08-2011 13:03:19 grand complications watches link:http://www.watchesun.net/breitling-watches.h tml replica breitling try link:http://www.watchesbin.org/cartier-watches.ht ml cartier replica fake bell and ross link:http://www.watchestype.net/omega-watches.htm l omega replica her bushel of learning link:http://www.canwatch.org/rolex-watches.html replica rolex gucci watches link:http://www.watchestype.net/tag_heuer-watches .html replica tag heuer watches caleb link:http://www.tricwatches.com/ super avenger watches. Reply 0   0 abigale  - replica chopard watches   |123.153.66.xxx |24-08-2011 15:21:19 cheap watches link:http://www.watchesbin.org/ tag heuer new formula watches lot link:http://www.maticwatches.com/breitling-watche s.html replica breitling watches link:http://www.watchesun.net/cartier-watches.htm l replica cartier watches for sale tankissime watches walker link:http://www.watchesbin.org/omega-watches.html watches omega link:http://www.watchesdoc.org/rolex-watches.html replica rolex watches for sale receipts oris watches link:http://www.watchesbasic.org/tag_heuer-watche s.html watches tag heuer. Reply 0   0 limited  - cartier libre watches   |123.153.65.xxx |25-08-2011 07:14:09 chronoscaph watches link:http://www.canwatch.org/ rond louis watches embankment link:http://www.watchesdoc.org/breitling-watches. html fake breitling watches link:http://www.cor-watches.org/cartier-watches.h tml fake cartier watches never comes back addison link:http://www.watchescode.org/omega-watches.htm l replica omega link:http://www.watchestype.net/rolex-watches.htm l watches rolex July replica tudor watches link:http://www.maticwatches.com/tag_heuer-watche s.html watches tag heuer. Reply 0   0 BRM CT-48 Watch  - Hublot 301.CM.1140.RX.PCG08 Watch   |110.84.197.xxx |24-09-2011 16:20:19 You are able to select link:http://replica-easybuy.com/replica-brm-v1244 -v1244-gulf-watch-p-7541 .html, link:http://replica-easybuy.com/bell-ross-watches -bell-ross-2011-new-watc hes-c-69_576.html, link:http://replica-easybuy.com/tag-heuer-watches -tag-heuer-carrera-watch es-c-302_312.htmlhere such as link:http://replica-easybuy.com/replica-hublot-bi g-bang-black-magic-709ci 1770rx-watch-p-7618.htmlan d link:http://replica-easybuy.com/replica-ebel-ebel -classic-gent-xl-1215800 -watch-p-4222.html for gentlemen and gentlewomen.The global well known great watch maker link:http://replica-easybuy.com/breguet-watches-b reguet-type-xx-collectio n-watches-c... Reply 0   0 online   |117.28.249.xxx |10-11-2011 09:34:31 Fantastic prices on link:http://www.toryburchsoutlet-online.com/ and save up to 75% OFF. Everyday Free Shipping and Fast Delivery for all link:http://www.toryburch-outletonline.us/ online store. Hurry, make these popular Tory Burch Outlet shoes become your new go-to shoes. link:http://www.www.toryburchsoutletsus.com/tory- burch-flats-c-3.html is waiting for you. Reply 0   0 outlet   |117.28.249.xxx |10-11-2011 09:36:45 Tory Burch Cheap Sale Now! Everyday savings on adorable link:http://www.toryburchfactory-outlet.com/tory- burch-outlet-c-17.html styles your life will become more versatile! International Free Shipping to Worldwide Retail & Wholesale on all link:http://www.toryburchfactory-outlet.com/tory- burch-outlet-c-17.html. Welcome to enjoy! Reply 0   0 Coach Outlet Online  - Coach Outlet Online   |121.158.55.xxx |16-11-2011 13:04:59 One link:http://www.coachsfactoryoutlet.org/ of clothing link:http://www.coachfactorysoutletstoreonline.ne t/ be loose link:http://www.coachfactorystore-online.com/ compliment the link:http://www.coachoutletstoreonline.ca/ of the [url=http://www.coachsfactory- online.net/]Coach Factory[/url]. A loose link:http://www.coachfactorysoutletstoreonline.ne t/ or a skirt link:http://www.coachsfactoryoutlet-online.net/ help the link:http://www.coachfactoryoutletonlineh.com/ Bags flow link:http://www.mycoachfactorystoreonline.org/ what you link:http://www.coachoutletstoreonlineh.com/ wearing. Small link:http://www.coachfactorystore-online.com/ with a link:... Reply 0   0 tiffany rings   |117.66.197.xxx |16-11-2011 13:46:44 link:http://admin.blog.cz/clanky/clanek/55846581 link:http://tiffanyjewelry5423.weblog.ro/ link:http://www.bharatstudent.com/blogs/viewblog. php?blogid=32850&mode=bl og link:http://tiffany2heart.sosblogs.com/ link:http://cheap5423.skyrock.com/3042721589-A-mu ch-better-Analyze-Incorp orate-a-Recognized-And-Wel l-known-Forms.html link:http://set1wedding.sosblogs.com/ link:http://dzierbamarketing.com/ link:http://tiffanyabc5423.blog.com/ link:http://tiffany5423heart.blogs.sapo.pt/333.ht ml link:http://freeblognetwork.com/tiffanyabc123/827 348/ link:http://discount5423tiffany.journalspace.com/  link:http://engagement5423.over-blog.com/ link:http://www.pianetablog.com/entry.php?w=tiffa&nbsp... Reply 0   0 Powered by !JoomlaComment 3.26

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."