DBM 380 Week 3
in Business (Education) by ayakoYour Price: $15.00 (30% discount)
You Save: $6.43
Description
DBM 380 Week 3
Learning Team Instructions
Continue work on Service Request SR-ht-003, due in Week Five, by completing Change Request 3.
Create documentation that explains the process of creating the entity-relationship diagrams in the change request relative to this project.
Individual ERD Creation Project
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 re-used as a learning team assignment to give more database practice to the class. For this week, the individual assignment includes service requests 2 and 3 of SR-ht-003.
The following assignment refers to material found in the Virtual Organizations.
Create a detailed ERD using the Entities and Attributes for Driver's Log document found on the Huffman Trucking Intranet site.
Use Microsoft Access to create the keys and relationships between tables for the Huffman Trucking Driver Log.
Explain the level of normalization and explain why that level is sufficient.
Submit the ERD, the explanation, and the database together.
Discussion Questions
Wang and Gong (2007) explain how database management systems (DBMS) and data mining can help a motor vehicle maintenance center improve its services. Based on your reading of the article, which tables are needed in such a database? In which additional waybeyond those mentioned in the articlecan the DBMS and data mining be used to improve customer service?
Why do you think the use of icons in entity-relationship diagrams as described in the Masri (2008) article resulted in a better understanding of these complex diagrams by users?