Transcription of CIS 331: Introduction to Database Systems - vacic.org
{{id}} {{{paragraph}}}
Example: bachelor of science
CIS 331: Introduction to Database Systems - vacic.org
NormalizationCIS 331: Introduction to Database SystemsVladimir Vacic, Temple University2 normalization : Reminder Why do we need to normalize? To avoid redundancy (less storage space needed, and data is consistent) To avoid update/delete anomaliesVladimir Vacic, Temple University3 normalization : ReminderSsn c-id GradeNameAddress123 cs331 Asmith Main123 cs351 Bsmith Main123 cs211 Asmith Main Clearly, Name and Address are redundant(larger relation + you have to update 3 rows to update the Address)Vladimir Vacic, Temple University4 normalization : Reminder Insertion anomaly:Cannot make a record Jones address because he is not taking any classesSsn c-id Grade Name Address123 cs331 Asmith null null jones ForbesVladimir Vacic, Temple University5 normalization : Reminder Delete anomaly.
Vladimir Vacic, Temple University 2 Normalization: Reminder Why do we need to normalize? To avoid redundancy (less storage space needed, and data is consistent)
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: