Schema Refinement in Database Management Systems, Study notes of Database Management Systems (DBMS)

Download Schema Refinement in Database Management Systems and more Study notes Database Management Systems (DBMS) in PDF only on Docsity!

SCHEMA RE FINEMENT™ é hema ltfinement in database desvgn (Ss fe analy 3? th a tection ef velahens in pur retahenal database gchem den tfy potentral problems Land to reAne re. when we use Schema refinement , we often nohe the ain problem is redundancy. Problems caused by Pedundancy» ming the Same informathen vedundantly , that (5, in more P one place within a database can lead -to cevera! ) blemsi- pedundant Storage some tnformahen is ghred redundantly Updale Anomalies '- If one copy of such repeated data "Ss updated yan 1) Sonsisten cy \s created unless all copies are similarly updated: Insertion Anomalies ye may not be possible to stove certain tnformation unless some other, Unrelated informahon 15 Sbored as well. peleHOon Anomalies)- te may not de possible ts Se lete Certain information without (oSing Some they bre lated informabon as well.