A relational database for AllElectronics. The AllElectronics company is described by the following

relation tables: customer, item, employee, and branch. Fragments of the tables described here

are shown in the Figure. Please fill up the tables with $10$ entries each.

Write the Python code to get the following results.

$1.$ Name the top selling product $($by qty not by amount$)$ say product X among branch.

$2.$ What is the most frequent item brought along with product X among all branch.

$3.$ Name the top selling product $($by qty not by amount$)$ say product M for each branch.

$4.$ What is the most frequent item brought along with product M for each branch.

$5.$ List the min and max sales transactions occurred in the month of December.customer

ifem

employee

branch

purchases

inems$\_$sold

works$\_$at