Explain briefly with an example how an update anomaly might occur. b) How can you avoid...

 

Transcribed Image Text:

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 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