Exam 2 Study Guide

Chapters 5 and 6

Sample Test

Study Topics

Chapter 5

  1. Discuss functional dependence and primary keys
  2. Define first normal form, second normal form, and fourth normal form
  3. Describe the problems associated with tables (relations) that are not in first normal form, second normal form, or third normal form, along with the mechanism for converting to all three
  4. Discuss the problems associated with incorrect conversions to third normal form
  5. Describe the problems associated with tables (relations) that are not in fourth normal form and describe the mechanism for converting to fourth normal form
  6. Understand how normalization is used in the database design process

Chapter 6

  1. Discuss the general process and goals of database design
  2. Define user views and explain their function
  3. Define Database Design Language (DBDL) and use it to document database designs
  4. Create an entity-relationship (E-R) diagram to visually represent a database design
  5. Present a method for database design at the information level and view examples illustrating this method
  6. Explain the physical-level design process
  7. Discuss top-down and bottom-up approaches to database design and examine the advantages and disadvantages of both methods
  8. Use a survey form to obtain information from users prior to beginning the database design process
  9. Review existing documents to obtain information prior to beginning the database design
  10. Discuss special issues related to implementing one-to-one relationships and many-to-many relationships involving more than two entities
  11. Discuss entity subtypes and their relationships to nulls
  12. Learn how to avoid potential problems when merging third normal form relations
  13. Examine the entity-relationship model for representing and designing databases
Topic revision: r1 - 2013-11-12 - JimSkon
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback