Home

What are the desirable properties of a decomposition

A. Partition constraint.

B. Dependency preservation.

C. Redundancy.

D. Security.

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. It is an abstraction through which relationships are treated as higher level entities
  2. Dependency preservation is not guaranteed in
  3. Change Staff table by removing default of Assistant for position column
  4. _____ First proposed the process of normalization.
  5. If an entity can belong to only one lower level entity then the constraint is
  6. Relations produced from an E-R model will always be
  7. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  8. The graphical representation of a query is .
  9. Which of the following is not a consequence of concurrent operations?
  10. Wait-for graph is used for
  11. Cascading rollback is avoided in all protocol except
  12. ____ table store information about database or about the system.
  13. Which of the following relational algebraic operations is not from set theory?
  14. _____clause is an additional filter that is applied to the result.
  15. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  16. ______contains information that defines valid values that are stored in a column or data type.
  17. The transactions like adding an employee, enrolling a student in a course are examples of _______
  18. Relationships among relationships can be represented in an-E-R model using
  19. A _____ is a logical unit of database processing that includes one or more data access operations that…
  20. A top-to-bottom relationship among the items in a database is established by a
  21. The clause alter table in SQL can be used to
  22. As per equivalence rules for query transformation, selection operation distributes over
  23. Which is the best file organization when data is frequently added or deleted from a file?
  24. Which normal form is considered adequate for normal relational database design?
  25. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  26. A _____ is used to define overall design of the database
  27. In multiple granularity of locks SIX lock is compatible with
  28. Which one is correct statement?Logical data independence provides following without changing application…
  29. Which of the following is a reason to model data?
  30. Which of the following is not a logical database structure?