Question
Anomalies are problems that can occur in poorly planned, un-normalized databases where all the data is stored in one table. Being a database designer you
Anomalies are problems that can occur in poorly planned, un-normalized databases where all the data is stored in one table. Being a database designer you have been given the task to design a database for a company. Each employee in a company has a department associated with them as well as the student group they participate in. Suppose you designed the following database. Determine which anomalies can occur after designing the following un-normalized database? How the redundancy affects the database?
Explain the answer with the possible occurrence of anomalies example and derive a solution to overcome redundancy.
| Employee_ID | NAME | Department | Student_Group |
| 11 | Akbar Khan | CS | CS_Alpha |
| 22 | Tahir Ali | EL | EL_FEST |
| 22 | Tahir Ali | EL | Management hub |
| 33 | Irfan Ahmed | SE | Software Tech |
| 33 | Irfan Ahmed | SE | Software Beta |
Step by Step Solution
3.32 Rating (155 Votes )
There are 3 Steps involved in it
Step: 1
INSERTION anomaly If an employee is hired and not assigned to any deparment and student group then department and studentgroup column will get null va...
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
Systems analysis and design
Authors: kenneth e. kendall, julie e. kendall
8th Edition
135094909, 013608916X, 9780135094907, 978-0136089162
