Workshop
The following workshop is composed of a series of quiz questions and practical exercises. The quiz questions are designed to test your overall understanding of the current material. The practical exercises are intended to afford you the opportunity to apply the concepts discussed during the current hour, as well as build upon the knowledge acquired in previous hours of study. Please take time to complete the quiz questions and exercises before continuing. Refer to Appendix C, "Answers to Quizzes and Exercises," for answers.
Quiz
| 1: | True or false: Normalization is the process of grouping data into logical related groups. |
| 2: | True or false: Having no duplicate or redundant data in a database, and having everything in the database normalized, is always the best way to go. |
| 3: | True or false: If data is in the third normal form, it is automatically in the first and second normal forms. |
| 4: | What is a major advantage of a denormalized database versus a normalized database? |
| 5: | What are some major disadvantages of denormalization? |
Exercises
| 1: | You are developing a new database for a small company. Take the following data and normalize it. Keep in mind that there would be many more items for a small company than you are given here.
Employees: Angela Smith, secretary, 317-545-6789, RR 1 Box 73, Greensburg, Indiana, 47890, $9.50 hour, date started January 22, 1996, SSN is 323149669. Jack Lee Nelson, salesman, 3334 N Main St, Brownsburg, IN, 45687, 317-852-9901, salary of $35,000.00 year, SSN is 312567342, date started 10/28/95. Customers: Robert's Games and Things, 5612 Lafayette Rd, Indianapolis, IN, 46224, 317-291-7888, customer ID is 432A. Reed's Dairy Bar, 4556 W 10th St, Indianapolis, IN, 46245, 317-271-9823, customer ID is 117A. Customer Orders: Customer ID is 117A, date of last order is December 20, 1999, product ordered was napkins and the product ID is 661. |