Eu as tine datele normalizate - ca apoi, daca trebuie, sa le denormalizez intr-un view/ procedura stocata / date istorice.

Eu as folosi varianta 3 imbunatatita ca sa ajung la varianta 4.
E clar ca tabela HDD, de ex., nu e normalizata :
Ar trebui o tabela :

HDD
ID_Unic, numepartitie, id_computer
int,string , int

si alta
Date_HDD
id_hdd,spatiu,data
int,int,datetime
Vezi
http://en.wikipedia.org/wiki/Database_normalization#Normal_forms
si/sau cele 2 carti de aici (pina nu se termina oferta...)
http://www.red-gate.com/specials/Ebooks/March_offer2.htm?utm_source=simpletalk&utm_medium=email&utm_content=maketime2-20080317&utm_campaign=sqltoolbelt

---

Ignat Andrei
http://serviciipeweb.ro/iafblog