Adewale Adelanwa

Project: Secure Booking System – Data Security & SQL Database Design Overview Developed a secure and scalable online booking system for a hotel, combining Python-based security features with a fully designed SQL database. The project demonstrates strong capability in data security, database design, and operational query development. Key Objectives ●​ Implement password validation, encryption/decryption, and multi-factor authentication. ●​ Design a complete ER diagram capturing all entities and relationships. ●​ Build the SQL database schema and insert diverse sample records. ●​ Write SQL queries to support real booking, customer, and product operations. Tools & Technologies Python, SQL, ERD Modelling Tools, Encryption Libraries, Authentication Workflows What I Delivered Security Features (Python) ●​ Password strength validation ●​ AES-style encryption/decryption ●​ Multi-factor authentication workflow Database Design (SQL) ●​ ER diagram with correct cardinalities ●​ Tables for customers, employees, products, orders, genres, payments, cities ●​ Inserted multiple data records to mimic real system usage SQL Query Set ●​ ●​ ●​ ●​ ●​ Customers by city Products by genre Count of customers per city Average unit price Current orders ●​ ●​ ●​ ●​ ●​ Orders with “the” in description Credit-card payments for music records Employees handling music records Employees with names starting with ‘S’ Total number of orders Outcome ●​ ●​ ●​ ●​ Delivered a secure, structured booking system foundation Strengthened customer data protection and compliance Provided a scalable database supporting booking operations and reporting Demonstrated full-stack capabilities across security, SQL, and system design​