Register

NIELIT 2016 MAR Scientist C - Section C: 5

• retagged by
1,532 views
2 votes
2 votes

A primary key, if combined with a foreign key creates

  1. parent child relationship between the tables that connect them
  2. many-to-many relationship between the tables that connect them
  3. network model between the tables that connect them
  4. none of these
• retagged by
User Avatar

5 Answers

0 votes
0 votes
the primary table will act as the parent table while the table with the foreign key will act as the child table.In such a case,one parent can have more than one child,creating a one to many relationship.The correct answer is choice number 1
User Avatar
Page:
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

3 votes
3 votes
4 answers
1
admin asked Apr 2, 2020
2,425 views
NIELIT 2016 MAR Scientist C - Section C: 3
Every Boyce-Codd Normal Form (BCNF) decomposition is dependency preserving not dependency preserving need be dependency preserving none of these
Every Boyce-Codd Normal Form (BCNF) decomposition isdependency preservingnot dependency preservingneed be dependency preservingnone of these
User Avatar
2 votes
2 votes
2 answers
2
admin asked Apr 2, 2020
4,972 views
NIELIT 2016 MAR Scientist C - Section C: 4
A functional dependency of the form $x\to y$ is trivial if $y\subseteq x$ $y\subset x$ $x\subseteq y$ $x\subset y\:\text{and}\:y\subset x$
A functional dependency of the form $x\to y$ is trivial if$y\subseteq x$$y\subset x$$x\subseteq y$$x\subset y\:\text{and}\:y\subset x$
User Avatar
1 votes
1 votes
2 answers
3
admin asked Apr 2, 2020
761 views
NIELIT 2016 MAR Scientist C - Section C: 34
Given the following relation instance: $\begin{array}{ccc} X & Y & Z \\ \hline 1 & 4 & 2 \\ 1 & 5 & 3 \\ 1 & 6 & 3 \\ 3 & 2 & 2 \end{array}$ Which of the following functional dependencies are ... $YZ \rightarrow X \text{ and } X \rightarrow Z$ $XZ \rightarrow Y \text{ and } Y \rightarrow X$
Given the following relation instance:$\begin{array}{ccc} X & Y & Z \\ \hline 1 & 4 & 2 \\ 1 & 5 & 3 \\ 1 & 6 & 3 \\ 3 & 2 & 2 \end{array}$Which of the following function...
User Avatar
Link Copied!