PRELIM PART 2

What is the main purpose of normalization in a database?

• Increase data redundancy

• Organize data into multiple related tables

• Slow down data retrieval

• Delete all data

What is data redundancy?

• The repetition of similar data at multiple places

• A way to speed up data retrieval

• A technique of organizing data

• A method to secure data

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

• Data Integrity anomaly

• Update/Modification anomaly

• Deletion anomaly

• Insertion anomaly

What is an Insertion Anomaly in a database?

• Changing a particular data

• Deleting pieces of information

• Repeating data for every new row

• Inserting data into the wrong table

What is the first step in the normalization process?

• Ensuring data is easily extended and retrieved

• Creating multiple unrelated tables

• Increasing data redundancy

• Deleting all data

What is the basic requirement for a database to be in the 1st Normal Form (1NF)?

• Each column should contain multiple values

• Each column should contain atomic values

• Each column should have a unique name

• Data order in the table matters

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

• Ensure data is easily extended

• Remove partial dependency

• Allow data to be stored in any order

• Increase data redundancy

What is required for a database to be in the 3rd Normal Form (3NF)?

• Composite Key

• Partial dependency

• Transitive dependency

• First and Second Normal Form

What is a composite key in a database?

• A key that is not unique

• A key that is easy to guess

• A key that is not needed

• A key made up of multiple columns

Which of the following is an example of a composite key?

• Order no

• Course Fee

• StudentID

• CourseID