1. Explain one characteristic of a database that has data redundancy. Note: Redu

Question

1. Explain one characteristic of a database that has data redundancy. Note: Redundancy in our context is not a good thing

2. Briefly explain the benefits of normalization and why we should implement it when designing databases.

3. Determine whether you believe a compound if statement or a nested if statement is more efficient for your suggested situation / scenario in the first part of this discussion. Provide a rationale for your response.

4. Suggest one (1) example of a problematic programming situation or scenario that a Boolean expression could at least partially solve. Justify your response.

Explanation / Answer

1.Data redundancy occurs in database systems which have a field that is repeated in two or more tables. For instance, when customer data is duplicated and attached with each product bought then redundancy of data is a known source of inconsistency, since customer might appear with different values for given attribute.[1]Data redundancy leads to data anomalies and corruption and generally should be avoided by design.[2]Database normalization prevents redundancy and makes the best possible usage of storage.[3]Proper use of foreign keys can minimize data redundancy and chance of destructive anomalies.[2]However, concerns of efficiency and convenience can sometimes result inredundant data design despite the risk of corrupting the data

2.Normalization is the process of reducing the duplicity and dependency among the attributes within the table. Normalization is the method to decompose the large table into the small tables to minimize the duplicate records. If we are good to lower down the number of the similar types of the attributes in another table without any partial and transitive dependency from the table one by one. Non-normalized data can lead us to a big problem in our database.

Here is the explanation on the normalization forms. Let

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.