Knowee
Questions
Features
Study Tools

Let M and N be two entities in an E-R diagram with simple single value attributes. R1 and R2are two relationship between M and N, where as R1 is one-to-many and R2 is many-to-many.The minimum number of tables required to represent M, N, R1 and R2 in the relational model are _______.Marks : 1Negative Marks : 0Answer here4673

Question

Let M and N be two entities in an E-R diagram with simple single value attributes. R1 and R2are two relationship between M and N, where as R1 is one-to-many and R2 is many-to-many.The minimum number of tables required to represent M, N, R1 and R2 in the relational model are _______.Marks : 1Negative Marks : 0Answer here4673

🧐 Not the exact question you are looking for?Go ask a question

Solution

The minimum number of tables required to represent M, N, R1 and R2 in the relational model are 3.

Here's the step by step explanation:

  1. One table for entity M.
  2. One table for entity N.
  3. One table for the many-to-many relationship R2.

The one-to-many relationship R1 does not require a separate table. It can be represented by including a foreign key in the "many" side of the relationship, that is, in the table for entity N. This foreign key would reference the primary key of the "one" side of the relationship, that is, the table for entity M.

This problem has been solved

Similar Questions

Consider the entities A1 and A2 in an ER diagram have simple single-valued attributes. B1 and B2 are the relations between A1 and A2. B1 is a one-to-many and B2 is a many-to-many relationship. There are no attributes present in B1 and B2. How many tables are required to represent this given model

Find the minimum number of tables required to represent the given ER diagram in relational model-

Consider the following ER diagram:The minimum number of tables needed to represent M, N, P, R1, R2 is:Marks : 1Negative Marks : 0Answer here2345

Consider the following Relationship Entity Diagram(ERD)  Which of the following possible relations will not hold if the above ERD is mapped into a relation model?Marks : 1Negative Marks : 0Answer herePerson (NID, Name)Qualification (NID, ExamID, QualifiedDate)Exam (ExamID, NID, ExamName)Exam (ExamID, ExamName)

Consider the following Entity-Relationship (E-R) diagram and three possible relationship sets (I, II and III) for this E-R diagram:I IIIIIIf different symbols stand for different values (e.g., t1 is definitely not equal to t2), then which of the above could not be the relationship set for the E-R diagram ?

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.