Database Design Using Normalization Questions and Answers
Database Design Using Normalization questions with answers focus on organizing database structures efficiently by minimizing redundancy and ensuring data integrity. This is a key topic in programming interview questions with answers and technical tests conducted by companies like TCS, Infosys, and Wipro. Normalization involves dividing large tables into smaller, related ones to optimize database performance. Understanding various normal forms (1NF, 2NF, 3NF, BCNF) helps developers design efficient relational databases. Practicing normalization aptitude and programming questions enables candidates to solve real-world database design challenges during coding and placement exams.
Understand database normalization techniques. Also explore logical database design and physical database design
Database Design Using Normalization
11. When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
- first step.
- second step.
- third step.
- fourth step.
12. Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
- Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- Three rows have the values Brown, NULL, and Blue in the same column.
- One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
13. When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
- first step.
- second step.
- third step.
- fourth step.
14. If a table has been normalized so that all determinants are candidate keys, then that table is in:
- 1NF.
- 2NF
- 3NF.
- BCNF.
16. Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
- advantage
- disadvantage
- either an advantage or disadvantage
- neither an advantage nor disadvantage
17. When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
- first step.
- second step.
- third step.
- fourth step.
18. Normalization ________ data duplication.
- eliminates
- reduces
- increases
- maximizes
19. Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
- Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- Three rows have the values Brown, NULL, and Blue in the same column.
- One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column
20. A BI reporting system does not ________ .
- create meaningful information
- deliver information to users on a timely basis
- use statistical procedures to predict future events
- use disparate data sources