1)Designed a database building an Enhanced E-R diagram.
2)Transformed the E-R diagram into a relational database drawing relational integrality constraints followed by normalizing.
3)Connected MySQL database with Excel using VBA.NET
3)Created a GUI for the end users by designing forms and coding the Buttons with fuctionality of DML,DDL scripts.
4)This resulted in Speedy Computation,improved quality of decision making,increased organizational control.
5)Effectively reduced the time required to retrieve Data for making Financial Reports.
Tech Stack - MySQL,RDBMS,VBA,ASP.NET, Excel.