Answer 1

for traffic management first you have to take all instructions coded in python and you have to take the signal function where u can define what signal will be at the console by which other can understand so import random connect with signal light and attach this with timer or counter who count the signal time
make use of different direction Vichel and manage them by which the deadlock condition not occurred
then you have to create an database for your management system in sql to execute this sql query with your python filehandling you should write connectivity code then you have to use that sql query in your python code by take input in this way your database is fetch by the python code and you can able to perform that query