CIS 2165 - Database Management Question 3 The table below lists sample Advisor/Student data, where AdvNum and StuNum for
Posted: Tue Jul 12, 2022 8:15 am
CIS 2165 - Database ManagementQuestion 3The table below lists sample Advisor/Student data, where AdvNum andStuNum form acomposite primary key like the homework from Chapters 5 and6.AdvNum StuNum AdvName AdvOffice StuName StuMajorS101 P100 T. Jones 10-110A G. White CISS101 P105 T. Jones 10-110A J. Bell MATHA264 P108 M. Thomas 10-110B I. McKay ENGA264 P110 M. Thomas 10-110B P. Wax CISV555 P105 R. Brown 10-111A J. Bell MATHV555 P110 R. Brown 10-111A P. Wax CISGive examples of insertion, deletion, and update anomalies with theabove table.I'm not looking for SQL statements or a normalized database.Describe anomalies based onwhat you see in this table. Write a sentence or two for each typeof anomaly.