This project involves the creation of a centralized relational database and a web interface for World on Wheels (WOW), a leading car rental service provider. The aim was to transition WOW from a file-based system to a sophisticated database management system.
-
Database Design: design and implementation of the centralized relational database using Oracle Data Modeler. This included constructing a comprehensive schema to capture essential data on vehicles, customers, rental services, and office locations.
-
Web Interface Development: Developed a web-accessible frontend interface that enables user interaction with the WOW database. The interface supports registration, login, and CRUD (Create, Read, Update, Delete) operations for both customers and employees.
-
Security Implementation: Ensured robust security measures were in place to protect against SQL injection and cross-site scripting attacks.
-
Advanced SQL Queries: Implemented advanced SQL queries to facilitate dynamic business analysis and reporting.
- Oracle Data Modeler
- SQL
- PHP
- HTML/CSS
- JavaScript
- Parameterized Queries
- Input Validation
- Output Encoding