A university want to keep record of students placed in different companies in following way:

• Do you think its un normalized from? If yes then construct a normalized table up to 3NF(3^rd normal form).
• Explain what anomalies may causes if store data in such fashion?

STUDENT ID	STUDENT NAMES	COMPANY NAME	COMPANY LOCATION	Department	Company ID
1	Brian Smith, James, Jakub	NBC Services, NBC Services	London	Construction	1
2	Laura Grey	ABC Corporation	Nottingham	Interior design	2
3	John Brown	IBM Limited	Birmingham	Consultant services	3
4	Peter Black, JASON HUK	MCI Software, MCI Software	Edinburgh	IT	4

Answer rating: 100% (QA)

1 The table is not normalized Anomalies that can result from its current form include update and del... View the full answer