Normalization and DBMS

What is the primary purpose of normalization in database design?

• Reduce redundancy and dependency
• Increase data complexity
• Store all data in a single table
• Avoid using relationships

Which of the following is an example of data redundancy?

• Storing the same address multiple times
• Splitting data into multiple tables
• Using foreign keys for relationships
• Applying indexing for faster retrieval

What is a repeating group in the context of database design?

• A single value field
• A set of related fields occurring multiple times in a record
• A table with only primary keys
• A table with no attributes

In 1NF (First Normal Form), what happens to the data?

• It is split into two groups
• All data is stored in a single table
• It is duplicated for redundancy
• Data integrity is ignored

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

• Removing all dependencies
• Evaluating non-key attributes and removing partial dependencies
• Keeping all attributes in one table
• Eliminating primary keys

Which table is created when applying 3NF (Third Normal Form)?

• Booking
• BranchInfo
• Team-Booking
• All of the above

What is the benefit of normalization?

• Enhances data integrity and reduces redundancy
• Makes queries more complex
• Stores all data in a single column
• Removes primary keys from tables

Which of the following represents the lowest level in a 3-level database model?

• Conceptual Level
• Internal Level
• External Level
• None of the above

What does the Database Administrator (DBA) primarily do?

• Creates reports
• Oversees design, implementation, and maintenance of databases
• Runs SQL queries only
• Works only with external users

How does the DBMS ensure security through views?

• Allows unrestricted access to all users
• Grants controlled access without exposing the entire database
• Deletes user data periodically
• Stores encrypted passwords