A screenshot of a database diagram


Recently, I took a class in SQL from CCAC. Since I'd already done a Java project in which I created a quote-creation application for Ellis Wyatt, I figured that for this project, I would create a database to store and manage the resulting data.

I constructed the tables with CREATE TABLE commands and populated those tables using real quote data with INSERT commands. Each table was created with constraints that would be useful in a real-life context to validate data: for example, to ensure that data was entered correctly, I made sure that the total estimated cost of a job was greater than the initial deposit due.

For further reading about this project, download my project write-up.