The purpose of this project is to use Visio and SQL Server Management Studio to design and implement an ebusiness database that provides a well-organized system which enables users to store and manage data generated during each stage of online shopping process.

Key Complements

• Performed market research and designed relational database of e-business store for use in Visio 2010
• Populated table and data with 4 schemas in SQL Management Studio, including customers, products, order details and staff
• Utilized SQL subqueries and analytical functions to create computed columns, add encryptions and create views
• Generated interactive visualizations and sales report using Power BI

Contents