Find study materials for any course. Check these out:
Browse by school
Make your own
To login with Google, please enable popups
To login with Google, please enable popups
Don’t have an account?
To signup with Google, please enable popups
To signup with Google, please enable popups
Sign up withor
________ are underlined in an entity relationship (ER) diagram.
Which of the following attributes makes up the primary key in the table definition CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)?
Which of the following types of attribute should not be implemented in an RDBMS?
The preferred way to represent multivalued attributes in a DBMS is to ________.
Which of the following is an example of a derived attribute?
Connectivities and cardinalities are established by concise statements known as ________.
A(n) ________ is also known as a non-identifying relationship.
The concept of ________ is based on how the primary key of a related entity is defined.
an associative entity is identified as a strong relationship
To maximize information generation, database should ________.
The ________ adds support for entity supertypes, subtypes, and entity clustering.
The extended entity relationship model is also known as ________.
In an organization's data model, employees are grouped to ________.
In an aviation company's data model, a PILOT entity is a(n) ________ of the EMPLOYEE entity.
In modeling terms, the ________ contains common characteristics.
Entity supertypes and subtypes are organized in a(n) ________.
An entity subtype ________.
A specialization hierarchy reflects the ________.
The specialization hierarchy provides a means to ________.
Every subtype can ________.
The extended entity relationship model (EERM) supports ________ where a subtype can have multiple parents (supertypes).
In a specialization hierarchy constraint scenario with partial disjoint constraint, ________.
The property of ________ enables an entity subtype to gain the attributes and relationships of the supertype.
Which of the following is true of entity supertypes and subtypes?
One important inheritance characteristic is that all entity subtypes inherit their ________ from their supertype.
At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a ________.
In specialization hierarchies with multiple levels of supertype/subtypes, ________.
A(n) ________ is the attribute in the supertype entity that determines to which subtype each supertype occurrence is related.
Which of the following is the default comparison condition for the subtype discriminator attribute?
In MS Visio, the completeness constraint is based on the ________.
Subtypes that contain a unique subset of the supertype entity set are known as ________.
Subtypes that contain nonunique subsets of the supertype entity set are known as ________.
The implementation of disjoint subtypes is based on the value of the ________ attribute in the supertype.
The ________ specifies whether each entity supertype occurrence must also be a member of at least one subtype.
________ is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.
________ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.
A(n) ________ is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
The purpose of an entity cluster is to ________.
In an entity relationship diagram (ERD) that uses entity clusters, it is common to ________.
Arguably, the most important characteristic of an entity is its ________.
A primary key's function is to ________.
A ________ refers to a real-world, generally accepted identifier used to distinguish real-world objects.
Which of the following is the most preferred data type for a primary key?
________ are used to implement relationships among entities.
Which of the following types of primary key is useful to represent M:N relationships?
A weak entity in a strong identifying relationship with a parent entity is normally used to represent ________.
A ________ is especially helpful when there is no natural key.
When defining a 1:1 relationship where one side of the relationship is mandatory and one is optional, ________.
________ refer to data whose values change in the future and for which you must keep a history of the data changes.
A(n) ________ occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world.
A(n) ________ occurs when you have one entity in two 1:M relationships to other entities, thus producing an association among the other entities that is not expressed in the model.
________ occur when there are multiple relationship paths between related entities.
In a specialization hierarchy constraint scenario with partial overlapping constraint, ________.
In a specialization hierarchy constraint scenario with total disjoint constraint, ________.
One of the characteristics of a primary key is that ________.
A ________ is used as an identifier for weak entities in a strong identifying relationship with a parent entity.
A ________ has no meaning in the user's environment.
In an existence-dependent relationship, the primary key of the dependent entity is a ________.
When defining a 1:1 relationship where both sides of the relationship are mandatory, ________.
Which of the following is an example of time-variant data?
For most business database design purposes, ________ is as high as you need to go in the normalization process.
A table that displays data redundancies yields ________.
The normalization process involves assigning ________ to tables based on the concept of determination.
From a structural point of view, second normal form (2NF) is better than ________.
________ yields increased performance in a database system.
Data redundancy may produce ________ during database design.
In a normalized database, which of the following is represented by each table?
Identification of the ________ of a table will let you know where you are in the normalization process.
A table that has all key attributes defined, has no repeating groups, and has an identified primary key is said to be in ________.
The ________ model views data as part of a table or collection of tables in which all key values must be identified.
________ attributes are usually calculated from other attributes in a table.
The ________ key is a candidate key used to identify rows in the table.
A table is in fourth normal form (4NF) if ________.
A table that is in 1NF and includes no partial dependencies is said to be in ________.
A table that is in second normal form (2NF) and contains no transitive dependencies is said to be in ________.
A ________ dependency exists when there are functional dependencies such that X → Y, Y → Z, and X is the primary key.
All dependencies in a table structure can be depicted with the help of a dependency ________.
Dependencies based on only a section of a composite primary key are called ________ dependencies.
Identify a transitive dependency in this table definition:
1NF (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS)d. JOB_CLASS → CHG_HOURS
An attribute that is part of at least one relation/candidate key is known as a(n) ________ attribute.
All relational tables satisfy the ________ requirements.
A(n) ________ attribute is not part of any key.
A candidate key is a minimal (irreducible) ________.
Given the following table definition, how many tables would be produced by the conversion to 2NF?
1NF (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, ASSIGN_HOURS)
A 1NF table whose primary key consists of only a single attribute is automatically in ________.
________ is not likely to be encountered in a business environment and is mainly of theoretical interest.
A table that is not in ________ may be split into new tables until all of the tables meet the ________ requirements.
A ________ group derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.
A ________ key is an artificial primary key introduced by a designer with the purpose of simplifying the assignment of primary keys to tables.
________ keys are usually numeric, they are often automatically generated by the DBMS, they are free of semantic content, and they are usually hidden from the end users.
A table with ________ groups fails to meet even the lowest normal form requirements.
Which of the following would be the best name for a column representing the charges per hour in a table named JOB?
In an ideal (database design) world, the level of desired granularity is determined at the ________ design or at the requirements gathering phase.
Storing a(n) ________ attribute in a table makes it easy to write the application software to produce the desired results.
________ refers to the level of detail represented by the values stored in a table's row.
A ________ key in a related table makes it difficult to write search routines.
To implement a surrogate key, MS Access uses an AutoNumber data type, MS SQL Server uses an identity column, and Oracle uses a(n) ________ object.
The existence of multiple ________ keys in a table can also influence the identification of transitive dependencies.
Assume you have the following table:
JOB_CODE JOB_DESCRIPTION JOB_CHG_HOUR
511 Programmer $35.75
512 Programmer $35.75
How might you eliminate the possibility of duplicate entries for JOB_DESCRIPTION?
Most database designers consider Boyce-Codd normal form (BCNF) as a special case of ________.
Tables in ________ will perform suitably in business transactional databases.
A table with every determinant a candidate key is said to be in ________.
When a table contains only one ________ key, the 3NF and the BCNF are equivalent.
Assume the following table definition and dependencies. In which normal form is this table?
________ represents a micro view of entities within an entity relationship diagram (ERD).
The optimal relational database implementation requires that all tables be at least in ________.
Assume the following table definition and dependencies. How many tables would be produced by converting to BCNF?
When designing a database, you should ________.
Conflicts between design efficiency, information requirements, and performance are often resolved through ________.
Sign up for free and study better.
Get started today!