Describe alternative schemes for fragmenting a global relation. State how you would check for correctness to ensure that the database does not undergo semantic change during fragmentation.
What will be an ideal response?
Alternative schemes are: primary horizontal, vertical, mixed, and derived horizontal fragmentation
Correctness rules are: completeness, reconstruction, and disjointness
You might also like to view...
You use a(n) ____ to specify both the records to select in a dataset and the order in which to arrange the records.
A. query B. question C. inquiry D. access
Give a set of functional dependencies for the relational schema R(A, B, C, D) with primary key AB under which R is in 1NF but not in 2NF.
What will be an ideal response?
If you change a file extension by renaming the file,
A) You also change the data in the file B) You also change the data header C) You will not be able to open the file D) Windows will change the icon that represents the file
For individual computers not running firewall software, you should directly close ports
Indicate whether the statement is true or false.