Q&A Hero

Design

Q: The third step in assessing table structure is to check the validity of presumed referential integrity constraints.
Q: When examining data values as a part of assessing table structure, there is no need to try to determine foreign keys.
Q: When examining data values as a part of assessing table structure, there is no need to try to determine candidate keys other than the table's primary key.
Q: When examining data values as a part of assessing table structure, you should try to determine the table's primary key.
Q: When examining data values as a part of assessing table structure, you should try to determine multivalued dependencies.
Q: When examining data values as a part of assessing table structure, you should try to determine functional dependencies.
Q: The second step in assessing table structure is to examine data values and determine dependencies and keys.
Q: When examining data values as a part of assessing table structure, you should try to determine three types of keys: the primary key, any candidate keys, and any foreign keys.
Q: When examining data values as a part of assessing table structure, you should try to determine two types of dependencies: functional dependencies and multivalued dependencies.
Q: To limit the number of rows retrieved from a table, use the SQL TOP keyword.
Q: To determine the number and type of columns in a table, use the SQL construct COUNT(*).
Q: To count the number of rows in a table, use the SQL construct COUNT(ROWS).
Q: The first step in assessing table structure is to count rows and examine columns.
Q: When you are given a set of tables and asked to create a database to store their data, the first step is to assess the tables' structure and content.
Q: Every time we break up a relation during the normalization process, we may have to create a referential integrity constraint.
Q: A defining requirement for Boyce-Codd Normal Form (BCNF) is that every candidate key must be a determinant.
Q: A relation is in Boyce-Codd Normal Form (BCNF) if and only if it is in 3NF and every determinant is a candidate key.
Q: Candidate keys are called interlocking candidate keys when they share one or more attributes.
Q: An attribute is considered to be a non-key attribute when it is a non-prime attribute, which means that the attribute is not contained in any candidate key.
Q: The condition that a non-key attribute determines another non-key attribute is known as transitive dependency.
Q: A relation is in 3NF if and only if it is in 2NF and there are no non-key attributes determined by another non-key attribute.
Q: A relation is in 2NF if and only if it is in 1NF and all non-key attributes are determined by the entire primary key.
Q: Any table that meets the definition of a relation is in 2NF.
Q: Any table that meets the definition of a relation is said to be in first normal form (1NF).
Q: Relations are classified into normal forms based on the types of modification anomalies that they are vulnerable to.
Q: A deletion anomaly exists when deleting data about one entity results in the loss of data about another entity.
Q: Undesirable consequences of changing the data in a relation are called modification anomalies.
Q: If a table meets the minimum definition of a relation, it has an effective or appropriate structure.
Q: A referential integrity constraint limits the values of a foreign key.
Q: A constraint that requires an instance of an entity to exist in one relation before it can be referenced in another relation is called an insertion anomaly.
Q: A referential integrity constraint is used to make sure the values of a foreign key match a valid value of a primary key.
Q: A foreign key is one or more columns in one relation that also is the primary key in another table.
Q: Surrogate keys are normally not shown on forms or reports.
Q: Surrogate keys usually slow performance.
Q: A surrogate key is an artificial column that is added to a relation to be its primary key.
Q: A primary key is a candidate key that has been selected to uniquely identify rows in a relation.
Q: A relation can have only one candidate key.
Q: A candidate key is one of a group of keys that may serve as the primary key in a relation.
Q: It is possible to have a relation that does not have a key.
Q: A key can be composed of a group of attributes taken together.
Q: A combination key is a group of attributes that uniquely identifies a row.
Q: A row can be uniquely identified by a key.
Q: A key is a combination of one or more columns that is used to identify particular rows in a relation.
Q: A determinant of a functional dependency may or may not be unique in a relation.
Q: Given the functional dependency A → B, then it is necessarily true that B → A.
Q: Given the functional dependency (A, B) → C, then it is true that A → C and B → C.
Q: Given the functional dependency A → (B, C), then it is true that A → B and A → C.
Q: Given the functional dependency (A, B) → C, the attributes (A, B) are referred to as a composite determinant.
Q: Functional dependencies can involve groups of attributes.
Q: In the functional dependency shown as A → B, B is the determinant.
Q: The functional dependency noted as A → B means that the value of A can be determined from the value of B.
Q: Attribute Y is functionally dependent on attribute X if the value of attribute X determines the value of Y.
Q: In functional dependencies, the attribute whose value is known or given is referred to as the determinant.
Q: If by knowing the value of A we can find the value of B, then we would say that B is functionally dependent on A.
Q: A functional dependency is a relationship between attributes such that if we know the value of one attribute, we can determine the value of the other attribute.
Q: A tuple is a group of one or more columns that uniquely identifies a row.
Q: The columns of a relation are sometimes called tuples.
Q: In relational terms as defined by E.F. Codd, a column is called an attribute.
Q: In relational terms as defined by E.F. Codd, a row is called a tuple.
Q: A relation is a table composed of columns and rows.
Q: A characteristic of a relation is that the rows of a relation may hold identical values.
Q: A characteristic of a relation is that the cells of the relation hold a single value.
Q: A relation is a table that has special restrictions on it.
Q: All relations are tables, but not all tables are relations.
Q: Explain the steps in the process of putting a relation straight into Boyce-Codd Normal Form (BCNF).
Q: Explain the essence of normalization that is implemented through the use of normal forms.
Q: Explain the concept of a surrogate key.
Q: Explain the concept of a foreign key.
Q: Explain the relationships among primary keys and functional dependencies.
Q: Briefly describe the various tasks of the primary key.
Q: Distinguish between the primary key and a candidate key.
Q: Explain the terms relation, tuple, and attribute.
Q: Describe the requirements that a table must meet to qualify as a relation.
Q: What is a functional dependency? Give an example not used in the text.
Q: In general, each relation should have ________. A) one and only one theme B) one or more themes C) exactly two themes D) one or two themes
Q: A relation is in domain/key normal form if ________. A) every key of the relation is a logical consequence of the definition of constraints and determinants B) every key of the relation is a logical consequence of the definition of constraints and domains C) every constraint on the relation is a logical consequence of the definition of keys and determinants D) every constraint on the relation is a logical consequence of the definition of keys and domains
Q: A relation is in fourth normal form if it is in BCNF and it has no ________. A) transitive dependencies B) multivalued dependencies C) partial dependencies D) deletion dependencies
Q: If a relation is in BCNF, and each multivalued dependency has been moved to a relation of its own, then the first relation is in ________. A) Third Normal Form B) Boyce-Codd Normal Form C) Fourth Normal Form D) Domain/key normal form
Q: If a table is designed so that every determinant is a candidate key, then that relation is in ________. A) First Normal Form B) Second Normal Form C) Third Normal Form D) Boyce-Codd Normal Form
Q: A relation is in Boyce-Codd normal form (BCNF) if and only if it is in 3NF and ________. A) all non-key attributes are determined by the entire primary key B) there are no non-key attributes determined by another non-key attribute C) every attribute is a candidate key D) every determinant is a candidate key
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