SQLite SQL VS Code draw.io Data modelling Uni project

Screenshots

Overview

This Data Modelling project is a comprehensive exercise in data modelling and database design. The aim of the project was to design and implement a relational database to manage the fleet of hire vehicles for a fictional car rental company.

Technical details

Technologies and Tools used

Tech/Tool	Usage
SQLite	Database building
SQL	Database querying language
VS Code	IDE
draw.io	Diagram creating

Tasks

Construct the information model, including:
- Entity Data Dictionary
- Relationship Data Dictionary
- Relationship-Entity Data Dictionary
- Attributes Data Dictionary
Draw up an Entity-Relationship Diagram (ERD)
Construct the logical model
Build a SQL database using SQLite
Populate the database with sample data and execute queries to ensure that the schema was correctly implemented.

Reflection

During the Data Modelling project, I had the opportunity to improve my skills in data modelling and SQL.

The schema design proved to be a challenging task, which required careful consideration of table relationships and data normalization to enhance efficiency. The use of draw.io aided me in identifying potential issues and refining the schema.

Working with SQLite was a new experience, but I found it to be a powerful and user-friendly tool for database creation and management. This project allowed me to practically apply my knowledge, and I gained valuable experience working with SQLite.

Source code

Unfortunately, this is a uni project so the source code and the whole report cannot be shared due to academic integrity and intellectual property concerns.