Traffic_Camera

idnamelocation
1Cam1Downtown
2Cam2Highway Entrance
3Cam3Highway Exit
4Cam4Main Street
5Cam5Side Street

Function

idfunctionName
1Speeding
2Accident Detection
3Lane Departure Warning
4Weather Monitoring
5Pedestrian Detection

Traffic_Camera_Function

cameraIdfunctionId
(→ Traffic_Camera.id)(→ Function.id)
11
21
31
41
51
51

Road_Condition

idroadIdcondition
11None
22None
33None
44None
55None

Camera_Road_Link

cameraIdroadId
(→ Traffic_Camera.id)(→ Road_Condition.id)
11
22
33
44
55