Explain briefly with an example how an update anomaly might occur. b) How can you avoid the anomaly? Student number Student name $1198121 Nosheen $2729923 Sachin 19828313 John $8837383 $8792892 57892829 $9828980 $7729922 $9229923 b) Nosheen Emon Your answers: Fahimeh Robert Daniel Maria COURSE CLASS Grade Teacher ID Teacher name Teacher phone 7 $2982029 Mohammad $2982029 Mohammad 6 7 373 55032 37355032 373 55032 $2982029 Mohammad 7 $7479400 John 555 78544 6 $7479400 John 5 57479400 John 555 78544 555 78544 37355032 52982029 Mohammad 57479400 John 7003ct Database design 5 $7479400 John 555 78544 555 78544 Course ID 2814ct 2814ct 2814ct 7003ct 7003ct 7003ct 2814ct 7003ct 2) In the entity relationship diagram (ERD) below, for each entity write: a) Its primary key, b) Connectivity, c) Participation, and d) Cardinality. COURSE CRS.CODE DEPT CODE CRS DESCRIPTION CRS CREDITS Your answers (complete the table): Entities Primary keys Course name Data management Data management Data management Database design Database design Database design Data management 7 Database design 6 Connectivity CLASS CRS CODE CLASS SECTION www CLASS TIME ROOM CODE PROF NUM Participation Cardinality