A complete relational database system designed for a consulting business as part of the Database Management (MIS 370) course at DePaul University.
This project demonstrates database design, optimization, and SQL reporting using Microsoft SQL Server and Microsoft Visio.
This project was developed to model and implement a real-world consulting database system from the ground up.
It integrates data modeling, normalization, SQL programming, and reporting to simulate how data flows across clients, consultants, and contracts in a consulting business environment.
- Microsoft SQL Server Management Studio (SSMS) – for schema creation, data population, and SQL queries
- Microsoft Visio – for Entity-Relationship Diagram (ERD) and 3NF Relational Schema design
- SQL – to create, normalize, and query data
- GitHub – to document and version-control the project
- Entity-Relationship Diagram (ERD) – designed in Visio to model entities and relationships
- 3NF Relational Schema – demonstrates normalization to eliminate redundancy
- SQL Code – includes DDL (table creation) and DML (data insertion) scripts
- 10 Analytical Reports – queries answering business questions with joins, grouping, and filtering
- Project Documentation (PDF) – full write-up and rationale for design choices
📄 Download Final Project Report (PDF)
This diagram illustrates the key entities and their relationships within the consulting database.
The database was normalized to Third Normal Form (3NF) to eliminate redundancy and maintain referential integrity.
The Relational Diagram visually maps the logical connections between tables after normalization.
CLIENT(CLIENT_ID, CLIENT_FNAME, CLIENT_LNAME, CLIENT_MINITIAL, REGION_ID, ADDRESS, CITY, STATE, ZIP_CODE, CLIENT_SSN, EMAIL, PHONE)
CONTRACT(CONTRACT_ID, CLIENT_ID, CONTRACT_START, CONTRACT_END, CONTRACT_AMOUNT)
REGION(REGION_ID, REGION_NAME)
CONSULTANT(CONSULTANT_ID, CONSULTANT_FNAME, CONSULTANT_LNAME, CONSULTANT_MINITIAL, REGION_ID, CONSULTANT_EXPERIENCE, CONSULTANT_SSN, PHONE, EMAIL)
CLASS(CLASS_ID, CLASS_NAME)
CONTRACT_CONSULTANT(CONTRACT_ID, CONSULTANT_ID)
CONTRACT_CLASS(CONTRACT_ID, CLASS_ID)
CONSULTANT_CLASS(CONSULTANT_ID, CLASS_ID)
Below are 10 example reports generated from the Consulting Database project.
| Report | Screenshot |
|---|---|
| Report 1: Consultants Contact Directory |  |
| Report 2: Clients Registry |  |
| Report 3: Contracts Overview |  |
| Report 4: Clients vs Consultants by Region |  |
| Report 5: Consultants by Region and Class |  |
| Report 6: Active vs Completed Contracts |  |
| Report 7: Revenue by Region |  |
| Report 8: Average Consultant Experience |  |
| Report 9: Contracts per Class |  |
| Report 10: Consultant-Class Assignments |  |
- Open Microsoft SQL Server Management Studio (SSMS).
- Create a new database (e.g.,
ConsultingDB). - Execute the schema and data scripts from
reports/SQL_Reports.sql. - Run the 10 report queries to reproduce the screenshots shown above.
- (Optional) View the ERD and 3NF Schema diagrams in Microsoft Visio.