1: | True or false: Normalization is the process of grouping data into logical related groups. |
A1: | True. |
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. |
A2: | False. Not always; normalization can and does slow performance because more tables must be joined which results in more I/O and CPU time. |
3: | True or false: If data is in the third normal form, it is automatically in the first and second normal forms. |
A3: | True. |
4: | What is a major advantage of a denormalized database versus a normalized database? |
A4: | Improved performance. |
5: | What are some major disadvantages of denormalization? |
A5: | Having redundant and duplicate data takes up valuable space; it is harder to code, and much more data maintenance is required. |
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. | ||||||||||||||||||||||||||||||||||||
A1: |
|