A 3 NF relation is split into 4 NF

  1. Home
  2. Back

Question:
A 3 NF relation is split into 4 NF

1.by removing overlapping composite keys

2.by splitting into relations which do not have more than one independent multivalued dependency

3.removing multivalued dependency

4.by putting dependent non-key attribute in a separate table

Posted Date:-2021-12-09 15:28:44

More MCQS Questions and answers

  1. A 3 NF relation is converted to BCNF by
  2. A 3 NF relation is split into 4 NF
  3. A check pointing system is needed
  4. A conceptual data model is converted using a Relational Data Base Management System to a
  5. A database administrator
  6. A database is a
  7. A database models data so that it is
  8. A database should be designed to allow providing
  9. A DBMS
  10. A DBMS is
  11. A query operation on a object
  12. A relation is said to be in BCNF when
  13. A relation which is in a higher normal form
  14. A subset of logical data model accessed by programmers is called a
  15. A subsystem of a complex system must specify
  16. Access right to a database is controlled by
  17. Attributes are assigned value
  18. By polymorphism of a subsystem we mean
  19. By redundancy in a file based system we mean that
  20. By relation cardinality we mean
  21. Computer systems are designed by
  22. Data availability is often difficult in file based system
  23. Data independence allows
  24. Data integrity in a file based system may be lost because
  25. Data integrity is ensured by
  26. DBMS
  27. Entities are identified from the word statement of a problem by
  28. Fourth normal form (4 NF) relations are needed when
  29. Functions and procedures are
  30. Given a word statement of a problem potential objects are identified by selecting
  31. Given a word statement of problem potential operations appropriate for objects are identified by selecting
  32. Given an attribute x, another attribute y is dependent on it, if for a given x
  33. Given the following relation vendor order ( vendor no, order no, vendor name, qty supplied, price/unit) it is not in 2 NF because
  34. Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address)
  35. If an entity appears in N relationships then it is
  36. If an entity appears in not more than 5 relationships then it is a
  37. In object-oriented design
  38. In UML diagram of a class
  39. Inheritance in object-oriented modelling can be used to
  40. Object-oriented system modelling using CRC method gives
  41. Objects may be viewed as
  42. Pick entity set from the following
  43. Relationships are identified from the word statement of a problem by
  44. TEACHER-STUDENT relation in Mini-case example 2 is required because
  45. The attributes of relationship teaches in teacher teaches course should be
  46. The columns of a relation
  47. The entity set is a
  48. The expansion of the acronym CRC is
  49. The project guidance relation of Exercise 10.8.3 needs further normalization to 5 NF because
  50. The rows of a relation
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!