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

Answer rating: 100% (QA)

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... View the full answer