Register

GATE CSE 1992 | Question: 13a

• retagged by
1,538 views
6 6 votes

How is redundancy reduced in the following models?

  1. Hierarchical
  2. Network
  3. Relational

1 Answer

1 1 vote
13(b)

Select s.hotel

From serves s,likes l

Where s.snacks =l.snacks

And l.customer = "Rama"
Voting & Accepting an answer helps improve the community
← Previous · GATE CSE 1992 | Ques...Next → · GATE CSE 1992 | Ques...
← Previous in category · GATE CSE 1991 | Ques...Next in category → · GATE CSE 2000 | Ques...
Position:
Show:

Related questions

75 75 votes
9 answers 9 answers
39.9k
39.9k views
Kathleen asked Sep 13, 2014
39,911 views
GATE CSE 1992 | Question: 5-a
The access times of the main memory and the Cache memory, in a computer system, are $500$ n sec and $50$ nsec, respectively. It is estimated that $80\%$ of the main memor...
39 39 votes
4 answers 4 answers
8.1k
8.1k views
go_editor asked Apr 24, 2016
8,149 views
GATE CSE 1992 | Question: 13b
Suppose we have a database consisting of the following three relations:$$\begin{array}{|c|c|} \hline \text {FREQUENTS} & \text {(CUSTOMER, HOTEL)} \\\hline \text {SERVES}...
16 16 votes
2 answers 2 answers
4.6k
4.6k views
go_editor asked Apr 24, 2016
4,641 views
GATE CSE 1992 | Question: 07b
Consider the function $F(n)$ for which the pseudocode is given below :Function F(n) begin F1 ← 1 if(n=1) then F ← 3 else For i = 1 to n do begin C ← 0 For j = 1 to n – 1 ...
12 12 votes
1 1 answer
3.5k
3.5k views
go_editor asked Apr 24, 2016
3,478 views
GATE CSE 1992 | Question: 10b
Show the activation records and the display structure just after the procedures called at lines marked $x$ and $y$ have started their execution. Be sure to indicate which...