Q&A Hero

Design

Q: Some very specialized applications may require normalization beyond the ____.a. 1NF b. 2NF c. 3NFd. 4NF
Q: Data redundancy produces ____.a. slower lookups b. robust design c. efficient storage used. data integrity problems
Q: A table that displays data redundancies yields ____.a. consistencies b. anomalies c. fewer attributesd. more entities
Q: An attribute that is part of a key is known as a(n) ____ attribute.a. important b. nonprime c. primed. entity
Q: ____ yields better performance.a. Denormalization b. Normalization c. Atomizationd. Compression
Q: From a structural point of view, 2NF is better than ____.a. 1NF b. 3NF c. 4NFd. BCNF
Q: 1NF, 2NF, and 3NF are ____.a. normalization stages b. anomalies c. repeating groupsd. atomic attributes
Q: Normalization works through a series of stages called normal forms. For most purposes in business database design, ____ stages are as high as you need to go in the normalization process.a. twob. three c. fourd. five
Q: Attributes should clearly define participation, connectivity, and document cardinality.
Q: Unnormalized database tables often lead to various data redundancy disasters in production databases.
Q: Normalization purity is easy to sustain in the modern database environment.
Q: The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.
Q: A good relational DBMS excels at managing denormalized relations.
Q: The combination of normalization and ER modeling yields a useful ERD, whose entities may now be translated into appropriate relationship structures.
Q: Normalization represents a micro view of the entities within the ERD.
Q: Normalization should be part of the design process.
Q: Atomic attributes are attributes that can be further subdivided.
Q: A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.
Q: A determinant is any attribute whose value determines other values within a column.
Q: It is possible for a table in 2NF to exhibit transitive dependency, where the primary key may rely on one or more nonprime attributes to functionally determine other nonprime attributes.
Q: A table is in 2NF if it is in 1NF and it includes no partial dependencies.
Q: Because a partial dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF.
Q: Converting a database format from 1NF to 2NF is a complex process.
Q: With partial dependencies, data redundancies occur because every row entry requires duplication of data.
Q: All relational tables satisfy the 1NF requirements.
Q: Dependencies that are based on only a part of a composite primary key are called transitive dependencies.
Q: Dependency diagrams are very helpful in getting a bird's-eye view of all the relationships among a table's attributes.
Q: Repeating groups must be eliminated by making sure that each row defines a single entity.
Q: Relational models view the data as part of a table or collection of tables in which all key values must be identified.
Q: A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.
Q: A table is in BCNF if every determinant in the table is a foreign key.
Q: A table is in BCNF if every determinant in the table is a candidate key.
Q: Normalization is a very important database design ingredient and the highest level is always the most desirable.
Q: Denormalization produces a lower normal form.
Q: In order to meet performance requirements, you may have to denormalize portions of the database design.
Q: Normalization is a process that is used for changing attributes to entities.
Q: Normalization produces a lower normal form.
Q: Normalization works through a series of stages called normal forms.
Q: Explain how database designers design and normalize databases.
Q: Explain the Boyce-Codd normal form (BCNF). How is it related to other normal forms?
Q: What steps are involved in the conversion to third normal form?
Q: Describe a dependency diagram and explain its purpose.
Q: Explain normalization and its different forms.
Q: According to the Data-Modeling Checklist, ____________________ should be nouns that are familiar to business and should be short and meaningful, and should document abbreviations, synonyms, and aliases for each entity.
Q: The combination of ____________________ and ER modeling yields a useful ERD, whose entities may now be translated into appropriate table structures.
Q: The ____________________ provides the big picture, or macro view, of an organization's data requirements and operations.
Q: In ____________________, no row may contain two or more multivalued facts about an entity.
Q: When a nonkey attribute is the determinant of a key attribute the table is in 3NF but not ____________________.
Q: It becomes difficult to create a suitable ____________________ key when the related table uses a composite primary key.
Q: In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of ____________________ keys.
Q: ____________________ refers to the level of detail represented by the values stored in a table's row.
Q: An attribute that cannot be further divided is said to display ____________________.
Q: Any attribute whose value determines other values within a row is called a(n) ____________________.
Q: Because a partial dependency can exist only if a table's primary key is composed of several attributes, a table whose ____________________ key consists of only a single attribute is automatically in 2NF if it is in 1NF.
Q: Data redundancies occur from ____________________ of data on every row entry.
Q: All relational tables satisfy the ____________________ requirements.
Q: A diagram that depicts all dependencies found within a given table structure is known as a(n) ____________________.
Q: The problem with transitive dependencies is that they still yield data ____________________.
Q: Dependencies can be identified with the help of a dependency ____________________.
Q: A dependency based on only a part of a composite primary key is called a(n) ____________________.
Q: Any attribute that is at least part of a key is known as a(n) ____________________.
Q: A relational table must not contain ____________________ groups.
Q: ____________________ is a process to help reduce the likelihood of data anomalies.
Q: A(n) ____________________ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.
Q: In order to meet ____________________ requirements, you may have to denormalize some portion of the database.
Q: The price paid for increased performance through denormalization is a larger amount of ____________________.
Q: Normalization works through a series of stages called ____________________ forms.
Q: If database tables are treated as though they were files in a file system, the ____________________ never has a chance to demonstrate its superior data-handling capabilities.
Q: ____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.a. Normalized b. Data warehouse c. Temporaryd. Report
Q: The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____. a. conversion from 1NF to 2NF b. conversion from 2NF to 3NF c. compromises that include denormalization d. conversion from 3NF to 4NF
Q: An example of denormalization is using a ____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that is stored in the table as rows.a. transitive b. 3NF c. componentd. temporary
Q: Normalization represents a micro view of the ____ within the ERD.a. entities b. attributes c. relationshipsd. forms
Q: When designing a database, you should ____. a. make sure entities are in normal form before table structures are created b. create table structures then normalize the database c. only normalize the database when performance problems occur d. consider more important issues such as performance before normalizing
Q: A table is in 4NF if it is in 3NF and ____. a. all attributes must be dependent on the primary key, and must be dependent on each other b. all attributes are unrelated c. has no multivalued dependencies d. no column contains the same values
Q: A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.a. 1NF b. 2NF c. 3NFd. 4NF
Q: Most designers consider the BCNF as a special case of the ____.a. 1NF b. 2NF c. 3NFd. 4NF
Q: BCNF can be violated only if the table contains more than one ____ key.a. primary b. candidate c. foreignd. secondary
Q: A table where every determinant is a candidate key is said to be in ____.a. BCNF b. 2NF c. 3NFd. 4NF
Q: To generate a surrogate key, Microsoft Access uses a(n) ____ data type.a. surrogate b. sequence c. AutoNumberd. identity
Q: For most business transactional databases, we should normalize relations into ____.a. 1NF b. 2NF c. 3NFd. 6NF
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