Sunday, April 01, 2012 6:14 AMif a database is normalised by 3rd normal form then how many number of tables it should contain in minimum ? how many in minimum if 2NF and 1NF
- Edited by v60 Sunday, April 01, 2012 9:05 AM
Sunday, April 01, 2012 12:46 PM
That is an impossible question to answer, as every single database is different. Theoretically, the mimimum number of tables within any normal form is exactly 1 (Although this of course would be very unlikely and only in rare circumstances).
The point I am trying to make is that there is no minimum or maximum. I suggest that you normalise by applying the rules for each form and then validate your design by using an Entity Model Diagram. If this shows that all your relationships are 1:M than you are normalised.
Here is a link to the NF rules, buy Itzit Ben-Gan's book: Querying T-SQL also has a very good explination.
Hope this helps.
Peter Carter http://sqlserverdownanddirty.blogspot.com/
Friday, April 06, 2012 1:07 PM
I dont think it is possible to tell the exact number of tables after normalization. I think you should apply proper rules for normalization follow the link below.
Friday, April 06, 2012 2:36 PM
Please refer links provided by Peter Carter and jigvendtechi, that helps you to clarify NF's and process of normalisation.
In specific to your question, number of tables in a database is mostly based on scope of your project and business attributes. In a normal scenario, real time projects have more than one table in a normalised database that helps to build an application or data warehouse. If normalisation need to be applied while designing DB that is applicable for each table. So, if a database/table is in 3rd normal form then it is already in 1stNF and 2ndNF. Please refer the links below,
Hope this helps.
Please use Mark or Propose as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
Tuesday, April 10, 2012 11:44 PM
Please provide more detail. Is this an OLAP db or OLTP? When I design an OLTP db i always fully normalize it and then denormalize in situations where performance is enhanced.