Database Design Quiz Normalization part 1

a) The attribute can be NULL

b) Each value of one attribute determines exactly one value of another attribute

c) The attribute is not part of the primary key

d) The attribute depends on multiple attributes

a) To ensure redundancy

b) To establish relationships between tables

c) To prevent data entry

d) To act as the primary key

a) Increase data redundancy

b) Ensure data anomalies

c) Organize data in well-formed relations

d) Remove all data from the database

a) Retrieval anomaly

b) Sorting anomaly

c) Update anomaly

d) Backup anomaly

a) Adding a new employee

b) Removing an employee causing loss of department data

c) Changing an employee’s salary

d) Inserting new department data

a) Multiple values of A determining B

b) B fully functionally dependent on A

c) A and B being mutually dependent

d) No dependency between A and B

a) Inability to add data due to the absence of other data

b) Deletion of unnecessary data

c) Updating all records in a table simultaneously

d) Loss of data due to incorrect data retrieval

a) Full dependency

b) Functional dependency

c) Dependency preservation property

d) Cross dependency

a) Loss of data that is not intended to be deleted

b) Inability to insert data

c) Data duplication across multiple tables

d) Update failures across related tables

a) The number of tables

b) Data redundancy and anomalies

c) The speed of query execution

d) The number of users accessing the database