Register

UGC NET CSE | December 2013 | Part 3 | Question: 55

• edited by
2,451 views
4 votes
4 votes

Consider the following ER diagram:

The minimum number of tables required to represent $M, N, P, R_1, R_2$ is

  1. 2
  2. 3
  3. 4
  4. 5
• edited by
User Avatar

1 Answer

3 votes
3 votes

Minimum three table Required.

MR(M1,M2,M3,P1), P(P1,P2), N(P1,N1,N2).

M1 is PK of table MR.

P1 is the PK of table P and

{P1,N1} is the primary key of N.

User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

3 votes
3 votes
1 answer
2
go_editor asked Jul 29, 2016
2,271 views
UGC NET CSE | December 2013 | Part 3 | Question: 60
Match the following $:$ ... $\text{a-i, b-iii, c-iv, d-ii}$ $\text{a-ii, b-iv, c-i, d-iii}$
Match the following $:$$\begin{array} {clcl} & \textbf{List – I} && \textbf{List – II} \\ \text{a.} & \text{Secondary Index} & \text{i.} & \text{Functional Depende...
User Avatar
3 votes
3 votes
1 answer
3
go_editor asked Jul 29, 2016
1,762 views
UGC NET CSE | December 2013 | Part 3 | Question: 59
Armstrong $(1974)$ ... $\text{a-ii, b-i, c-iii, d-iv}$ $\text{a-iv, b-iii, c-i, d-ii}$
Armstrong $(1974)$ proposed systematic approach to derive functional dependencies. Match the following w.r.t functional dependencies:$\begin{array}{} & \textbf{List-I} ...
User Avatar
Link Copied!