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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started