Please solve the following problems.

Database schema: Customer(Cust id : integer, cust_name: string) relation_r_i(cust_id, item_id) Item(item id: integer, item_name: string, price: integer) Sale(bill no: integer, bill_date: date, qty_sold: integer) For the above schema, perform the following 1. Create the tables with the appropriate integrity constraints, insert around 10 records in each of the tables 2. Design the relationship set table to associate the relationship among the given entity set. 3. Give a count of how many products have been purchased by each customer. 4. List the total Bill details with the quantity sold, total price of the items 5. List the total Bill details with the customer name, quantity sold and total billable amount. Your report should contain the followings: 1. Introduction to the problem. 2. Problem statement. 3. Designed database (i.e., Relational or Entity Relationship model) 4. Submitted query at the Query processor. 5. Results/output 6. Conclusion