A You are approached by a super market owner who sells grocery, counter top medications, cosmetics$,$ and stationary He has outlets in various prime locations in your city. The owner has decided to upgrade his current data base system which stores all the data in a single table. You ans responsible for identifying the various tables required by the super market chain. In this regard, help him to upgrade his databases by doing the following tasks.

a$.$ Identify the entities, attributes, relationship, and give the relational schema required for the database.

$.$ Write create statements to create the required tables. $2$ marks

$-$

Write query to get the details of the product sold for more than Rs$.10000$ from his various branches from the sales data. $2$ marks

Write the relational algebra expression for the SQL query. $2$ marks

Draw the Query tree for the relational algebra expression and calculate the cost assuming the number Calculate of tuples in each table. $2$ marks

$2$ marks