Data Analysis: SQL Project – Car Dealership

All Homework Must be Uploaded to it own GitHub repository. You will copy the URL Link for your GitHub Repository and Submit that link for each of your homework assignments

SQL Project – Car Dealership:

Using the document of business rules [See Materials Tab] for the car dealership, you will need to come up with an ERD using lucidchart.com.

Once you have come to a conclusion, you will then create a new database using the ERD.

The files needed to be turned in are:
The ERD PDF
SQL code that would be used to create the new database.

Once the database has been created, students should create their own database inside of DBeaver. Also, once the database and the tables are created, each student should have AT LEAST 2 pieces/records of data inside of the tables. (You can add more if you want)

At least 2 of the inserts should come from a stored function. (You can always add more if you want)

Once the code is completed, commit both the PDF of the ERD diagram and the SQL code to GitHub and submit the GitHub link to the assignment.