A relational database for AllElectronics. The AllElectronics company is described by customer

item

employee

branch

purchases

items$\_$sold

works$\_$atthe 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.

The relation customer consists of a set of attributes, including a unique customer identity number

$($cust ID$),$ customer name, address, age, occupation, annual income, credit information, category,

and so on$.$

Similarly, each of the relations item, employee, and branch consists of a set of attributes

describing their properties.

Use python to access the relational database and to write the

queries.

Deliverables:

Please fill up the tables with $10$ entries each.

Write the Python code to get the following results.

$1.$ Show the list of all made in India items.

$2.$ Show the list of customers with age $30$ to $40.$

$3.$ List the employees having salary more than $1$ Lakh.

$4.$ Calculate the total amount sold by E$55$ employee.

$5.$ Which sales person had the highest amount of sales?