a) Normalize the COLLEGE logical relational model from above into a 1NF, 2NF, and 3NF.

Clearly indicate each normalization level by showing the multi-valued attributes, Composite attributes, functional dependencies, and transitive dependencies decomposition on their respective normal forms.

Clearly indicate the primary–foreign key relationships and specify NOT NULL declarations where necessary. Show all the assumptions made.

Explain the types of anomalies that might occur in this relational model when not normalized.

logical relational model COLLEGE(StaffNo,Name,Position, FacultyNo,Faculty Address, PhoneNo, StaffHours) Consider StaffNo Name 1001 1002 1003 1004 1005 1006 1009 Paul Ryan Jamie Shuttle Vuke Josh HOD COLLEGE Position Dean Ziko Van Pili Tatu Dean Chad Zuma HOD Sipho Seth Administrator CF004 Dean FacultyNo Faculty Address CF001 Dean CF002 CF003 CF004 CF002 CF004 Pinelands, Town, 7405 below. Phone No 8 Jefferson Way, 021-555-3618, 18 Cape 021-555-2727, 021-555-6534 City Center Gardens, Town, 8801 Staffhours Plaza, 021-555-6756, 9 Cape 021-555-8836 18 - 8th Main Road, 021-371-3000 14 Claremont, Cape Town, 7708 14-18th Atlas Road, 021-555-3131, 14 Rondebosch, 7701 021-555-4112 14-18th Atlas Road, 021-555-3131, 7 Rondebosch, 7701 021-555-4112 City Center Plaza, 021-555-6756, 8 Gardens, Cape 021-555-8836 Town, 8801 14-18th Atlas Road, 021-555-3131, 14 Rondebosch, 7701 021-555-4112