This project demonstrates my foundational SQL skills by designing and implementing a relational database for a trucking company called RGI Truck. The database models key business entities such as drivers, trucks, licences, routes, employees, and maintenance requests while maintaining data integrity through primary and foreign key relationships.
- Created a relational database using SQL.
- Designed multiple tables with appropriate primary and foreign keys.
- Implemented one-to-many relationships between business entities.
- Demonstrated the use of supertype and subtype tables for employees.
- Inserted sample data into each table.
- Retrieved data using SQL
JOINstatements to combine information from multiple tables.
The database includes the following tables:
- Driver
- Licence
- Truck
- Route
- Employee
- Dispatcher
- FirstResponder
- Mechanic
- Clerk
- Maintenance_Query
- Database creation
- Table creation (
CREATE TABLE) - Primary and foreign keys
- Referential integrity
- Data insertion (
INSERT INTO) - Data retrieval (
SELECT) - Table joins (
INNER JOIN)
This project was completed to demonstrate my understanding of basic SQL database design, data modelling, and querying techniques. It showcases the fundamental SQL skills required for database development and data analysis.
- SQL
- MySQL