SQL Quiz Chap 1 and 2

  1. In this text, Boyce-Codd normal form is the same as _____.
    • third normal form
    • 3NF
  2. How many tables make up the Premiere Products database?
  3. A record is another term for a(n) _____.
  4. The ORDERS table consists of the order number, order date, and _____.
    customer number
  5. A _____ column is a column that is not part of the primary key.
  6. A field is another term for a(n) _____.
  7. _____ is the formal term for combining two or more columns to form a primary key.
  8. The process of determining the particular tables and columns that will comprise a database is known as _____.
    database design
  9. In an entity-relationship (E-R) diagram, one to many relationships between entities are drawn as _____.
  10. When designing tables a _____ structure is preferred.
  11. _____ is the duplication of data.
  12. (True or False)
    An example of a relationship between categories is the relationship that exists in the Premiere Products database between sales reps and customers.
  13. A relation is in _____ if it does not contain any repeating groups.
    • first normal form
    • 1NF
  14. Each publisher has a _____ that uniquely identifies the publisher at Henry Books.
  15. In an entity-relationship (E-R) diagram, _____ are used to represent an entity.
  16. A(n) _____ is a characteristic or property of an entity.
  17. In a relational database each _____ should be unique.
    row, record, tuple
  18. Premiere Products sells _____.
    appliances, housewares, and sporting goods
  19. A(n) _____ is the association between entities.
  20. Each book at Henry Books is uniquely identified with a(n) _____.
  21. A two-dimensional table of data is called a:
  22. An attribute (or attributes) that uniquely identifies each row in a relation is called a:
    primary key
  23. A relation that contains no multivalued attributes, and has nonkey attributes solely dependent on the primary key, but contains transitive dependencies is in which normal form?
  24. The entity integrity rule states that
    no primary key attribute can be null.
  25. A group of fields related to one topic
  26. A group of related records
  27. a collumn which values are limited to the values of the primary key which it references.
    foreign key
  28. List and explain the steps of the normalization process
    (a) 1NF: Eliminate all repeating values, and identify a primary key or primary composite key.(b) 2NF: Make certain the table is in 1NF, and eliminate any partial dependencies.(c) 3NF: Make certain the table is in 2NF, and remove any transitive dependencies.
  29. Explain Second Normal Form
    a table is in 1NF -and no nonkey column (a column that is not part of the primary key) is dependent on only a portion of the primary key.
  30. a table is in ____ when it does not contain a repeating group.
    • First normal form
    • 1NF
  31. What is the most normal of NF's ("Normal Forms")?
    3rd Normal Form
  32. How do you achieve Third normal form?
    2NF - Look for transitive dependencies (are there non-key attributes that depend on another nonkey attribute?)
  33. bringing back levels of redundancy to increase database performance
  34. the process of eliminating duplicates in a relational database design- converting an entity into tables of progressively smaller degree and cardinality until you reach an optimum level of decomposition
  35. a structure that contains different categories of information and the relationships betwwen these categories.
    a Database
  36. a collection of tables is
    a Relational Database
  37. an ____ is a property of an entity.
  38. a _____ the association between entities
  39. an _____ is like a nousn, it is a person, place, thing, or event.
Card Set
SQL Quiz Chap 1 and 2
SQL, Structured Query Language, Database Quiz Chapter 1 and 2 of A Guide to SQL