database Quiz 2 revision

the purpose of normalization is to achieve what?

• reduced data anomalies

• reduce data redundancy

• correcting table structures

• all the above

how does update anomaly happen?

• full updates

• partial updates

A _____ anomaly is the unintended loss of data due to deletion of other data?

what causes insert anomaly?

• absence of other data

• partial updates

• deletion of other data

• duplicate data

which is the first form that we start with

• 2nf

• 3nf

• unf

• 1nf

can we have multivalued attributes in 1nf?

• yes

• no

to be in 2nf do you also need to be in 1nf?

• yes

• no

what do we need to fix to create 2nf?

• transitive dependencies

• partial key dependencies

• values that depend on non-keys

is the table here in 1nf?

client_ID, client_name, order_IDs, items, item_prices

• true

• false

is the following table in 2nf?

car_no, car_name, car_make, car_year, trim_id, trim_name, trim_price

• no

• yes