MS Access and ERD Normalization
Not what you're looking for?
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.