Explore BrainMass

Huffman Trucking Virtual Organization

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Resources: Huffman Trucking Virtual Organization (attached)

Review the information currently housed in Huffman Trucking's database, in the Entities and Attributes for Fleet Truck Maintenance file on the virtual Organizations site.

Create a Microsoft® Visio® Logical ERD, based on the Entities and Attributes for Fleet Truck Maintenance document, and any additional information needed to normalize the database.

Ensure that your entities are properly normalized. Properly annotate the entities, primary keys, foreign keys, and relationships in your ERD. All relationships should be one-to-many. Use the crow's feet notation for your ERD. Every entity should be related to at least one other entity.

Create table design metadata specifications in a Microsoft® Excel® spreadsheet based on your ERD. Indicate primary keys, foreign keys, and new attributes as in the entity relationship diagram.

For each table in your metadata, indicate the table's name, the columns in the table, the data types for the columns, the sizes of the columns, the primary keys, the foreign keys, the required/NOT NULL columns, the default values, and the range of legal values for the columns.

© BrainMass Inc. brainmass.com October 25, 2018, 8:00 am ad1c9bdddf


Solution Summary

This solution helps design a database model for the Huffman Trucking Virtual Organization. It contains logical ERDs and metadata specifications based on a relational database model.

See Also This Related BrainMass Solution

Strategic Quality Management and Customer Satisfaction

Process Analysis
Analyze processes in quality improvement.
Utilize quality management tools to present data.

750-word paper in which you complete the following:
Describe how quality is linked to the organization's strategic plan and strategic objectives.

Provide an analysis of a process improvement plan that the organization currently utilizes.

Include examples of the tools and techniques used to measure quality and customer satisfaction within your selected organization.

Identify who has ultimate responsibility for quality assurance.
Explain the extent to which the organization's process improvement plan is related to the organization's strategic plan.

Format your paper according to APA standards.

View Full Posting Details