CRM Database

A SQL database built for my Data Analytics class. It is designed to track clients, sales opportunities, and the necessary steps in closing deals.

Highlights

• 6 tables with foreign key relationships
• Sample data (fictional firm Edenava working with Walgreens)
• Tracks everything from initial client contract to project completion

Overview

• Built with SQL (MySQL & MariaDB)

Running it

• Copy the file into any SQL environment (MySQL Preferred)
• Run the program - Tables & sample data are created and inserted automatically
• Query away

What I learned

• Designing databases through ERD's and creating them
• Using foreign keys to maintain relationships between tables
• Modeling business processses in SQL