Purchase Solution

MS Access and ERD Normalization

Not what you're looking for?

Ask Custom Question

MUST USE Microsoft Access, create the keys and relationships between tables for the Huffman Trucking Driver Log for the original tables. Please make sure you include the primary and foreign keys for all 3 tables.
Part 2.B-Normalize the ERD and explain the level of normalization. The explanation can be done in a word document where you explain what changes to the tables you would make to achieve a specific level of normalization. You should submit the explanation, the ERD and the database showing the Primary and foreign keys in your individual forum. ***Note: Please do not normalize the Access tables that you are submitting in step one above and combine part 2.A and 2.B together in the same file.

Purchase this Solution

Solution Summary

The expert examines MS access and ERD normalization.

Solution Preview

Normalization of Huffman ERD

The repeating groups are Driving Log have been removed and placed in another table.
OffDutyStartTime1,OffDutyStartTime1, OffDutyStopTime2,OffDutyStopTime2
Can be place to a new table called "TimeTable".Timetable has startTime,stopTime and TypeOfTimeId.Note.TypeOfTimeID is a foreign Key referenced in other table.
Table "TimeType"
TimeTypeID
UniqueIdentifer

TimeTypeName Vachar This can be ...

Purchase this Solution


Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Networking Questions

This quiz consists of some basic networking questions.