COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
First Normal Form
|
|
|
Second Normal Form
|
|
|
Third Normal Form
|
|
|
Fourth Normal Form
|
Detailed explanation-1: -1. In the normal form, a composite attribute is converted to individual attributes. Explanation: The first normal form is used to eliminate the duplicate information. Explanation: The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.
Detailed explanation-2: -First normal form (1NF) is a property of a relation in a relational database. A relation is in first normal form if and only if no attribute domain has relations as elements. Or more informally, that no table column can have tables as values (or no repeating groups).
Detailed explanation-3: -1NF:-First normal form (1NF) is a relation in which the intersection of each row and column contains one and only one value. 2NF:-Second Normal Form (2NF) is based on the concept of fully functional dependency.