Chapter PI3: Fundamentals of Relational Databases Operations

The flashcards below were created by user hunter82 on FreezingBlue Flashcards.

  1. The main goal of normalization is to...
    Eliminate data redundancy.
  2. What is done to a database in the normalization process?
    Tables with redundant data are linked.
  3. Which database operation is required to combine two or more tables in a database?
  4. A join operation in databases is most similar to...
    Combining groups of numbers into a new group.
  5. Which two terms are synonymous when speaking about a database?
    Attributes, identifiers
  6. How is a unary relationship different from a binary relationship?
    A unary relationship exists when an association involves one entity instead of two entities
  7. Why is it important to normalize a database?
    To operate the database efficiently
  8. Why does normalization minimize data redundancy?
    It links tables with common entities
  9. How is a "many-to-many" relationship described in terms of connectivity?
  10. In SQL, the SELECT statement is used to...
    Choose the desired attribute to work with.
  11. How does QBE work?
    Users fill out a grid to find the information they want.
  12. Which language does NOT require extensive programming?
  13. What is the purpose of a determinant?
    To influence the value of another attribute.
  14. The third normal form of a database indicates that...
    All redundant data has been removed from its data tables.
  15. What is meant by functional dependency?
    A way of expressing the value of an attribute that is associated with a value of another.
  16. Which statement in SQL should be used to search data for a given criteria?
  17. What type of information does a data dictionary store? There maybe more than one.
    A) Attributes
    B) Keys
    C) Validity rules/ values
    D) Cardinality
    Attributes, Keys, and Validity rules/ values
  18. ___ is defined as the maximum number of times an instance of one entity can be associated with the instance of another entity.
  19. An ER diagram is used to...
    Plan and design the structure of a database.
  20. A database must have one or more primary keys but may or may not have secondary keys. True or False?
Card Set:
Chapter PI3: Fundamentals of Relational Databases Operations
2016-03-29 04:40:43

Show Answers: