Tuesday, July 18, 2017

Normalization

Cd
Track numbers
Artist, Artist Country Artists
CD Title
title of Track
Length of Track
Studio--label
Genre, sub genre
Year of release
warning

Normalization: First Normal Form
There should be no repeating groups, no arrays
Every column should be of the same type

13
Track
Bad vibrations, entrance song, the sniper

Phone/email

Second Normal form: Getting rid of sub sets

Third normal form: where one field describes another field that is not the key







No comments:

Post a Comment