DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
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: -First normal form (1NF) means that a table has no multivalued attributes or composite attributes.
Detailed explanation-2: -This table is not in first normal form because the [Color] column can contain multiple values. For example, the first row includes values “red” and “green.” Now first normal form is satisfied, as the columns on each table all hold just one value.
Detailed explanation-3: -It is a level of normalization in DBMS. A relation is said to be in 1 normal form in DBMS (or 1NF) when it consists of an atomic value. In simpler words, 1NF states that a table’s attribute would not be able to hold various values-it will only be able to hold an attribute of a single value.
Detailed explanation-4: -4NF (Fourth Normal Form) If a relationship has no multivalued dependencies and is in Boyce Codd’s normal form, it is said to be in 4NF. The relationship is said to be a multivalued dependency if there are multiple values of B for a given value of A in a dependency A B.