COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It eliminates redundant data which in turn saves space and reduces manipulation anomalies.
|
|
|
It gives the data status.
|
|
|
It allows the tables to be queried in SQL.
|
|
|
It prevents any new updates.
|
Detailed explanation-1: -The advantage of having relational tables in 3NF is that it eliminates redundant data which in turn saves space and reduces manipulation anomalies. For example, the improvements to our sample database are: INSERT: Facts about the status of a city can be added even though there is not supplier in that city.
Detailed explanation-2: -Third normal form (3NF) is a database schema design approach for relational databases which uses normalizing principles to reduce the duplication of data, avoid data anomalies, ensure referential integrity, and simplify data management.
Detailed explanation-3: -Normalization helps to reduce redundancy and complexity by examining new data types used in the table. It is helpful to divide the large database table into smaller tables and link them using relationship. It avoids duplicate data or no repeating groups into a table.
Detailed explanation-4: -Normalization is to minimize the redundancy and remove Insert, Update and Delete Anomaly. It divides larger tables into smaller tables and links them using relationships.
Detailed explanation-5: -Second Normal Form (2NF) = ELIMINATE REDUNDANT DATA (if an attribute depends on only part of multi-valued key, remove it to a separate table).