This ER (Entity Relationship) Diagram represents the model of Traffic Monitoring System Entity. The entity-relationship diagram of Traffic Monitoring System shows all the visual instrument of database tables and the relations between Routes, Traffic Polices, Traffic, Vehicle Types etc. It used structure data and to define the relationships between structured data groups of Traffic Monitoring System functionalities. The main entities of the Traffic Monitoring System are Traffic, Routes, Length, Traffic Polices, Divertions and Vehicle Types.
Traffic Monitoring System entities and their attributes :
- Traffic Entity : Attributes of Traffic are traffic_id, traffic_name, traffic_type, traffic_description
- Routes Entity : Attributes of Routes are route_id, route_name, route_type, route_description
- Length Entity : Attributes of Length are length_id, length_name, length_type, length_description
- Traffic Polices Entity : Attributes of Traffic Polices are traffic_police_id, traffic_police_college_id, traffic_police_name, traffic_police_mobile, traffic_police_email, traffic_police_username, traffic_police_password, traffic_police_address
- Divertions Entity : Attributes of Divertions are divertion_id, divertion_name, divertion_type, divertion_description
- Vehicle Types Entity : Attributes of Vehicle Types are vehicle_type_id, vehicle_type_customer_id, vehicle_type_number, vehicle_type_description
Description of Traffic Monitoring System Database :
- The details of Traffic is store into the Traffic tables respective with all tables
- Each entity ( Vehicle Types, Length, Divertions, Routes, Traffic) contains primary key and unique keys.
- The entity Length, Divertions has binded with Traffic, Routes entities with foreign key
- There is one-to-one and one-to-many relationships available between Divertions, Traffic Polices, Vehicle Types, Traffic
- All the entities Traffic, Divertions, Length, Vehicle Types are normalized and reduce duplicacy of records
- We have implemented indexing on each tables of Traffic Monitoring System tables for fast query execution.