The relation SUPPLIES in Mini-case example 1 of Section 10.10 requires normalization because

  1. Home
  2. Back

Question:
The relation SUPPLIES in Mini-case example 1 of Section 10.10 requires normalization because

1.it has a composite key with three attributes

2.the non-key attributes are dependent on part of composite key

3.the attributes item code and order no of the composite key have multivalued dependency

4.vendor code and order no have a multivalued dependency

Posted Date:-2021-12-09 14:39:24

More MCQS Questions and answers

  1. A concise code is necessarily
  2. A data dictionary is usually developed
  3. A data element in a data dictionary may have
  4. A modulus-17 check will detect single transcription errors in
  5. A pilot can fly three types of planes and a plane can be piloted by any qualified pilot. The pilot-plane type relationship is
  6. A relation is
  7. A relation is said to be in 1NF if
  8. A relationship is
  9. A second Normal Form (2 NF) relation should
  10. A student can take not more than 5 subjects in a semester. The number of students allowed in a subject in a semester is not more than 40. The student - subject relationship is:
  11. A third Normal Form (3 NF) relation should
  12. An appropriate range check for marks in an examination paper whose maximum marks 100 is
  13. An appropriate range check for month field in a date is
  14. An appropriate range check of age of a tenth standard student in a high school is
  15. An E-R modelling for given application leads to
  16. An entity is
  17. BCNF is needed because
  18. Boye Codd Normal Form (BCNF) is needed when
  19. By data independence we mean application programs
  20. By data security in DBMS we mean
  21. By the term "concise code” we understand that the code
  22. By the term "expandable code" we understand that the code
  23. Design of error detecting codes requires good
  24. Errors in codes are detected by
  25. For modulus-11 check digit to detect a single transposition errors the
  26. For modulus-11 check digit to detect single transposition or single transcription error the number of digits in the codes should not exceed
  27. If a field is known to represent an angle of a triangle, radix used to check should be
  28. If a field is known to represent days of a month, radix used to check should be
  29. If an entity appears in only one relationship then it is
  30. In an E-R diagram entities are represented by
  31. In an E-R diagram relationship is represented by
  32. In interactive data input a template is normally used to
  33. In interactive data input terminal commands are normally used to
  34. Modulus-11 check digit for the code 85672 is
  35. Normalization is a process of restructuring a relation to
  36. One entity may be
  37. One of the main objectives of a DBMS is to
  38. Pick the meaningful relationship between entities
  39. Pick the relationship from the following:
  40. Rows of a relation are called
  41. TEACHES-COURSES relation in Mini-case example 2 is in
  42. The abbreviation DBMS stands for
  43. The expansion of E-R diagram is
  44. The number of normal forms which has been proposed and discussed in the book are
  45. The ORDER PLACED FOR relation in Mini-case example 1 has the composite key order no, item code because
  46. The process of normalization
  47. The relation given in Exercise 10.4.4 may be converted to 1 NF relation by
  48. The relation SUPPLIES in Mini-case example 1 of Section 10.10 requires normalization because
  49. The sequence followed in designing a DBMS are
  50. When a logical model is mapped into a physical storage such as a disk store the resultant data model is known as
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!