Answer the following questions based on the Entity-Relationship Diagram (ERD) in Figure 1. WW xx M...

 

Transcribed Image Text:

Answer the following questions based on the Entity-Relationship Diagram (ERD) in Figure 1. WW xx M VV A F ZZ uu B m n m nn gg mm n C G N D H E kk jj Rajah/Figure 1 hh a) Analyse and transform the above ERD into a relational database, indicating its primary keys and foreign keys. b) Using examples in (a), demonstrate how primary key and/or foreign key are used to support the relational modelling of strong entity types, weak entity types, 1-N relationships, M-N relationships and multi-valued attributes Answer the following questions based on the Entity-Relationship Diagram (ERD) in Figure 1. WW xx M VV A F ZZ uu B m n m nn gg mm n C G N D H E kk jj Rajah/Figure 1 hh a) Analyse and transform the above ERD into a relational database, indicating its primary keys and foreign keys. b) Using examples in (a), demonstrate how primary key and/or foreign key are used to support the relational modelling of strong entity types, weak entity types, 1-N relationships, M-N relationships and multi-valued attributes