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...