Please enable JavaScript.
Coggle requires JavaScript to display documents.
NORMALISATION 1NF, Multivalued attributed are being separated, DELETION…
NORMALISATION 1NF
Normalization is the process of organizing the data in the database.
Normalization
Single(atomic) valued attributes/columns
Attribute Domain does not change
Unique name for every Attribute/Column.
Order in which data is stored, does not matter
ADVANTAGES
Removes the unnecessary repeating values
Removes ambiguity
IMAGE ANALOGY
ANOMALIES
Insertion
Deletion
Update
VIDEO ANALOGY
https://drive.google.com/file/d/185_0nOpLA8cZFwHTgFM7jgsKABaBew-q/view?usp=sharing
https://drive.google.com/file/d/18QlkrBtTj4zZPAO-ZfgWWcSc4YfsRU5i/view?usp=sharing
Multivalued attributed are being separated
DELETION ANOMALY
UPDATE ANOMALY
