Database Design Quiz Normalization part 1

What does it mean when an attribute is "fully functionally dependent" on another attribute?

• 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

What is the role of foreign keys in relational databases?

• a) To ensure redundancy

• b) To establish relationships between tables

• c) To prevent data entry

• d) To act as the primary key

What is the main objective of normalization in database design?

• a) Increase data redundancy

• b) Ensure data anomalies

• c) Organize data in well-formed relations

• d) Remove all data from the database

Which of the following is a type of anomaly caused by data redundancy?

• a) Retrieval anomaly

• b) Sorting anomaly

• c) Update anomaly

• d) Backup anomaly

In the EMPLOYEE relation, what is an example of a deletion 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

Which of the following is a correct functional dependency in a well-normalized table?

• 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

What is an insertion anomaly?

• 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

Which property of a well-normalized table ensures that no non-primary attributes are dependent on anything other than the primary key?

• a) Full dependency

• b) Functional dependency

• c) Dependency preservation property

• d) Cross dependency

What is the result of a deletion anomaly in a database?

• 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

What does normalization primarily aim to reduce in a relational database?

• a) The number of tables

• b) Data redundancy and anomalies

• c) The speed of query execution

• d) The number of users accessing the database