Home

In 2NF

A. No functional dependencies (FDs) exist.

B. No multivalued dependencies (MVDs) exist.

C. No partial FDs exist.

D. No partial MVDs exist.

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

You can do it
  1. Data independence means
  2. If the closure of an attribute set is the entire relation then the attribute set is a
  3. Dependency preservation is not guaranteed in
  4. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  5. A logical schema
  6. E-R Modeling is achieved by using ____ diagrams
  7. In SQL the word natural can be used with
  8. Manager salary details are hidden from the employee .This is
  9. The middleware databases in which the business rules act are applicable to _______ tier architectures
  10. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  11. Change Staff table by removing default of Assistant for position column
  12. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  13. The one guideline to be followed while designing the database is
  14. ____ table store information about database or about the system.
  15. For correct behaviour during recovery, undo and redo operation must be
  16. Which normal form is considered adequate for normal relational database design?
  17. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  18. The part of a database management system which ensures that the data remains in a consistent state is
  19. Which of the following is not a characteristic of a relational database model?
  20. In b-tree the number of keys in each node is than the number of its children.
  21. Which of the following is not comparison operator?
  22. Which of the following is true for network structure?
  23. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  24. Data items grouped together for storage purposes are called a
  25. The data in the database at a particular moment of time is called the _______
  26. What are the desirable properties of a decomposition
  27. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  28. Which of the following concurrency control schemes is not based on the serializability property?
  29. Which of the following is not a recovery technique?
  30. Which one is correct statement?Logical data independence provides following without changing application…