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 are responsible for identifying the various tables required by the super market chain. In this regard, help him to upgrade his database by doing the following tasks.

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

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

c$.$ 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

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

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