1. Design Database Management system for the following.
i. Online Aggregater: Policy [login to view URL] (2 Master Table, 1 Transaction table) -1 page.
ii. Travel advisor MakeMyTrip (2 Master Table, 1 Transaction Table)- 1 page.
Design this as per given details, there should be Primary Key and secondary key all present. Design this in MS Access and export that to MS Word( Master Table and Transaction Table for both, with relationship)
2. Create Bar Chart, Line Chart and Pie chart of any 3 company. The chart should contain Sales, HR and Finance Data.(Any year or month)
For e.g. a company HUL.
So make Sales Bar chart, Line Chart, Pie chart of same.
Now make HR data Bar chart, Line Chart, Pie Chart.
Now for Finance data do the same Bar,Line And Pie.
Do this similar for 3 companies.
If you will deliver this task before 5 September 2018.
Then I will pay INR 500.
INR 250 advance and INR 250 once the work is done.
Work should be done by 5 September 2018 till 11:59PM.
INR 250 advance, INR 250 once it get over.
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design.
Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired.
1) Sql Server 2005/2008/2012
2) MYSQL, MS Access
3) Oracle (PL/SQL)
4) SSIS, SSRS , SSAS and Power BI
5) Data analytics using R-Programming and SAS