Anishma K S

REAL TIME PROJECTS:

Recommendation system:

• An algorithm to help the customers to choose the type of insurance policy that serves their purpose.
• Using the previously available data, a data frame is created with policy name and its details.
• Bag of words technique is used to build an algorithm to capture the root word of each policies.
• When the user enter the details of policy like the year,sum insured,type of goods,expected term the algorithm would apprehend and return the best 5 recommended policies.

Inventory Mangement(SQL):

• Tables for the customers,available stocks of vehicles,automobile part suppliers were created in the database.
• Procedures are created to add each customer and supplier details into the respective tables.
• Sequences are used to generate the customer ID's and Supplier Id's.
• For each order of auto parts,triggers are created to update the stock table accordingly.
• Purchase table gets update with the help of triggers when stocks falls below a particular order level.