DBM 380 Week 4

Learning Team Instructions

Continue work on Service Request SR-ht-003, due in Week Five, by completing Change Requests 4 and 5.

Create documentation describing the principles and importance of normalization in relation to this project and the process by which this project was normalized.

Individual Normalization of the ERD

For this assignment, you are to use the same general material as is used for the Team project. You are to do service requests 2, 3, and 5 of SR-ht-003. The individual assignment portions are due in Weeks 3 and 4, and are purposely being used as an individual assignment, and then, as a learning team assignment, to give more database practice to the class.

For this week, the individual assignment includes service request 5 of SR-ht-003. I want you to create six total queries two of which are to be one table queries, two of which must use two tables, and two queries must use three tables (or more).

Also, make any changes to the db based on feedback (if any) from the instructor on your Week 3 deliverable, or you will lose points. .

Use Microsoft Access to create the queries and make any changes as described above (if necessary) on the tables for the Huffman Trucking Driver Log.

Submit the final database.

Discussion Questions

Based on the Chen (2007) article, why must a database administrator consider more than just function dependency during the normalization process?

Do you consider the new approach to teaching the concepts of database normalization introduced in the Wang (2010) article easier for you to grasp? Explain why.