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
what do you mean by CPU register?
what is the difference betweeen far pointer and near pointer
what in 4th and 5th normal form ??
Write a regular expression for "Capgemini Services Pvt.Ltd"
Q1. A. Compare the advantages and disadvantages of a three- dimensional monitor using a varifocal mirror with a stereoscopic system. B. Write a routine to implement the polymarker function.
If you had a cylinder, sealed at both ends, with the pressure rising inside, would it blow at the end or split along the side first?
how to write regression test case?what is the difference between Client server & web based Testing? can we able to do UI Testing in web based Testing
I have attended offcampus conducted by polaris chennai.And i have cleared all rounds on 10th June 2014.They collected all my marksheet xerox and address proof and said that they will send me offer letter in 3 days.. But more than 15days passed but still i didnt receive any information. I am lot depend on this offer... so when can i expect offer letter?? will they surely send me offer letter?
what is node class?
what's the difference between windows serevr 2003 or windows XP.
what is the advantage of msil in c#
can u perform addition of two octal numbers using java?
Write a function that responds to a click anywhere on the page by displaying an alert dialog. Display the event name if the user held Shift during the mouse click. Display the element name that triggered the event if the user held Ctrl during the mouse click.
WHAT HAPPEN WHEN ANY SPINDLE RUN OVER 10 MM HEIGHT ABOVE BOLSTAR IN RING SPINNING FRAME
who to change a passward in router?