1) Which of the following NOT true regarding normal forms?
A) : 2066016
1) Which of the following is NOT true regarding normal forms?
A) If a database is stated to be 3NF, this means that all tables in the database meet the criteria for the first three normal forms.
B) The highest level of normal form is 3NF.
C) Each level represents the table's vulnerability to redundancy, anomalies, and inaccuracies.
D) The highest normal form is the level that a table satisfies along with all levels below.
2) Which of the following is NOT true regarding first normal form?
A) The first normal form dictates that the table must not have repeating groups of values in a single column or anomaly and that it must have a key.
B) In 1NF each nonkey field needs some sort of dependency on the key.
C) A record is considered atomic when none of the values are repeating or concatenated for a single column.
D) If the values are repeated in the rows that are currently blank, each row will become atomic and each row will represent one database record or tuple.
3) Which of the following is NOT true regarding anomalies?
A) Anomalies can be categorized into three types–insert, delete, and update.
B) One goal of concatenating fields is to minimize anomalies.
C) Update anomalies can be difficult to detect.
D) Anomalies are unmatched or missing data that is caused by limitations in database design.
4) A(n) ________ anomaly forces you to enter data about two different entities when you have data on only one entity.
5) A(n) ________ anomaly forces you to change data in multiple records, such as when you need to change the name of a product and you must change multiple rows.