For a telecommunications company, a personnel bonus and objection tracking system will be developed. The system to be developed aims to track monthly bonuses for customer representatives $($assistants$).$ Each assistant works under the supervision of a "team leader". The team leaders, in turn, work under the supervision of "group managers".

The assistants handle calls from customers at the call center. Assistants receive monthly bonuses based on the number of calls with customers and issue resolution.

Assistant$/$Customer Representative:

There should be a screen to record calls between assistants and customers. The assistant's ID number, first and last name, the customer's name, call subject, date and time of the call, and call status should be recorded in the database.

Call Subject:

Breakdown

Request

Information

Call Status:

Completed

In progress

Unresolved issue

For assistants logging into the system, there should be three modules in the menu:

Menu for the list of customer calls

Menu for the list of monthly bonuses for assistants active in the system

Menu for the list of objections from assistants regarding their bonuses

Menu for the list of customer calls:

When this menu is selected, all calls received by the assistant should be listed. This menu should include a "New Call" button.

By clicking on "New Call", a pop$-$up window should open allowing the assistant to enter the following information about the call: customer's first and last name, call subject, date, and time of the call. When the assistant clicks "Save", the corresponding record should be displayed at the top of the list of customer calls.

Menu for the list of monthly bonuses for assistants:

In this menu, assistants should be able to see their list of monthly bonuses. For the last listed month, there should be a "Dispute" button. By clicking on "Dispute", a pop$-$up window opens allowing the assistant to write an explanation of the objection and click "Send". After clicking "Send", the corresponding objection for the assistant and the relevant month should be recorded in the system. Additionally, an email regarding the objection should be sent to the group manager's team leader.

Menu for the list of objections from assistants regarding their bonuses:

The assistant should be able to see the list of their objections in this menu. This list should display the objection explanation, the response to the objection $($response given by the team leader$),$ and the objection status $($pending$,$ approved, or rejected$).$

For team leaders logging into the system, there should be one module:

Menu for the list of objections from assistants regarding their bonuses

When they log in$,$ team leaders should be able to see the list of objections recorded by the assistants under their supervision. This list should include the assistant's ID number, first and last name, the objection explanation, and the relevant month. Additionally, for unresolved objections, there should be a "Respond to Objection" button on the corresponding objection line. By clicking on this button, a pop$-$up window opens allowing the team leader to write a response to the objection and click "Send". After clicking "Send", the objection status should be updated for both the team leader and the assistant. Furthermore, an email regarding the objection status should be sent to the group manager.

The bonus calculation should be as follows:

Monthly base bonus: $5000$TL

An assistant receiving fewer than $100$ customer calls per day should not receive a bonus. The bonus description for an assistant not receiving a bonus should be $"$No bonus deserved".

For an assistant receiving between $100$ and $200($excluding$)$ calls per month, the bonus amount is: Monthly base bonus $+($number of calls under $5$ minutes$)$ X $1\mathrm{.}25$

For an assistant receiving $200$ or more calls per month, the bonus amount is: Monthly base bonus $+($number of calls under $5$ minutes$)$ X $2$

Project Requirements:

A relational database management system will be used.

There should be at least $10$ tables in the database.

At least $4$ stored procedures should be used in the project.

At least $2$ functions should be used in the project.

At least $2$ views should be used for report$/$list screens.

A job should be written. This job should calculate the assistants' bonuses at the end of each month.

There should be at least $1$ trigger as part of the project.

Normalization rules should be considered.

Key and constraint concepts should be considered.

and provide the different codes and steps, as well as the database, views, functions, and stored procedures as it s written