Explain what is meant by repetition of information and inability to represent

Explain what is meant by repetition of information and
inability to represent information. Explain why each of
these properties may indicate a bad relational database
design.

Question Posted / roshan g. subba

1 Answers
10759 Views
I also Faced
E-Mail Answers

Explain what is meant by repetition of information and inability to represent information. Explain..

Answer / shrikant patil

Repetition of Information is a condition in a relational
database where the values of one attribute are determined by
the values of another attribute in the same relation, and
both values are repeated throughout the relation. This is a
bad relational database design because it increases the
storage required for the relation and it makes updating the
relation more difficult.
- Inability to represent information is a condition where a
relationship exists among only a proper subset of the
attributes in a relation. This is bad relational database
design because all the unrelated attributes must be filled
with null values otherwise a tuple without the unrelated
information cannot be inserted into the relation.

Is This Answer Correct ?

10 Yes

0 No

Post New Answer

More Engineering AllOther Interview Questions

what is c dot

0 Answers

My gre score is 283 and ielts is 5.5, will i get i20 for this score

0 Answers

what is the work of Loopback ?

0 Answers

how to increase the water ring vacuum pump efficiency?

0 Answers

please send me minimum 15 library functions in c

1 Answers Qiscet,

how can i implement a program of polynomial adding,multiplication,through c language???

0 Answers

21. Find d Odd one out? a. LINUX b. WINDOWS 98 c. SOLARIS d. SMTP b. JAVA b. LISP c. Small talk d. Eiffel c. HTTP b. ARP c. SMTP d. SAP d. Linux b.windows NT c. SQL server d. UNIX e. SAP b. ARP c. WAP d.TCP IP f. Oracle b. Linux c. Ingress d. DB2 g. SMTP b. WAP c. SAP d. ARP h. WAP b. HTTP c. BAAN d. ARP i. SQL b. DB2 c. SYBASE d. HTTP

3 Answers TCS, Tech Mahindra,

please send aptitude test papers for reference with answers

0 Answers ZenQ,

Hi All... PLease send me if anyone have "Information Security Officer" Aptitude papers. Please Mail me at mannusanghi@gmail.com

0 Answers

Hi i want some previous interview questions and answers for KVB Bank.

0 Answers

what is the cycle between AHU and Chiller

0 Answers RotoPower,

I attended an interview with CGI last week for network engineer and here are the questions that might help you guys who are going to attend interviews.

1 Answers CGI,

For more Engineering AllOther Interview Questions Click Here