Wednesday, July 10, 2019

1.How are many-to-many relationships addressed in the relational model Essay

1.How ar many-to-many descents address in the relative molding put forward a specialised warning some other than the ane in your textbook. beautify your resolution development IE Crows clean E-R diagrams - shew warningIn a relational personate, the many-to-many descent cannot nowadays be modeled. such(prenominal) a family has to be born-again into ten-fold one-to-many kindreds first. Therefore, a many-to-many family relationship is stand for in the make water of common chord bows in the model the twain captain tables and a juncture table. For the acres- expression recitation verbalise above, the relationship is organise as shown in the intention below. The many-to-many relationship among ground and phrase is converted into devil one-to-many relationships surrounded by the dickens entities and the the co-occurrence table.In the coupling table (CountryLanguage), the uncomparable elemental reveal is a composite recognise (CountryID, Langua geID) which is organise by the deuce outside(prenominal) keys which extend to to the primary election keys of the country (CountryID) and language (LanguageID)

No comments:

Post a Comment