Untitled Flashcards Set

Question,Answer

"Entities in the ERM corresponds to a table—not to a row.","True"

"Relational Schema are the organization of a relational database as described by the database administrator.","True"

"Composite Identifiers in ER modeling is a key composed of less than one attribute.","False"

"Simple Attribute is an attribute that cannot be subdivided into meaningful components.","True"

"Single-Valued Attributes is an attribute that can have only one value.","True"

"Derived Attributes is an attribute that physically exists within the entity and is derived via an algorithm.","False"

"The entities that participate in a relationship are also known as participants, and each relationship is identified by a name that describes the relationship.","True"

"The term connectivity is used to describe the relationship classification.","True"

"Cardinality is a property that assigns no specific value to connectivity and expresses the range of allowed entity occurrences associated with a single occurrence of the related entity.","False"

"Existence-dependent is a property of an entity whose existence depends on one or more other entities.","True"

"Existence-independent is a property of an entity that can exist apart from one or more related entities.","True"

"Weak (Identifying) Relationships is a relationship in which the primary key of the related entity does not contain a primary key component of the parent entity.","False"

"Strong (Identifying) Relationships is a relationship that occurs when two entities are existence dependent.","True"

"Optional Participation in ER modeling is a condition in which one entity occurrence does not require a corresponding entity occurrence in a particular relationship.","True"

"A relationship degree indicates the number of attributes and participants associated with a relationship.","False"

"Unary Relationship is an ER term used to describe an association within an entity.","True"

"Binary Relationship is an ER term for an association (relationship) between two entities.","True"

"Ternary Relationship is an ER term used to describe an association (relationship) between two entities.","False"

"Recursive Relationships is a relationship found within a single entity type.","True"

"The ER Model uses associative entity to represent an M:N relationship between two or more entities.","True"

"The process of database design is linear rather than an iterative or sequential process. The verb linear means “to do again or repeatedly.”","False"

"The ER Model uses associative entity also called a composite or bridge entity, is in a 1:M relationship with the parent entities and is composed of the primary key attributes of each parent entity.","True"

"Design standards mean that the database design must conform to design standards. Such standards guide you in developing logical structures that minimize data redundancies, thereby minimizing the likelihood that destructive data anomalies will occur.","True"

"Processing speed in many organizations, particularly those that generate large numbers of transactions, low processing speeds are often a top priority in database design. Low processing speed means minimal access time, which may be achieved by minimizing the number and complexity of logically desirable relationships.","False"

"In SQL, column aliases allow you to assign a temporary name to a column or expression within a query result set.","True"

"Computed columns in SQL are expressions that calculate values dynamically based on other columns or constants in the query.","True"

"The DISTINCT keyword is used in SQL to return non-unique values from a column or a combination of columns, eliminating duplicates.","False"

"A NATURAL JOIN is a type of join that automatically combines tables based on columns with the same name and compatible data types in both tables.","True"

"The JOIN USING syntax is used when you want to specify the exact column(s) to join on, particularly when the column names in both tables are the same.","True"

"The JOIN ON syntax is used when you want to specify the exact column(s) to join on, particularly when the column names in both tables are the same.","True"