A Composite Attribute Can Not Be Subdivided
| A ____ attribute can be further subdivided to yield additional attributes. | Composite |
| A ____ attribute can have only one value. | Single-Valued |
| A ____ attribute is one that cannot be subdivided. | Simple |
| A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship. | Weak |
| A ____ identifier is composed of more than one attribute. | Composite |
| A ____ relationship exists when an association is maintained within a single entity. | Unary |
| A ____ relationship exists when three entities are associated. | Ternary |
| A ____ relationship exists when two entities are associated. | Binary |
| A ____ should be a derived attribute. | Person's Age |
| A derived attribute ____. | Need not be physically stored within the database |
| A derived attribute is indicated in the Chen model by a ____. | Dashed Line |
| A relationship is an association between ____ | Entities |
| A(n) ____ entity is composed of the primary keys of each of the entities to be connected. | Associative |
| A(n) ____ might be represented with a single-valued attribute. | Person's Social Security Number |
| An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence. | Existence |
| Another word for existence-independent is ____. | Strong |
| Attributes may share a ____. | Domain |
| Complex ____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design. | Information |
| Ideally, an entity identifier is composed of ____ attribute(s). | One |
| If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship. | Recursive |
| If an entity can exist apart from one or more related entities, it is said to be ____-independent. | Existence |
| In an ER diagram, primary keys are indicated by ____. | Underlining |
| In the ERD, cardinality is indicated using the ____ notation. | Min,Max |
| Knowing the ____ number of entity occurrences is very helpful at the application software level. | Maximum and Minimum |
| Making sure all ____ are identified is a very important part of a database designer's job. | Business Rules |
| Some ____ database modeling concepts can be expressed only using the Chen notation. | Conceptual |
| Some attributes are classified as ____. | Simple |
| The Crow's foot symbol with two parallel lines indicates ____ cardinality. | 1,1 |
| The ERD represents the ____ database as viewed by the end user. | Conceptual |
| The ____ attribute(s) make up the primary key in the table definition: | CRS_CODE and CLASS_SECTION |
| The ____ type of attribute cannot be created in a DBMS. | Multivalued |
| The associative entity is also known as a ____ entity. | Composite |
| The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity. | Mandatory |
| The set of possible values for an attribute is a ____. | Domain |
| The step, ____, occurs first in the process of building an ERD. | Create a detailed narrative of the organization's description of operations |
| The term "____" is used to label any condition in which one or more optional relationships exist. | Optionality |
| When the PK of one entity does not contain the PK of a related entity, the relationship is ____. | Weak |
| ____ attributes can have many values. | Multivalued |
| ____ might be represented with a multivalued attribute. | Household Phone Numbers |
| ____ relationships are most common. | Binary |
A Composite Attribute Can Not Be Subdivided
Source: https://subjecto.com/flashcards/it-quiz-4/