Home

Which normal form is considered adequate for normal relational database design?

A. 2NF

B. 5NF

C. 4NF

D. 3NF

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

You can do it
  1. In a relational schema, each tuple is divided into fields called
  2. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  3. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  4. The data in the database at a particular moment of time is called the _______
  5. The one guideline to be followed while designing the database is
  6. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  7. Which of the following relational algebraic operations is not from set theory?
  8. Data independence means
  9. The collection of information stored in a database at a particular moment is called as ......
  10. DBMS helps achieve
  11. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  12. Data items grouped together for storage purposes are called a
  13. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  14. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  15. A relational database developer refers to a record as
  16. Protection of data from unauthorized Disclosure results in loss of _______
  17. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  18. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  19. Which is the best file organization when data is frequently added or deleted from a file?
  20. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  21. For correct behaviour during recovery, undo and redo operation must be
  22. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  23. The statement that is executed automatically by the system as a side effect of the modification of the…
  24. In an E-R diagram double lines indicate
  25. Which of the following addressing modes permits relocation without any change over in the code?
  26. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  27. The part of a database management system which ensures that the data remains in a consistent state is
  28. ………………… approach reduces time and effort required for design…
  29. Relations produced from an E-R model will always be
  30. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…