Chapter PI3: Fundamentals of Relational Databases Operations

Home > Preview

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?
    Join
  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?
    Binary
  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?
    QBE
  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?
    WHERE
  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.
    Cardinality
  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?
    True

Card Set Information

Author:
hunter82
ID:
318089
Filename:
Chapter PI3: Fundamentals of Relational Databases Operations
Updated:
2016-03-29 04:40:43
Tags:
Info
Folders:

Description:
slkfdjaldj
Show Answers:

Home > Flashcards > Print Preview