COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
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: -1NF (First Normal Forms): Requires that there be no multi-valued attributes, and that there be no repeating groups.
Detailed explanation-2: -1st Normal Form (1NF) A table is referred to as being in its First Normal Form if atomicity of the table is 1. Here, atomicity states that a single cell cannot hold multiple values. It must hold only a single-valued attribute.
Detailed explanation-3: -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-4: -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.