1. Introduce the concept of normalization in a letter to the executive and expla

Question

1. Introduce the concept of normalization in a letter to the executive and explain the pros and cons.

2. Explain the problems associated with data redundancy as it pertains to effectively using information for reporting and analysis.

3. Discuss your rationale for normalizing from your E-R Model and demonstrate:

a.                    How you derived at your 3NF from the earlier assignment

b.                   The process you took in arriving at your 3NF

c.                    The three (3) step technique of transforming your data model into first normal form, second normal form, and third normal form

4.       Produce a normalized E-R model using Visio

Explanation / Answer

1 Ans):Pro: When You Are Writing A Essay You Don't Have To Drag A Heavy Typewriter In Or Sit There All Day Writing It On A Piece Of Paper . Pro: When You Make A Mistake You Just Press Backspace. Before Computers Were Invented You Would Have To Rub It Out Or Use Wite Out But Now You Just Press Backspace Con: The more you use the computer to type an essay, etc. the less practice you're doing to improve your penmanship because you aren't used to writing so much. Con: You spend too many hours sitting in front of the computer, you start to become sidetracked (targeted towards students and their homework!) 2 Ans): Problem of Data Redundancy: The occurrence of data redundancy can lead to the following problems: (a) Redundant storage: Some information is stored repeatedly. (b) Update anomalies: If one copy of such repeated data is updated, an inconsistency is created unless all copies are similarly updated. (c) Insertion anomalies: It may not be possible to store some information unless some other information is stored as well. (d) Deletion anomalies: It may not be possible to delete some information without losing some other information as well. 3 Ans): The relational model is based on (relational) set theory in mathematics. Most commercial database products introduced in the last two decades are relational model (e.g., Oracle, Informix, DB2, Sybase, Ingres, MS SQL Server). A relation is nothing but a

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

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