Resources: Huffman Trucking Virtual Organization (attached)
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.
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.
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.