Chapter 6 (True/False)

Question 1

1. Normalization works through a series of stages called normal forms.

Accepted Answer

true

Question 2

2. Normalization produces a lower normal form.

Accepted Answer

false

Answer

true

Question 3

3. Normalization is a process that is used for changing attributes to entities.

Accepted Answer

false

Answer

true

Question 4

4. In order to meet performance requirements, you may have to denormalize portions of the database design.

Accepted Answer

true

Question 5

5. Denormalization produces a lower normal form.

Accepted Answer

true

Question 6

6. Normalization is a very important database design ingredient and the highest level is always the most desirable.

Accepted Answer

false

Answer

true

Question 7

7. A table is in BCNF if every determinant in the table is a candidate key.

Accepted Answer

true

Question 8

8. A table is in BCNF if every determinant in the table is a foreign key

Accepted Answer

false

Answer

true

Question 9

9. A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.

Accepted Answer

true

Question 10

10. Relational models view the data as part of a table or collection of tables in which all key values must be identified.

Accepted Answer

true

Question 11

11. Repeating groups must be eliminated by making sure that each row defines a single entity

Accepted Answer

true

Question 12

12. Dependency diagrams are very helpful in getting a bird’s-eye view of all the relationships among a table’s attributes.

Accepted Answer

true

Question 13

13. Dependencies that are based on only a part of a composite primary key are called transitive dependencies.

Accepted Answer

false

Answer

true

Question 14

14. All relational tables satisfy the 1NF requirements.

Accepted Answer

true

Question 15

15. With partial dependencies, data redundancies occur because every row entry requires duplication of data.

Accepted Answer

true

Question 16

16. Converting a database format from 1NF to 2NF is a complex process.

Accepted Answer

false

Answer

true

Question 17

17. Because a partial dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF.

Accepted Answer

true

Question 18

18. A table is in 2NF if it is in 1NF and it includes no partial dependencies.

Accepted Answer

true

Question 19

19. It is possible for a table in 2NF to exhibit transitive dependency, where one or more nonprime attributes functionally determine other nonprime attributes.

Accepted Answer

true

Question 20

20. A determinant is any attribute whose value determines other values within a column.

Accepted Answer

false

Answer

true

Question 21

21. A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.

Accepted Answer

false

Answer

true

Question 22

22. Atomic attributes are attributes that can be further divided

Accepted Answer

false

Answer

true

Question 23

23. Normalization should be part of the design process.

Accepted Answer

true

Question 24

24. Normalization represents a micro view of the entities within the ERD.

Accepted Answer

true

Question 25

25. The combination of normalization and ER modeling yields a useful ERD, whose entities may now be translated into appropriate relationship structures.

Accepted Answer

false

Answer

true

Question 26

26. A good relational DBMS excels at managing denormalized relations.

Accepted Answer

false

Answer

true

Question 27

27. The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.

Accepted Answer

true

Question 28

28. Normalization purity is easy to sustain in the modern database environment.

Accepted Answer

false

Answer

true

Question 29

29. Unnormalized database tables often lead to various data redundancy disasters in production databases.

Accepted Answer

true

Question 30

30. Attributes should clearly define participation, connectivity, and document cardinality.

Accepted Answer

false

Answer

true

Question 31

31. Repeating groups must be eliminated by making sure that each column defines a single entity

Accepted Answer

false

Answer

true

Question 32

32. Dependencies can be identified with the help of the dependency diagram.

Accepted Answer

true

Question 33

33. Data redundancies are caused by the fact that every row entry requires duplication of data

Accepted Answer

true

Nächster

Chapter 6 (True/False)

Beschreibung

Zusammenfassung der Ressource

Frage 1

Frage 2

Frage 3

Frage 4

Frage 5

Frage 6

Frage 7

Frage 8

Frage 9

Frage 10

Frage 11

Frage 12

Frage 13

Frage 14

Frage 15

Frage 16

Frage 17

Frage 18

Frage 19

Frage 20

Frage 21

Frage 22

Frage 23

Frage 24

Frage 25

Frage 26

Frage 27

Frage 28

Frage 29

Frage 30

Frage 31

Frage 32

Frage 33

ähnlicher Inhalt

	Erstellt von . . vor fast 8 Jahre