please answer these true and false questions . note: please make sure it\'s the

Question

please answer these true and false questions .
note: please make sure it's the right choice. thanks

1 works through a series of stages called normal forms Normalization 2. Normalization is a process that is used for changing attributes to entities b, False 3. In order to meet performance requirements, portions of the database design may need to be occasionally denormalized 4. Denormalization produces a lower normal form. b, False 5. Normalization is a very important database design ingredient, and the highest level is always the most desirable a. True 6. Reporting anomalies in a table can cause a multitude of problems for managers and can be fixed through application programming a. True 7. Data redundancy produces data anomalies. b. False 8, The objective of normalization is to ensure that each table conforms to the concept of wellformed relations a True b. False 9. Relational models view data as part ofa table or collection of tahles in which all key values must be identified. b, False 10. Repeating groups must be e nated by ensuring hat each row defines a single entity. b, False

Explanation / Answer

Ans 1) True

Explanation:- Normalisation is a process to minimise data redundancy and increase database performance. It works by converting tables into normal forms like 1NF,2NF,3NF etc.,

Ans 2) False

Explanation:- During normalisation we wont change attributes to entities, just we create new tables and shift attributes from table to other table.

Ans 3) True

Explanation:- Denormalisation is a process used to increase database performance by adding some redundant data to normalised table to reduce some database problems associated with queries that combine data from various tables to produce output.

Ans 4) False

Explanation :- Denormalisation involves adding some redundant data to normalised tables and it wont produce any lower normal form.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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