Please answer the following questions below with True/False: T F Three main type
ID: 3839547 • Letter: P
Question
Please answer the following questions below with True/False:
T F Three main types of relationships that can exist between entities are a one-to-one relationship, abbreviated 1:1; a one-to-many relationship, abbreviated 1:M; and a many-to-many relationship, abbreviated M:N. T F In an M: N relationship, the two entities are linked by an event or transaction called an associative entity, which has its own set of attributes and characteristics. T F As an analyst, you must understand cardinality in order to create a data design that accurately reflects all relationships among system entities. T F The Unified Modeling Language (UML) is a widely used method of visualizing and documenting software systems design. T F A table design specifies the fields and identifies the primary key in a particular table or file. T F The three normal forms constitute a progression in which the first normal form represents the best design. T F A repeating group is a set of one or more fields that can occur only once in a single record, with each occurrence having the same value. A table design that does not contain repeating groups is called unnormalized. A table is in first normal form (1NF) if it contains a repeating group. T F Field X is functionally dependent on field Y if the value of field X depends on the value of field Y. T F A table design is in second normal form (2NF) if it is in 1NF and if all fields that are not part of the primary key are functionally independent of part of the primary key.Explanation / Answer
22. True.
23. True.
24. True
25. True
26. True
27. False
28. True
29. False
30. False
31. True
32. False