What is the difference between controlled and uncontrolled redundancy?
What will be an ideal response?
Redundancy is when the same fact is stored multiple times in several places in a database. For example, in Figure 1.5(a) the fact that the name of the student with StudentNumber=8 is Brown is stored multiple times. Redundancy is controlled when the DBMS ensures that multiple copies of the same data are consistent; for example, if a new record with StudentNumber=8 is stored in the database of Figure 1.5(a), the DBMS will ensure that StudentName=Smith in that record. If the DBMS has no control over this, we have uncontrolled redundancy.
You might also like to view...
If a product or service is not responsive to change it is inelastic
Indicate whether the statement is true or false
To move the active cell up one row, press ____.
A. Shift + Enter B. Ctrl + Tab C. Shift + Tab D. Ctrl + Enter
Which of the following media types is BEST for backups of very large storage systems?
A. Blu-Ray B. CD-ROM C. DVD D. Tape
Another name for the selection structure is the decision structure.
Answer the following statement true (T) or false (F)