Quiz
Chapter 4 (Multiple Choice CIS 3365)
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (40)
11. The ERD represents the ____ database as viewed by the end user.
- AA) condensed
- BB) physical
- CC) logical
- DD) conceptual
22. Some ____ database modeling concepts can be expressed only using the Chen notation.
- AA) developmental
- BB) conceptual
- CC) actual
- DD) specific
33. Attributes may share a ____.
- AA) name
- BB) domain
- CC) location
- DD) table
44. The set of possible values for an attribute is a ____.
- AA) domain
- BB) range
- CC) set
- DD) key
55. In an ER diagram, primary keys are indicated by ____.
- AA) bolding
- BB) italics
- CC) underlining
- DD) a special font
66. Ideally, an entity identifier is composed of ____ attribute(s).
- AA) zero
- BB) one
- CC) two
- DD) six
77. A ____ identifier is composed of more than one attribute.
- AA) primary
- BB) foreign
- CC) composite
- DD) domain
88. The ____ attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)
- AA) CRS_CODE
- BB) CLASS_SECTION
- CC) CRS_CODE and CLASS_SECTION
- DD) There is no primary key
99. A ____ attribute can be further subdivided to yield additional attributes.
- AA) composite
- BB) simple
- CC) single-valued
- DD) multivalued
1010. A ____ attribute is one that cannot be subdivided.
- AA) composite
- BB) simple
- CC) single-valued
- DD) multivalued
1111. A ____ attribute can have only one value.
- AA) composite
- BB) simple
- CC) single-valued
- DD) multivalued
1212. ____ attributes can have many values.
- AA) composite
- BB) simple
- CC) single-valued
- DD) multivalued
1313. Some attributes are classified as ____.
- AA) simple
- BB) complex
- CC) defined
- DD) grouped
1414. The ____ type of attribute cannot be created in a DBMS.
- AA) derived
- BB) multivalued
- CC) simple
- DD) composite
1515. A ____ should be a derived attribute.
- AA) person's name
- BB) person's age
- CC) person's social security number
- DD) person's phone number
1616. A derived attribute ____.
- AA) must be stored physically within the database
- BB) need not be physically stored within the database
- CC) has many values
- DD) must be based on the value of three or more attributes
1717. A derived attribute is indicated in the Chen model by a ____.
- AA) single line
- BB) dashed line
- CC) circle
- DD) double line
1818. A relationship is an association between ____.
- AA) objects
- BB) entities
- CC) databases
- DD) fields
1919. Knowing the ____ number of entity occurrences is very helpful at the application software level.
- AA) maximum
- BB) minimum
- CC) approximate
- DD) maximum and minimum
2020. In the ERD, cardinality is indicated using the ____ notation.
- AA) (max,min)
- BB) (min, max)
- CC) [min ... max]
- DD) {min\max}
2121. Another word for existence-independent is ____.
- AA) weak
- BB) alone
- CC) unary
- DD) strong
2222. An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
- AA) existence
- BB) relationship
- CC) business
- DD) weak
2323. If an entity can exist apart from one or more related entities, it is said to be ____-independent.
- AA) existence
- BB) relationship
- CC) business
- DD) weak
2424. When the PK of one entity does not contain the PK of a related entity, the relationship is ____.
- AA) missing
- BB) weak
- CC) strong
- DD) Neutral
2525. A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
- AA) strong
- BB) weak
- CC) business
- DD) relationship
2626. The term “____”is used to label any condition in which one or more optional relationships exist.
- AA) participation
- BB) optionality
- CC) cardinality
- DD connectivity
2727. The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity
- AA) mandatory
- BB) optional
- CC) multivalued
- DD) single-valued
2828. The Crow’s foot symbol with two parallel lines indicates ____ cardinality.
- AA) (0,N)
- BB) (1,N)
- CC) (1,1)
- DD) (0,1)
2929. A ____ relationship exists when an association is maintained within a single entity.
- AA) unary
- BB) ternary
- CC) binary
- DD) weak
3030. A ____ relationship exists when two entities are associated.
- AA) unary
- BB) binary
- CC) ternary
- DD) weak
3131. A ____ relationship exists when three entities are associated.
- AA) unary
- BB) binary
- CC) ternary
- DD) weak
3232. ____ relationships are most common.
- AA) unary
- BB) binary
- CC) ternary
- DD) higher-degree
3333. If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship.
- AA) self
- BB) self-referring
- CC) looping
- DD) recursive
3434. A(n) ____ entity is composed of the primary keys of each of the entities to be connected.
- AA) associative
- BB) recursive
- CC) unary
- DD) binary
3535. The associative entity is also known as a ____ entity.
- AA) unary
- BB) weak
- CC) strong
- DD) composite
3636. The following step occurs first in the process of building an ERD: ____.
- AA) Develop the initial ERD
- BB) Create a detailed narrative of the organization's description of operations
- CC) Identify the attributes and primary keys that adequately describe the entities.
- DD) Identify the business rules based on the description of operations.
3737. If Tiny College had some departments that were classified as “research only,” they would not offer courses; therefore, the COURSE entity would be ____ to the DEPARTMENT entity
- AA) existence-dependent
- BB) independent
- CC) weak
- DD) optional
3838. The M:N relationship between STUDENT and CLASS must be divided into two 1:M relationships through the use of the ENROLL entity; the ENROLL entity is ____.
- AA) weak
- BB) strong
- CC) optional
- DD) mandatory
3939. If the focus is on data-retrieval speed, you might also be forced to include ____ attributes in the design, which would not ordinarily be done.
- AA) multivalued
- BB) composite
- CC) weak
- DD) derived
4040. Complex ____ requirements may dictate data transformations, and they may
expand the number of entities and attributes within the design.- AA) information
- BB) entity
- CC) design
- DD) processing
Information
- Description
- asdf Quiz on Chapter 4 (Multiple Choice CIS 3365), created by . . on 08/09/2016.
- Author
- . .
- Language
- English
- Views
- 754
- Tags
- Rating
- 5.0 out of 5 · 1 rating Rate this quiz