The Islamabad Traffic Police (ITP) department is looking for a person who can develop Traffic Challan Management System (TCMS). It will be a database application to manage information about challans that are charged against vehicles due to violation of traffic rules on roads and parking. The information about traffic violation rules and fine can be found at the link below. (https://www.islamabadtrafficpolice.gov.pk/violation-and-fine.php)

This application will store the following information:

When and where a traffic rule is violated?

Who violated the rule?

Which type of vehicle was used?

How much challan is charged against the violator?

When the challan amount is paid and what was the paying method?

You can add more information of your choice to make the application more meaningful.

Tasks to do:

1) Create Conceptual Database Design using ER diagram.

2) Create Logical Database Design by converting ER diagram into Relational Model