Upgrade to remove ads Show
Only ₩37,125/year
Terms in this set (141)1. Data modeling is a technique for defining business requirements for a database. True 2. Data modeling is a technique for organizing and documenting a system's logical and physical models. False 3. Data modeling is sometimes called database modeling because a data model is eventually implemented as a database. True 4. An entity is something about which the business needs to store data. True 5. An entity is a class of persons, places, objects, events or concepts about which we need to capture and store data. True 7. An entity instance is a single occurrence of an entity. True 8. An entity existence is a single occurrence of an entity. False 9. An attribute is a descriptive property or characteristic of an entity. True 10. A compound attribute is one that actually consists of other attributes that are logically grouped together. True 11. A compound attribute is an attribute that will be expanded into a separate entity. False 12. The data type of an attribute defines what type of data can be stored in that attribute. True 13. Example data types include: numbers, text, memo, date, time, yes/no, Boolean, value set, or image. True 14. The domain of an attribute defines what values an attribute can legitimately take on. True 15. The domain value for an attribute is the value that will be recorded if not specified by the user. False 17. A key is an attribute or group of attributes that assumes a unique value for each entity instance. It is sometimes called the domain of the attribute. False 18. A concatenated key is a group of attributes that uniquely identifies an instance of an entity. True 19. A concatenated key is also known as a composite key or a compound key. True 20. A candidate key must be a single attribute. False 21. A candidate key may be a single attribute or a concatenated key. True 22. A primary key is that candidate key that will most commonly be used to uniquely identify a single entity instance. True 23. An example of domain would be an attribute called grade where the values could only be A, B, C, D, E, or F. True 24. An alternate key is also known as a secondary key. True 25. A subsetting criteria is an attribute or concatenated attribute whose finite values divide all entity instances into useful subsets. True 27. A subsetting criteria is a domain of attributes whose values are limitless to allow for a variety of subsets to be constructed from a database. False 28. A relationship is a natural business association that exists between one or more entities. True 29. A relationship may represent an event that links the entities or merely a physical affinity that exists between the entities. False
30. All data model relationships are unidirectional. False 31. Because all relationships are bi-directional in an entity relationship diagram, cardinality must be defined in both directions for every relationship. True 32. Conceptually cardinality defines the minimum and maximum attributes that can be added to an entity. False 33. The degree of a relationship is the number of entities that participate in the relationship. True 34. The domain of a relationship is the number of entities that participate in the relationship. False 35. A recursive relationship is when only one entity participates in the relationship. True 37. A recursive relationship identifies a relationship that may exist between different instances of the same entity. True 38. A ternary relationship is a relationship among three entities. True 39. The relationship between a student entity and a curriculum entity would be classified as recursive. True 40. In a one-to-many relationship, the parent is the entity on the "one" side. True 41. A foreign key in a child entity always matches the primary key in the parent entity. True 42. A foreign key in the parent entity always matches the primary key in the child entity. False 43. Nonidentifying relationships are those in which each of the participating entities has its own independent primary key. That is, none of the primary key attributes is shared. True 44. Nonidentifying relationships are those in which each of the participating entities has dependent primary keys. False 45. Identifying relationships are those in which the parent entity contributes its primary key to become part of the primary key of the child entity. True 47. A non-specific relationship is one in which many instances of one entity are associated with many instances of another entity. True 48. A many-to-many relationship is one in which many entities are associated with other attributes of a different entity. False 49. Generalization is a technique wherein the attributes that are common to several types of an entity are grouped into their own entity, called a supertype. True 50. Generalization is a technique wherein the domains common to several types of attributes are grouped into their own entity, called an associate entity. False 51. An entity subtype is an entity whose instances inherit some common attributes from an entity supertype and then add other attributes that are unique to an instance of the subtype. True 52. An entity supertype is an entity whose instances inherit some common attributes from an entity subtype and then add other attributes that are unique to an instance of the supertype. False 53. An enterprise data model typically identifies only the most fundamental of entities of the enterprise. True 54. An enterprise data model typically identifies and defines only the most complex entities used by the enterprise. False 55. The data model for a single information system is usually called an application data model. True 57. The requirements analysis results in a logical data model that is developed in stages as follows: (1) context data model; (2) key-based data model; (3) fully attributed data model; and (4) the normalized data model. True 58. The requirements analysis results in a physical data model that is developed in stages as follows: (1) normalized data model; (2) key-based data model; (3) fully attributed data model; and (4) the context data model. False 59. During systems design, the logical data model will be transformed into a physical data model. True 70. Serial codes assign sequentially generated numbers to entity instances. True
71. Alphabetic codes use finite combinations of letters (and possibly numbers) to describe entity instances. True 72. In significant position codes, each digit or group of digits describes a measurable or identifiable characteristic of the entity instance. True 73. Significant position codes are frequently used to code inventory items. True 74. Hierarchical codes provide a top-down interpretation for an entity instance by factoring an item into its group, subgroup and so forth. True 75. If use-case narratives have been written during the requirements analysis phase, analysts can scan them for verbs to discover data attributes and entities. False 77. Many organizations have naming standards and approved abbreviations for data attributes. True 78. A good data model is simple. True 79. A good data model is essentially nonredundant. True 80. In a good data mode, each data attribute describes at most one entity. False 81. A good data model should be flexible and adaptable to future needs. True 82. A good data model is inflexible because it is an accurate representation of the business data requirements. False 83. Data analysis is a process that prepares a logical model for implementation as a redundant, explicit, and finite database through a technique called generalization. False 84. An entity is in first normal form (1NF) if there are no attributes that can have more than one value for a single instance of the entity.
True 85. An entity is in second normal form (2NF) if it is already in 1NF and if the values of all nonprimary key attributes are dependent on the full primary key - not just part of it. True 87. An entity is in third normal form (3NF) if it is already in 2NF and if the values of all nonprimary key attributes are dependent on the full primary key - not just part of it. False 88. An entity is in first normal form (1NF) if the values of its nonprimary key attributes are not dependent on any other nonprimary key attributes. False 89. One form of 3NF makes sure that transitive dependencies exist in each entity. False 90. A data-to-location CRUD matrix is a table in which the rows indicate entities (and possible attributes); the columns indicate locations; and the cells (the intersection of the rows and columns) document level of access where C=create; R=read; U=update; and D=delete or deactivate. True 91. A data-to-location CRUD matrix is a table in which garbage values that fall outside the domain of an attribute are identified and used for data verification. False 92. Many nonspecific relationships can be resolved into two one-to-many relationships using an associative entity. True 93. A generalization hierarchy can be at most two levels deep. False
94. Which of the following is a category of entities? all of these 95. A descriptive property or characteristic of an entity is: an attribute 97. What defines what values an attribute can legitimately take on? domain 98. The value that is recorded in an attribute if a user does not specify one is known as the: default value 99. An attribute or group of attributes that assumes a unique value for each entity instance is a: key 100. Any candidate key that is not selected to become the primary key is called: the alternate key 101. If an employee entity had both an EmployeeID attribute and a Social Security Number attribute, the one that was not used as the primary key would be called a(n): alternate key 102. An attribute or concatenated attribute whose values divide all entity instances into useful subsets is known as: subsetting criteria 103. What defines the minimum and maximum number of occurrences of one entity that may be related to a single occurrence of
the other entity? cardinality 104. The number of entities that can participate in a relationship is known as: the degree of the relationship 105. A ternary relationship is: between three entities 107. When a parent entity contributes its primary key to become part of the primary key of the child entity, the
relationship is known as: identifying 108. A relationship where many instances of one entity can be associated with many instances of another entity is known as: B and C 109. A technique wherein attributes that are common to several types of an entity are grouped into their own entity called a supertype is called: generalization 110. An entity whose instances store attributes that are common to one or more entities is a(n):
supertype 111. The data model for a single information system is usually called: the application data model 112. The problem analysis phase model that includes only entities and relationships but no attributes is known as: the context data model 113. During requirements analysis, what order of model
development is used to arrive at the logical data model? context data model; key-based data model; fully attributed data model; normalized data model 114. Which of the following statements is false?: Data modelers frequently get hung up on unnecessary details associated with the data. 115. A true entity: must have many possible instances 117. A code that assigns sequentially generated numbers to entity instances is known as: a serial code 118. A code that
uses blocks of numbers that are divided into groups that have some business meaning is known as a: block code 119. A code that provides a top-down interpretation for an entity instance is known as: a hierarchical code 120. Which of the following is NOT a guideline for creating a business coding scheme? The full code must result in redundant values for entities. 121. Which of the following is a criteria for making a good data model? All of these. 122. The process that prepares a data model for implementation as a simple, nonredundant, flexible and adaptable database is known as: data analysis 123.
The process that prepares a data model for implementation as a database is known as: both normalization and data analysis 124. Which normal form deals with repeating attributes? 1NF 125. An attribute whose value can be calculated from other attributes is called a(n): derived attribute 127. An entity is in third normal form if: values of nonprimary key attributes are not dependent on any other nonprimary key attributes. 128.
Which normal form deals with transitive dependencies? 3NF 129. When a nonkey attribute is dependent on another nonkey attribute (other than by derivation) is known as: a transitive dependency 130. A table in which rows indicate entities (and possible attributes) and the columns indicate locations, and the cells indicate the document level of access including create, read, update or delete is known as: a data-to-location CRUD matrix 131. An entity relationship diagram: all of these 132. An entity: all of these 133. Every student resides in 0 or 1 dorm. This is an example of:A) domain
cardinality 134. In the relationship between cities and residents, the resident entity would be: the child 135. Which of the following is NOT a source for entity discovery? all of these can be used as sources 137. The three properties of an attribute are: ___________________________, _______________________, and _____________________________. data type, domain and default 138. The ___________________________ defines what values an attribute can legitimately take. domain 139. The ________________________________ is the value that will be recorded for an attribute if a user does not specify one. Default value 140. Every entity must have __________________________. an identifier or a key
141. A group of attributes that uniquely identifies an instance of an entity is called a(n) __________________________________. concatenated key 142. A candidate key is the candidate to become the ___________________________ of instances of an entity. primary key or identifier 143. A(n) _____________________________ is a natural business association that exists between one or more entities. relationship 144. All relationships are implicitly _____________________________. bi-directional 145. ________________________________ defines the minimum and maximum number of occurrences of one entity for a single occurrence of the related entity. Cardinality 146. The ___________________________ of a relationship is the number of entity classes that participate in the relationship. Degree 147. A(n) _______________________________ relationship is where a relationship exists between different instances of the same entity. recursive or unary 148. A(n) _____________________________ relationship is the most common type, where two entities participate. binary 149. A(n) _____________________________ relationship is one between three different entities. ternary 150. A(n) ________________________________ relationship is where many instances of one entity are associated with many instances of another entity. many-to-many or non specific relationship. 151. A(n) ________________________________ entity is an entity that inherits its primary key from more than one other entity (parents). Each part of that concatenated key points to one and only one instance of each of the connecting entities. associative 152. A(n) _______________________________ key is a primary key of one entity that is contributed to (duplicated in) another entity to identify instances of a relationship. foreign 153. ________________________________ relationships are those in which each of the participating entities has its own independent primary key. Nonidentifying 154. _______________________________ is an approach that seeks to discover and exploit the commonalties between entities. Generalization 155. _______________________________ is a technique where the attributes are grouped to form entity supertypes and subtypes. generalization 157. A ___________________________ is an entity whose instances inherit some common attributes from an entity supertype and then add other attributes that are unique to its instance. subtype 158. Another name for an alternate key is ______________________________ key. secondary 159. A _______________________________________ is an attribute (or concatenated attribute) whose finite values divide all entity instances into useful subsets. subsetting criteria or inversion entry 170. ______________________________________ is a technique for organizing and documenting a system's data. Data Modeling 171. Data modeling is sometimes called __________________________________ because a data model is usually implemented as a database. database modeling 172. A(n) _________________________ is something that the business needs to store data. Entity 173. Categories of _______________________ include: persons, places, objects, events or concepts. entities 174. Categories of entities include: ____________, _______________, _______________, _______________________, or ______________________. persons, places, objects, events, or concepts 175. The entity on the "many" side of a one-to-many relationship is called the _____________. child Recommended textbook solutions
Introduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 720 solutions
Engineering Electromagnetics8th EditionJohn Buck, William Hayt 483 solutions Introduction to the Theory of Computation3rd EditionMichael Sipser 389 solutions
C++ Programming: From Problem Analysis to Program Design5th EditionD. S. Malik 708 solutions Sets with similar termsSystem Analysis and Design Ch.840 terms rblack10 Zobel Exam 175 terms alexara3 Database I CJV1 WGU108 terms skelatorrrPLUS CSCI466 Midterm35 terms betsy_manak Sets found in the same folderCS 682 Chapter 9191 terms kuandyk84 CS 682 FINAL without 6809 terms kuandyk84 Systems Analysis & Design Chapter 655 terms txcustomer INSY 3305 Exam 2 T/F Review35 terms Xclusive702 Other sets by this creatorSec+ Final Exam Review440 terms kuandyk84 Security + Terms346 terms kuandyk84 CS 669 DB50 terms kuandyk84 CS 682 essay questions36 terms kuandyk84 Verified questionsCOMPUTER SCIENCE Why is it critical that accumulator variables are properly initialized? Verified answer COMPUTER SCIENCE Draw a picture of the sequence ⟨13, 4, 8, 19, 5, 11⟩ stored as a doubly linked list using the multiple-array representation. Do the same for the single-array representation. Verified answer
COMPUTER SCIENCE A variable that is used to mark the end of a sequence of values is known as a(n) a. accumulator b. counter c. terminator d. sentinel Verified answer COMPUTER SCIENCE Servers can be designed to limit the number of open connections. For example, a server may wish to have only N socket connections at any point in time. As soon as N connections are made, the server will not accept another incoming connection until an existing connection is released. Explain how semaphores can be used by a server to limit the number of concurrent connections. Verified answer Other Quizlet setsAdvance A&P Exam I (Medications/Treatmen…40 terms dgourdet16 Ch 1 Self Assesment41 terms sgarcia951 ANSI 3653 Final Study Guide66 terms leah_anne_jumper GI - Disorders of the Liver90 terms Broadband109 Related questionsQUESTION A table name can be up to 30 characters in length. 8 answers QUESTION
An inline view is a temporary table that only lasts for the duration of the SELECT statement used to create it. 10 answers QUESTION A foreign key that references its own table is called? 11 answers QUESTION finds the IP address for a given hostname 2 answers What type of entity instances store attributes that are common to one or more entity subtypes quizlet?An entity supertype is a generic entity type that is related to one or more entity subtypes, where the entity supertype contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype.
Is an entity whose instances inherit some common attributes from an entity Supertype and then add other attributes that are unique to its instance?An entity subtype is an entity whose instances inherit some common attributes from an entity supertype and then add other attributes that are unique to an instance of the subtype.
What is a data entity called that derives one or more attributes from another entity?Child entity. a data entity that derives one or more attributes from another entity, called the parent. In a one-to-many relationship the child is the entity on the "many" side. Nonidentifying relationship. relationship where each participating entity has its own independent primary key.
Is an entity type that associates the instances of one or more entity types?An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances; also called a gerund. A named property or characteristic, of an entity that is of interest to the organization.
|