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.

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.

Relational data can be accessed by database queries written in a relational query language, such

as SQL$,$ or with the assistance of graphical user interfaces. A query allows retrieval of specified

subsets of the data. Here we will use python to access the relational database and to write the

queries.

Deliverables:

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?customer

item

employee

branch

purchases

items$\_$sold

works$\_$at