CS403 GDB Solution:View more random threads:
- MGT211 Introduction To Business GDB no 1 fall Spring 2...
- PHY301 Circuit Theory GDB Solution Fall Semester 2013
- ENG401 GDB No. 1 Solution and Discussion Fall 2014 Due...
- MGT101 Financial Accounting GDB Solution and Discussion...
- MGT111 Introduction to Public Administration GDB No.2...
- HRM624 Conflict Management GDB No. 1 Solution on 22...
- Mgt603 VU Current GDB No. 2 Fall 2011 Last date 16 January...
- FIN630 Investment Analysis & Portfolio Management GDB no 1...
- MGT613 GDB Solution May 5 ,2010
- MGT 501 GDB solution Required
It is true normalization is a complex process and can be easily proved today’s most of RDBMs like SQL, Oracle etc are based on relation model like tables are connected to each other using primary and forgine keys.As we know there are five normalization forms first three are often used.In First normal form DBA has to identify the unique key for the entity identification.It become more complex when DBA has to identify redundant information (columns) in an entity and create separate table to place this information in rows and build relation between them in Second Normal form.It becomes even become more complex when DBA has to join two tables with the help of third table to build relation ship between two entities in third Normal form.The purpose of all effort is to reduce data redundancy between tables, to centralize information and only capture entity related information. The benefit of this is increase of DBMS performance, better hardware resource management and data integrity
Sponsored Links
There are currently 1 users browsing this thread. (0 members and 1 guests)