Q&A Hero

Design

Q: Failure to understand the distinction between mandatory and optional____________________ in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.
Q: In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) ____________________ on the side of the optional entity.
Q: Participation is ____________________ if one entity occurrence does not requirea corresponding entity occurrence in a particular relationship.
Q: The Chen notation identifies the weak entity by using a double-walled entity ____________________.
Q: A weak entity must be ____________________-dependent.
Q: The Crow's Foot notation depicts the strong relationship with a(n) ____________________ line between the entities.
Q: A(n) ____________________ relationship is also known as an identifying relationship.
Q: Relationship strength depends on how the primary key of the related entity is formulated, while the relationship ____________________ depends on how the business rule is written.
Q: In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity.
Q: When indicating cardinality, the first value represents the ____________________ number of associated entities.
Q: The relationship ____________________ is difficult to establish if you know only one side of the relationship.
Q: Storing ____________________ attributes requires constant maintenance.
Q: A(n) ____________________ attribute need not be physically stored within the database.
Q: Instead of storing a person's age, it is better to store the date of birth and use the difference between that value and the system date as a(n) ____________________ attribute.
Q: A person's social security number would be an example of a(n) ____________________ attribute.
Q: ____________________ are underlined in an ER diagram.
Q: A(n) ____________________ attributeis an attribute that must have a value.
Q: ____________________ are characteristics of entities.
Q: The ____________________ refers to a specific table row as an entity instance.
Q: The ERM forms the basis of a(n) ___________________________________.
Q: The Crow's Foot model is more ____________________-oriented than the Chen model.
Q: Complex ____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.a. informationb. entity c. designd. processing
Q: 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.a. multivalued b. composite c. weakd. derived
Q: 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 ____.a. weak b. strong c. optionald. mandatory
Q: 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.a. existence-dependent b. independent c. weakd. optional
Q: The following step occurs first in the process of building an ERD: ____. a. Develop the initial ERD. b. Create a detailed narrative of the organization's description of operations. c. Identify the attributes and primary keys that adequately describe the entities. d. Identify the business rules based on the description of operations.
Q: The associative entity is also known as a ____ entity.a. unary b. weak c. strongd. composite
Q: A(n) ____ entity is composed of the primary keys of each of the entities to be connected.a. associative b. recursive c. unaryd. binary
Q: If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship.a. self b. self-referring c. loopingd. recursive
Q: ____ relationships are most common.a. Unary b. Binary c. Ternaryd. Higher-degree
Q: A ____ relationship exists when three entities are associated.a. unary b. binary c. ternaryd. weak
Q: A ____ relationship exists when two entities are associated.a. unary b. binary c. ternaryd. weak
Q: A ____ relationship exists when an association is maintained within a single entity.a. unary b. ternary c. binaryd. weak
Q: The Crow's foot symbol with two parallel lines indicates ____ cardinality.a. (0,N) b. (1,N) c. (1,1)d. (0,1)
Q: The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.a. mandatory b. optional c. multivaluedd. single-valued
Q: The term "____"is used to label any condition in which one or more optional relationships exist.a. participation b. optionality c. cardinalityd. connectivity
Q: A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.a. strong b. weak c. businessd. relationship
Q: When the PK of one entity does not contain the PK of a related entity, the relationship is ____.a. missing b. weak c. strongd. neutral
Q: If an entity can exist apart from one or more related entities, it is said to be ____-independent.a. existence b. relationship c. businessd. weak
Q: An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.a. existence b. relationship c. businessd. weak
Q: Another word for existence-independent is ____.a. weak b. alone c. unaryd. strong
Q: In the ERD, cardinality is indicated using the ____ notation.a. (max, min) b. (min, max) c. [min ... max]d. {min|max}
Q: Knowing the ____ number of entity occurrences is very helpful at the application software level.a. maximum b. minimum c. approximated. maximum and minimum
Q: A relationship is an association between ____.a. objects b. entities c. databasesd. fields
Q: A derived attribute is indicated in the Chen model by a ____.a. single line b. dashed line c. circled. double line
Q: A derived attribute ____. a. must be stored physically within the database b. need not be physically stored within the database c. has many values d. must be based on the value of three or more attributes
Q: A ____ should be a derived attribute.a. person's name b. person's age c. person's social security numberd. person's phone number
Q: Although the conceptual model can handle ____ relationhips and multivalued attribues, you should not implement them in the RDBMS.a. 1:1 b. M:N c. 1:Md. 1:N
Q: Some attributes are classified as ____.a. simple b. complex c. definedd. grouped
Q: ____ attributes can have many values.a. Composite b. Simple c. Single-valuedd. Multivalued
Q: A ____ attribute can have only one value.a. composite b. simple c. single-valuedd. multivalued
Q: A ____ attribute is one that cannot be subdivided.a. composite b. simple c. single-valuedd. multivalued
Q: A ____ attribute can be further subdivided to yield additional attributes.a. composite b. simple c. single-valuedd. multivalued
Q: The ____ attribute(s) make up the primary key in the table definition:CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)a. CRS_CODE b. CLASS_SECTION c. CRS_CODE and CLASS_SECTIONd. There is no primary key
Q: A ____ identifier is composed of more than one attribute.a. primary b. foreign c. composited. domain
Q: Ideally, an entity identifier is composed of ____ attribute(s).a. zero b. one c. twod. six
Q: In an ER diagram, primary keys are indicated by ____.a. bolding b. italics c. underliningd. a special font
Q: The set of possible values for an attribute is a ____.a. domain b. range c. setd. key
Q: Attributes may share a ____.a. name b. domain c. locationd. table
Q: Some ____ database modeling concepts can be expressed only using the Chen notation.a. developmental b. conceptual c. actuald. specific
Q: The ERD represents the ____ database as viewed by the end user.a. condensed b. physical c. logicald. conceptual
Q: A recursive relationship is one in which a relationship can exist between occurrences of the same entity set
Q: Relationships operate only in one direction.
Q: The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.
Q: A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.
Q: You should always load data from the 1 side of a 1:M relationship.
Q: A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.
Q: Connectivities and cardinalities are established by business rules.
Q: In Chen notation, there is no way to represent cardinality.
Q: Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
Q: A relationship is identified by a name that describes the relationship.
Q: Derived attributes are stored in a special database table.
Q: The DBMS can easily handle multivalued attributes.
Q: In the Chen model, a multivalued attribute is connected to the owning entity with a double line.
Q: All simple attributes are also single-valued.
Q: All attributes are either simple or composite.
Q: A composite identifier is a primary key composed of more than one attribute.
Q: Ideally, a primary key is composed of several attributes.
Q: In an ER diagram, primary keys are usually bolded.
Q: Attributes cannot share a domain.
1 2 3 … 68

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts