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.

You can do it
  1. DFD stands for
  2. The one guideline to be followed while designing the database is
  3. Shadow paging has
  4. _____ First proposed the process of normalization.
  5. Immediate database modification technique uses
  6. A logical schema
  7. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  8. The data in the database at a particular moment of time is called the _______
  9. The middleware databases in which the business rules act are applicable to _______ tier architectures
  10. operator is used to compare a value to a list of literals values that have been specified.
  11. ____specifies a search condition for a group or an aggregate.
  12. The full form of GUI is _________
  13. ______contains information that defines valid values that are stored in a column or data type.
  14. The normalization was first proposed by .
  15. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  16. Which of the following aggregate functions does not ignore nulls in its results?.
  17. Isolation of the transactions is ensured by
  18. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  19. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  20. An advantage of views is
  21. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  22. It is an abstraction through which relationships are treated as higher level entities
  23. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  24. A relational database developer refers to a record as
  25. ______is a preferred method for enforcing data integrity
  26. Which of the following is not comparison operator?
  27. Union operator is a :
  28. Cascading rollback is avoided in all protocol except
  29. The rule that a value of a foreign key must appear as a value of some specific table is called a
  30. Which one is correct statement?Logical data independence provides following without changing application…