CHAPTER 2 BLIS

What is normalization in the context of databases?

• A technique of organizing data into multiple related tables

• A method of encrypting data for security purposes

• A process of deleting all data redundancies

• A way to increase data redundancy

What is data redundancy?

• The repetition of similar data at multiple places

• The encryption of data

• The method of backing up data

• The process of compressing data

Which of the following is not a data redundancy issue/anomaly?

• Insertion anomaly

• Data encryption anomaly

• Deletion anomaly

• Update/Modification anomaly

What is an insertion anomaly?

• Inserting data in a random order

• Inserting data without permission

• Inserting redundant data for every new row

• Inserting data into the wrong table

What is a deletion anomaly?

• Deleting pieces of information such as shown in the table

• Deleting all data in a table

• Deleting data without a backup

• Deleting data in a specific order

What is an update/modification anomaly?

• A modification of data without permission

• A change of a particular data that is difficult due to redundancy

• An update of data in a random order

• An error that occurs during data updates

What is the purpose of Database Normalization?

• To increase data redundancy

• To encrypt all data in the database

• To divide the sample table into two

• To minimize data redundancy and increase reliability

What is the basic requirement in DB design according to 1NF?

• Each column should contain multiple values

• Each column should have a unique name

• The order of data saved in the table matters

• Each column should contain atomic values

What is the requirement to proceed to 2NF and 3NF?

• Having a single column in each table

• Encrypting all data

• Having multiple tables in the database

• Meeting the standards for 1NF

What is the purpose of 2nd Normal Form (2NF)?

• To have multiple types of attributes in each table

• To have non-partial dependency

• To increase data redundancy

• To have composite keys in all tables