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 is a foreign Key referenced in other table.

Table "TimeType"

TimeTypeID

UniqueIdentifer

TimeTypeName

Vachar

This can be offDuty,OnDuty,Driving,Odometer,SleeperBerth

Co-driver Name has been removed from table "Driving Log" as from driverId one can find drivers details.

In "voliations" table state/Municipality Issuing Citation is removed and "stateId" has been added.A new table "State" has been created to hold stateId,state/MunicipalityName.

Table "Sate":

stateID

UniqueIdentifer

Like...