Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
DBMS
« Previous
Next »
Partial dependency is removed in ______ normal form
Options
- First
- Second
- Third
- Fourth
CORRECT ANSWER : Second
Discussion Board
2NF
Partial dependency is removed in second normal form. In this form, there must not be any partial dependency of any column on primary key. It means that for a table that has concatenated primary key, each column in the table that is not part of the primary key must depend upon the entire concatenated key for its existence. A table fails Second normal form when any column depends only on one part of the concatenated key.
Prajakta Pandit 03-15-2017 03:05 AM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
SQL Server (40)
SQL Server (28)
SQL Server (25)
Data Warehousing (10)
Biztalk (15)
SQL Server DBA (15)
Database (30)
Database (28)
DBMS (20)
Advertisement
▲