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 / 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 |
How do trains go around bends?
A sheet of paper has statements numbered from 1 to 30. For all values of n from 1 to 30, statement n says "At most n of the statements on this sheet are false". Which statements are true and which are false? a) All statements are true. b) All statements are false. c) The odd numbered statements are true and the even numbered are false. d) The even numbered statements are true and the odd numbered are false.
What are the features of tata nano , technical specification of tata nano, overview of tata nano, varients of tata nano, price of tata nano, dealers of tata nano, expectation from tata nano, criticism of tata nano, tata nano hybrid ?
what are register variables?what are the advantages of using register variables in c language?
MILITARY ENGINEER SERVICES
how do we calculate physical address if logical address is given in the question?
what is the diffeence between SQL and ORACLE?
difference between user and kernel mode?
Who is responsible for PLLs?
in b+ trees, all the data is stored in leaf nodes. if all leaf nodes are crashed then how to get/recovery the data back?
plz send me interview questions & answers of Data Structure
write a program to print only the largest number between elements of an 1-d array?
Civil Engineering (5086)
Mechanical Engineering (4456)
Electrical Engineering (16639)
Electronics Communications (3918)
Chemical Engineering (1095)
Aeronautical Engineering (239)
Bio Engineering (96)
Metallurgy (361)
Industrial Engineering (259)
Instrumentation (3014)
Automobile Engineering (332)
Mechatronics Engineering (97)
Marine Engineering (124)
Power Plant Engineering (172)
Textile Engineering (575)
Production Engineering (25)
Satellite Systems Engineering (106)
Engineering AllOther (1379)