Question at position 20 What key trade-off must designers consider when deciding 'what information will you store together' during normalisation?Deciding which users will be allowed to see the data dictionaryChoosing between using SQL or SPARQLBalancing the number of tables against the number of network edgesBalancing the convenience of duplicating data against the benefits of reducing redundancy and enabling more flexible queriesClear my selection

Question

BlackTom AI · Accepted Answer

Normalisation balances the convenience of duplicating data against the benefits of reducing redundancy and enabling more flexible queries.

Relevant knowledge points and concepts:
- Database normalisation: process of organizing tables to minimize redundancy and dependency by applying normal forms (1NF, 2NF, 3NF, BCNF).
- Data duplication vs normalization: denormalised designs duplicate values for faster reads but risk update/insert/delete anomalies and inconsistency; normalized designs split data into related tables to reduce redundancy and maintain integrity.
- Performance and usability trade-offs: more normalized schemas require joins (which can be costlier and complicate queries), while denormalised schemas simplify and speed some queries at the cost of extra storage and potential inconsistency.

Step-by-step reasoning:
1. Identify the goal of deciding “what information will you store together”: you must decide whether certain attributes belong in the same table or should be moved to separate related tables.
2. If you store duplicated attributes together (denormalised), queries that need that data are simpler and require fewer joins; however, every time that data changes you must update multiple rows (update anomaly), increasing risk of inconsistency.
3. If you split data into normalized tables, you reduce redundancy and enforce consistency via keys and relationships, and you gain flexibility for different query patterns; but you increase the number of joins and potentially the complexity and cost of queries.
4. Designers therefore weigh the practical convenience of duplication (read performance, simpler queries) against the theoretical and operational benefits of reduced redundancy (integrity, maintainability, flexible querying).

Why the correct answer is correct:
The stated option precisely captures this trade-off—convenience of duplicating data versus benefits of reducing redundancy and more flexible queries—which is the central decision in normalization.

Why other options are incorrect:
- “Deciding which users will be allowed to see the data dictionary” concerns access control and documentation, not normalization.
- “Choosing between using SQL or SPARQL” is about query language/technology choice, not schema normalization trade-offs.
- “Balancing the number of tables against the number of network edges” is irrelevant jargon; normalization concerns table structure and relationships, not “network edges.”

Conclusion: The correct answer is “Balancing the convenience of duplicating data against the benefits of reducing redundancy and enabling more flexible queries,” matching the provided answer.

类似问题

Question at position 19 Which of the following is a goal of a normalized relational database?Allow multiple users to access data without securityUse data silosEliminate redundant data by using linksStore all data in a single tableClear my selection

Question at position 11 Which of the following is a goal of a normalized relational database?Use data silosEliminate redundant data by using linksAllow multiple users to access data without securityStore all data in a single tableClear my selection

Question at position 6 Which of the following is a goal of a normalized relational database?Use data silosAllow multiple users to access data without securityEliminate redundant data by using linksStore all data in a single tableClear my selection

The process of Normalization is primarily about:

Which of the following is NOT something normalization is trying to do?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单