edited by
314 views
0 votes
0 votes

 

Let $\text{E}1$ and $\text{E}2$ be two entities in an $\text{E/R}$ diagram with simple single-valued attributes. $\text{R}1$ and $\text{R}2$ are two relationships between $\text{E}1$ and $\text{E}2,$ where $\text{R}1$ is one-to-many and $\text{R}2$ is many-to-many. $\text{R}1$ and $\text{R}2$ do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model?

  1. $2$
  2. $4$
  3. $3$
  4. $5$
edited by

1 Answer

0 votes
0 votes

E1 -----R1/R2-------E2     

R1:Many to One

R2:Many to Many

Required Tables:

E1---->1 and E----->1 

R1 can be represented by adding foreign Key to may Sided Relation.

R2 require another table which will contain Primary Key of both E1 and E2

Hence in total 3 tables are required.

Answer:

Related questions

0 votes
0 votes
1 answer
2
admin asked Jan 5, 2019
434 views
We have a database table with relational schema $\text{R(XYZPQ)}:$$$\begin{array}{|c|c|c|c|c|} \hline \text{X} & \text{Y} & \text{Z} & \text{P} & \text{Q} \\\hline \text{...
1 votes
1 votes
1 answer
4
admin asked Jan 5, 2019
380 views
The set of equations $x^{2} + y^{2} = 1$ and $x + y = 0$ has how many real solutions?Infinite number of solutionsNo solution$2$ solutions$1$ solution