Welcome to Sign in | Help
in Search

Tables

Last post 12-14-2006, 4:09 PM by xmldeveloper. 16 replies.
Page 2 of 2 (17 items)   < Previous 1 2
Sort Posts: Previous Next
  •  12-14-2006, 1:00 PM 1331 in reply to 1330

    Re: Tables

    E vorba ca cel mai des uzitate sunt FN1, FN2 si FN3 (nu numai FN3).

    Un lucru este interesant si trebuie avut in vedere: nu se dau formule, panacee pentru o schema de baze de date viabila

    ci totul depinde de experienta (arta) analistului.

    De exemplu, ati vazut ca uneori apar in anumite baze de date serioase,  facute pentru aplicatii la fel de serioase coloane

    de tip Address1, Address 2 si chiar Address3. Dupa FN1 acestea n-au ce cauta intr-o tabela normala la cap, insa iata ca se accepta

    din motive de query/aplicatie. 


    Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
  •  12-14-2006, 4:09 PM 1337 in reply to 1331

    Re: Tables

    A aparut si o a 6-a http://en.wikipedia.org/wiki/Database_normalization
    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
Page 2 of 2 (17 items)   < Previous 1 2
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems