Question: Last semester astudent sent me the following email while developing the project with her group (paraphrased & condensed): Why are Job Code/ID, Emp ID, and

Last semester astudent sent me the following email while developing the project with her group (paraphrased & condensed): "Why are Job Code/ID, Emp ID, and Emp Last Name all stored in an event table for that event's internal agent?And why is Job Description stored & displayed in the Emp table rather than Job Code/ID?This makes the Job Code table unnecessary.Worse, it violates redundancy rules, duplicates attribute data, and wastes storage space."

This made me fear that others in the class might be sharing her confusion.Email to me what she is misunderstanding about the benefits of relational databases, including (1) what is actually being stored, (2) the effects on top management looking at the displayed data and (3) the strengthening of controls.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!