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.
Answer Posted / 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 View All Answers
explain overloaded constrator © constractor
how updates the data in target tables with tpump and mload? with low volume data and more duplicates... so in this case which perfomance is best? and write update query for tpump&mload?
what is the difference between verification and validation
. Give the C language equivalents of the following a)Function returning an int pointer b)Function pointer returning an int pointer c)Function pointer returning an array of integers d)Array of function pointer returning an array of integers
there are 50 users in a network, one system is virus affected , how to find that virus affected system?
Why do large ships like aircraft carriers not sink despite weighing several thousand tonnes?
what is locative information on web.........?
What is HPLC ? and define it.
What is IPSec?
why do you want to join tcs
What is VAT Account determination ? and how we can map in SAP ?
How do trains go around bends?
I have cleared SBT clerk exam and having interview on 29.I have completed my B.tech in IT.I would like to know the types of questions asked in the interview.
What is the difference between a .PST file and a .OST file?
which is the better form java or .net?exactly when we have to choose particcular 1 among them?