Question details

Week 4 Normalization of Huffman ERD
$ 15.00

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 offDuty,OnDuty,Driving,Odometer,SleeperBerth

 

 

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

 

Available solutions