2
android
1
biopython
3
bootstrap
1
c-plus-plus
2
c-sharp
6
css
2
cv2
2
firebase
1
flex-lexical-analysis
6
fontawesome
2
game
2
google-maps
3
hobby
6
html
1
jasypt
8
java
1
java-spark
6
javascript
3
jquery
1
jstl
1
laravel
3
matplotlib
1
mockaroo
2
multithreading
3
mysql
1
neat-algorithm
3
netlify
1
networkx
1
neural-networks
6
numpy
2
pandas
1
php
2
pillow
2
postgresql
9
python
3
react
1
reinforcement-learning
1
scikit-image
2
scikit-learn
1
scipy
2
servlets
7
sql
2
sqlite
3
tailwindcss
2
tomcat
19
university
3
visual-studio
6
web-app
2
website
Relational DBMS 1
Involved in this project: Panos Ioannidis, Dionisis Nikas
A SQL based project that was developed as an assignment for the subject of Databases. The goal of this project is to design a relational database for storing the data of a car dealership company. We generated hypothetical database entries using Mockaroo for random data generation. We designed SQL queries for creating tables, managing records, filtering and defining relationships. We perform database normalization based on Third-Normal-Form (3NF) and Boyce-Codd Normal Form (BCNF). We setup triggers and cursors to ensure data integrity and perform maintenance. Finally, we have written a program in Java using the JDBC client to simulate real world consumption of the database.